Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Comparative spreadsheets
I have 3 worksheets, this years income by month, last years income by month
and this years budget by month. I have created a forth worksheet the compares the monthly data and the year to date data from the first 3 worksheets. However, I don't want to change the formula for year month or create separate worksheet for each month of comparison. Is there any way thay if I have the word "March" in the comparative worksheet the comparative worksheet will reference the march data from the first 3 worksheets and also the year to date data for January to March. If I change the word to "June" it will automatically change the comparative data to reflect the June data and the year to date data up to June from the 3 spreadsheets. Please help. Thanks |
#2
|
|||
|
|||
"Abe" wrote...
I have 3 worksheets, this years income by month, last years income by month and this years budget by month. I have created a forth worksheet the compares the monthly data and the year to date data from the first 3 worksheets. However, I don't want to change the formula for year month or create separate worksheet for each month of comparison. Is there any way thay if I have the word "March" in the comparative worksheet the comparative worksheet will reference the march data from the first 3 worksheets and also the year to date data for January to March. If I change the word to "June" it will automatically change the comparative data to reflect the June data and the year to date data up to June from the 3 spreadsheets. How is your monthly and monthly YTD data laid out in these other worksheets? It's possible you could use simple lookup functions. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need funct to match data in 3 seperate spreadsheets column 1 to v. | Excel Discussion (Misc queries) | |||
Comparing Spreadsheets | Excel Worksheet Functions | |||
Two spreadsheets linked - moving cells | Excel Discussion (Misc queries) | |||
How do I get my actuarial spreadsheets to comply with SOx? | Excel Discussion (Misc queries) | |||
How can I get a total across multiple spreadsheets? | Excel Worksheet Functions |