Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summarise Multiple Worksheets
I have created a sheet and duplicated this sheet on multiple sheets as it is
a standard form that needs to be completed for payment requests. I then created another sheet in the same spreadsheet where i want to summarize all these individual sheets, meaning i want to extract exactly the same information from each sheet into the summary sheet. I have set up the first line by saying for instance A1=Sheet1A1 now how do i copy this formula down so that the next formula is A2=Sheet2A1 and so forth. This must be possible its such a simple thing but i cannot seems to find it on the help menu. Anybody out there that can help. Thanx Louise |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Summarise multiple sheets | Excel Discussion (Misc queries) | |||
create sheet to summarise invoices on other worksheets | Excel Discussion (Misc queries) | |||
How to summarise data in the same place in multiple worksheets? | Excel Discussion (Misc queries) | |||
summarise totals from many worksheets into one final worksheet | Excel Worksheet Functions | |||
Summarise data on multiple sheets | Excel Worksheet Functions |