Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Many sheets combined on one
I have a workbook that has sheets upon sheets that are named with dates
(mostly two per month) Each sheet is the exact same columns. LastName, FirstName, Date, Hired (and others) the person that was keeping the report would copy and past at the end of each day what she entered on the sheet to the "Consolidated" sheet. I was wondering is there a way that I can have the consolidated sheet update every time I enter info on different sheets in the same workbook. I have no clue how the last person kept up with what she did each day and kept track of it all. I am an Access user and eventually would like to take this report there but the boss isn't willing to change yet, so I would love some info on how I can get Excel to do this if possible. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Many sheets combined on one
Excel 2007
Consolidate Tables Automatic update with new data entry. Table on each sheet can vary in location, and row/column size and order. No formulas used. Some VBA required. http://www.mediafire.com/file/wddmnu...01_14_09a.xlsm |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Many sheets combined on one
There is one more way, all the other where in you are required to enter the
data manually you can do one thing. =Sheet1!A1 say for eg your data is in sheeti then in sheet2 cell A1 you can enter this formula and simply drag this cell. By doing this you are copying the same formula in all the cells. Now whenever you enter/edit any data in sheet1 the related other sheets will automatically get updated without you doing a manual business. Hope i have answered the question. -- Thanks Suleman Peerzade "Becca" wrote: I have a workbook that has sheets upon sheets that are named with dates (mostly two per month) Each sheet is the exact same columns. LastName, FirstName, Date, Hired (and others) the person that was keeping the report would copy and past at the end of each day what she entered on the sheet to the "Consolidated" sheet. I was wondering is there a way that I can have the consolidated sheet update every time I enter info on different sheets in the same workbook. I have no clue how the last person kept up with what she did each day and kept track of it all. I am an Access user and eventually would like to take this report there but the boss isn't willing to change yet, so I would love some info on how I can get Excel to do this if possible. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP combined with AND | Excel Discussion (Misc queries) | |||
Use of Combined IF and AND statements | Excel Discussion (Misc queries) | |||
If combined with OR & AND | Excel Discussion (Misc queries) | |||
Combined ROUNDUP | Excel Worksheet Functions | |||
Combined Statements | Excel Discussion (Misc queries) |