Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi again Excel 2007 boffins.
I have multiple worksheets within a workbook each tab with custom names that each contain specific contract data. I have a summary page but all summary data is generated manually by my using '=' then clicking specific wooksheet tab, clicking cell and 'enter'. My data in the worksheets is not arranged by column headers. Surely there is a formula likely built around vlookup that could make this less manually intensive. Thank you. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Assuming your "child" individual contract sheets are identically structured
here's a fast n easy way to build a summary using INDIRECT .. In the Summary sheet, List the "child" sheetnames in B1 across, eg: Con1, Con2, etc (sheetnames must tally exactly with what's on the tabs, except for case) In A2 down, list the cell references to extract data from eg: B2, C3, etc Then place this in B2: =IF(COUNTA($A2,B$1)<2,"",INDIRECT("'"&B$1&"'!"&$A2 )) Copy across & fill down to populate -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Drew" wrote in message ... Hi again Excel 2007 boffins. I have multiple worksheets within a workbook each tab with custom names that each contain specific contract data. I have a summary page but all summary data is generated manually by my using '=' then clicking specific wooksheet tab, clicking cell and 'enter'. My data in the worksheets is not arranged by column headers. Surely there is a formula likely built around vlookup that could make this less manually intensive. Thank you. |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Max ... thanks so very much.
After adjusting to transpose columns and rows plus position on summary page it works beautifully. "Max" wrote in message ... Assuming your "child" individual contract sheets are identically structured here's a fast n easy way to build a summary using INDIRECT .. In the Summary sheet, List the "child" sheetnames in B1 across, eg: Con1, Con2, etc (sheetnames must tally exactly with what's on the tabs, except for case) In A2 down, list the cell references to extract data from eg: B2, C3, etc Then place this in B2: =IF(COUNTA($A2,B$1)<2,"",INDIRECT("'"&B$1&"'!"&$A2 )) Copy across & fill down to populate -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Drew" wrote in message ... Hi again Excel 2007 boffins. I have multiple worksheets within a workbook each tab with custom names that each contain specific contract data. I have a summary page but all summary data is generated manually by my using '=' then clicking specific wooksheet tab, clicking cell and 'enter'. My data in the worksheets is not arranged by column headers. Surely there is a formula likely built around vlookup that could make this less manually intensive. Thank you. |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
welcome, Drew
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Drew" wrote in message ... Max ... thanks so very much. After adjusting to transpose columns and rows plus position on summary page it works beautifully. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
summary sheet that refers to multiple sheets | Excel Discussion (Misc queries) | |||
LINKING MAIN SHEET WITH MULTIPLE SUMMARY SHEETS | Excel Worksheet Functions | |||
Summary Sheet - Total Multiple Sheets | Excel Discussion (Misc queries) | |||
Summary Sheet help with multiple sheets | Excel Discussion (Misc queries) | |||
linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) |