I have a master budget with a summary on one worksheet, and department budgets on subsequent sheets. When there is a number on the summary sheet, I want to know which budget it came from - so I'm trying to build a table which has the budget gl codes down the first column and the department budgets in subsequent columns.
Currently, I'm copy and pasting the columns, but it burns me - knowing there must be a way to do it with formulas. The column title is the sheet name. Its getting formulas to change in an automated fashion.
I know this isn't the best description, but perhaps it is clear enough...
How to write formulas so they collect standardized info from another worksheet?
Copying columns of data on multiple sheets in another worksheet