Building a summary page, and need some help

[T5s]

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

 

[Sheeloo]

Paste this in A1 of sheet
=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