Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Combining different sheets with automatic add in?
I am currently working on a very big file to help for the forecasting for a
group of companies.(total 245 sheets) There are 4 companies and Each company has a seperate list of accounts with balances under the same group headings and with the same colums but with different account numbers (which are alfanumeric). What I want to do produce is on a new sheet a seperate list keeping the same format but under each heading grouping each companies accounts and adjacent data. Also if a new account is added to one of the seperate sheets have this automatically added to the consolidated one. Hope you can help -- Thanks, TKA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combining data from multiple sheets | Excel Discussion (Misc queries) | |||
combining data from multiple sheets | Excel Worksheet Functions | |||
Copying multiple sheets from one book 2 another and undertake spec | Excel Discussion (Misc queries) | |||
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
Multiple sheets selected | Excel Discussion (Misc queries) |