I am trying to creat a series of tabs with source data that will be collected
into the final tab into an all up spreadsheet.

Various groups of people will select thier tab, input thier data and Im
trying to get the final tab in my spreadsheet to go collect that source data
and bring it to a final spreadsheet on the final tab. I understand how to use
the formula to identify the cell in the source data tab but my problem is the
people adding their data MAY ADD ROWS, thus messing up my formula on the
final spreadsheet.

Is their a formula that will allow for the adding of rows in the sorce tab
so that it still pulls the data onto the final tab? As it is now, when they
add a row on the source tab, that data isnt being picked up in the final
tab...

thank you
Heath Taubitz
Lockheed Martin

In other words...Is there a way to have the final tab add rows whenever a row
is added to any of the other tabs within the spreadheet?

"Thank you, Heath" wrote:

I am trying to creat a series of tabs with source data that will be collected
into the final tab into an all up spreadsheet.

Various groups of people will select thier tab, input thier data and Im
trying to get the final tab in my spreadsheet to go collect that source data
and bring it to a final spreadsheet on the final tab. I understand how to use
the formula to identify the cell in the source data tab but my problem is the
people adding their data MAY ADD ROWS, thus messing up my formula on the
final spreadsheet.

Is their a formula that will allow for the adding of rows in the sorce tab
so that it still pulls the data onto the final tab? As it is now, when they
add a row on the source tab, that data isnt being picked up in the final
tab...

thank you
Heath Taubitz
Lockheed Martin

You will have to go with VBA to catch when users enter rows.

Those rows can then be copied to your master sheet.

See Ron de Bruin's site

http://www.rondebruin.nl/tips.htm

Browse through the section on Copy/Paste/Merge examples


Gord Dibben MS Excel MVP

On Thu, 19 Jul 2007 06:32:12 -0700, Thank you, Heath
wrote:

In other words...Is there a way to have the final tab add rows whenever a row
is added to any of the other tabs within the spreadheet?

"Thank you, Heath" wrote:

I am trying to creat a series of tabs with source data that will be collected
into the final tab into an all up spreadsheet.

Various groups of people will select thier tab, input thier data and Im
trying to get the final tab in my spreadsheet to go collect that source data
and bring it to a final spreadsheet on the final tab. I understand how to use
the formula to identify the cell in the source data tab but my problem is the
people adding their data MAY ADD ROWS, thus messing up my formula on the
final spreadsheet.

Is their a formula that will allow for the adding of rows in the sorce tab
so that it still pulls the data onto the final tab? As it is now, when they
add a row on the source tab, that data isnt being picked up in the final
tab...

thank you
Heath Taubitz
Lockheed Martin