Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Building a summary page, and need some help
I have a the following scernario. I have a tab with data that i need
summarized in another tab and some consolodation. a b c d e 1 Data Data Data Data 2 Data Data Data Data 3 4 5 Data Data Data Data 6 7 8 Data Data Data Data In the summary sheet i need rows in this example Rows 1,2,5,8 to be brough over to the summary table. 1 Data Data Data Data 2 Data Data Data Data 5 Data Data Data Data 8 Data Data Data Data The problem is, that this needs to be dynamic, i.e. no blanks, and will need to grow, so the next time i may need a summary of all rows 1-8, or the data may grow, and i'll need a summary of 1 - 30 (with sporadic ommisions) I hope you all can help. Thanks Tim |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Building a summary page, and need some help
Paste this in A1 of sheet 2
=INDIRECT("Sheet1!R"&SMALL(IF(Sheet1!$A$1:$A$255< "",ROW($1:$255)),ROW())&"C"&COLUMN(),FALSE) and press CTRL-SHIFT-ENTER then copy it to E1 and down to as many rows as you want... It will give you #NUM! error from (n+10 row if sheet1 has n non-blank rows... It will be easier to filter on non-blank values and copy-paste in sheet2 You can record a macro and either manually execute it or when you activate sheet2 "T5s" wrote: I have a the following scernario. I have a tab with data that i need summarized in another tab and some consolodation. a b c d e 1 Data Data Data Data 2 Data Data Data Data 3 4 5 Data Data Data Data 6 7 8 Data Data Data Data In the summary sheet i need rows in this example Rows 1,2,5,8 to be brough over to the summary table. 1 Data Data Data Data 2 Data Data Data Data 5 Data Data Data Data 8 Data Data Data Data The problem is, that this needs to be dynamic, i.e. no blanks, and will need to grow, so the next time i may need a summary of all rows 1-8, or the data may grow, and i'll need a summary of 1 - 30 (with sporadic ommisions) I hope you all can help. Thanks Tim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Summary Page | Excel Worksheet Functions | |||
Creating a summary page | Excel Discussion (Misc queries) | |||
Excel "Worksheet Name" Building Function for Summary Sheet | Excel Discussion (Misc queries) | |||
Summary page | Excel Discussion (Misc queries) | |||
Creating a summary Page | Excel Discussion (Misc queries) |