The title pretty much says it all, but I am creating a workbook that takes data from multiple worksheets in the same workbook and adds it to the first empty row in a static worksheet. In the static worksheet, the column restriction is from A to O and there is no limit on how many rows are affected; assume all of them AFTER ROW 2 can be added to. In the dynamic sheets, only columns A to O will be looked at, and rows 2 down to the last filled row. In addition, any time that data is added in ANY worksheet, it gets added to the bottom of the static worksheet.

If this doesn't make sense or if you have any questions, please feel free to ask!



Thanks!

1) You want this to happen automatically when you add a row to a worksheet, or you want to add a bunch of rows and then run the program when you're through making the changes? The first is more complicated, but I'm pretty sure it can be done. The second is easier, I think.

2) How much do you know about writing VBA already? Because I can teach you how, but if you just want someone to write it for you, you'll have to wait for someone else. I'm a teach-a-man-to-fish kind of guy, myself.

Actually I know close to nothing about VBA. However, a friend of mine DOES know it, so he helped me out already! Thanks though!

In that case, your destination worksheet is hardly 'static'; it's actually more dynamic than the others.

What happens when data from the source worksheets are edited/deleted after the destination worksheet has been updated?

What is the output order for the destination worksheet (e.g.: by complete source worksheet, meaning new row must be inserted and everything shifted down every time a new row is added to any but the last worksheet; or by source worksheet row, perhaps even meaning blank rows may appear where a given worksheet has less completed rows than one of the others)?

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]