One formula required to copy information from YTD spreadsheet onto individual monthly spreadsheets.

macropod · #2 10-01-2015, 02:19 PM

Quote:

Originally Posted by Jo Freeman

My question is, is there a formula I could enter that will not require changing each month?

There certainly are such formulae, but we'd need to see a sample workbook containing both YTD data and the monthly report do give specific advice. Can you attach a workbook to a post with some representative data (delete anything sensitive)? You do this via the paperclip symbol on the 'Go Advanced' tab at the bottom of this screen.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
formula for monthly sum	paulys	Excel	1	08-23-2014 09:44 AM
Copy Column setting to other spreadsheets in an excel workbook	officeboy09	Excel	5	11-05-2013 01:49 AM
Monthly Growth Rate Formula	meggenm	Excel	2	04-22-2013 09:21 PM
Copy data from spreadsheets to a two, with the sum criterion	marreco	Excel Programming	1	05-15-2012 04:15 PM
Formula Help Required	OTPM	Excel	6	08-31-2011 02:58 AM