#1
|
|||
|
|||
Multiple Dynamic Worksheets Consolidated into One Static Worksheet
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! |
#2
|
||||
|
||||
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. |
#3
|
|||
|
|||
Actually I know close to nothing about VBA. However, a friend of mine DOES know it, so he helped me out already! Thanks though!
|
#4
|
||||
|
||||
Quote:
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] |
Tags |
add, dynamic, multiple worksheets |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Can you copy & paste cells across worksheets and preserve reference to worksheet? | New Daddy | Excel | 2 | 11-27-2013 07:19 AM |
Sum multiple worksheets and summary tab that would sum and count by rep name | angie.chang | Excel | 1 | 05-16-2013 12:36 AM |
Multiple Headers in Same Worksheet | Tom | Excel | 3 | 05-18-2011 03:22 PM |
Cells from other worksheets apear on current worksheet | Equilar | Excel | 3 | 05-03-2010 01:40 AM |
Printing multiple page worksheet with watermark | zany | Excel | 2 | 11-27-2009 01:33 AM |