I've tried to search for my solution, but can't seem to find the answer. I'll make the example simple to see if I can get a solution

I have 2 worksheets (A & B) that contain a table of data 5 columns X 5 rows. I want to create worksheet C that will pull each row of data from the first 2 worksheets and list them (creating a table of data 5 columns X 10 rows).

If I add a 6th row to worksheet A I want worksheet C to automatically update and add this row.

Can this be done without creating a macro or would that be the best route? Thanks

 

Kinda sounds like you want to consolidate multiple worksheets.

http://office.microsoft.com/en-us/ex...265851033.aspx


for it to pick rows as you add though, i'd imagine you can just select alot more rows that actually have data currently and as you add it should pick up with a simple refresh.

 

I tried to consolidate, but it won't consolidate text. I ended up writing a macro, so all worked out in the end.