Quote:
Originally Posted by mars1886
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 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)?