Copying columns of data on multiple sheets in another worksheet [Closed]

Report
Posts
1
Registration date
Tuesday June 16, 2015
Status
Member
Last seen
June 16, 2015
-
Hello,
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?

Thanks!

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!