Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summarising information from different sheets in a summary sheet
Dear Excel experts,
I am stuck with a problem here which I am trying to solve manually, but knowing Excel, there MUST be a more efficient (time-saving and less prone to mistakes) way to deal with this. The essence of the problem is as follows: - Let's say I have a workbook with 4 worksheets - Summary, CompanyX, CompanyY, CompanyZ (in reality, I need to update three workbooks with 100+ sheets quarterly and reflect them in the "Summary" sheet) - Eeach of the "Company" sheets follows the same format (with most important information - let's say (a) company name, (b) number of staff, (c) address and (d) sales - all placed in the same cell locations) - The summary sheet summarises (1) Companies against (2) No of staff / Address / Sales etc. For the time being, I am creating references for company names by pointing to each individual sheet and have to do the same for the second part but there is certainly a way to automatise referencing to different sheets?! I would expect that I'd have to do this manually for the first company but could then do something like ="CompanyA+1"!A2 (read: look up the same cell, A2, in one sheet after the "CompanyA) but this is not working. Any ideas what WOULD work? Thanks a million, N. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to get sum from one 31 sheets to a summary sheet. | Excel Discussion (Misc queries) | |||
Summary Sheet help with multiple sheets | Excel Discussion (Misc queries) | |||
Displaying information (contained in defined names) on a summary sheet, in different row numbers? | Excel Discussion (Misc queries) | |||
Summarising Information from other files | Excel Discussion (Misc queries) | |||
Creating A Summary Sheet With Information From Several Worksheets | Excel Discussion (Misc queries) |