Smartkid
05-12-2009, 12:41 PM
Hello all,
I'm hoping to get some help preparing a Macro that will ease a relatively repetitive task that I perform. Basically, I have a template in Excel that populates a table based on input data. (Sheet 'Template')
Usually I take the following steps:
1. Download input data (Sheet 'Input')
2. Copy the first row of input data into the template to populate the table (Sheet 'Template')
3. Copy the table to a new sheet (Sheet 'Output')
4. Copy the second row of input data into the template to populate a new table (Sheet 'Template')
5. Copy the table below the first one (Sheet 'Output')
6. Continue this process until end of input data
I feel like a VBA Macro would make my life a lot easier. I wish I could just dump the input data on Sheet 'Input' and press a GO button, the Sheet 'Output' would automatically populate. Is this possible?
I've attached a mock workbook for reference. Basically my template is on rows 3-16 of the Sheet 'Template'. I copy my input data into Sheet 'Input' from rows C1:JXX (The number of rows of input data varies.) For each row of input data, I copy C:J and paste on the Sheet 'Template' C3:J3. I then copy rows 3-16 from Sheet 'Template' onto Sheet 'Output.' Rinse and repeat.
Any help to make my life easier would be greatly appeciated. Sometimes my input data exceeds 100 rows so it gets quite time consuming.
Thanks in advance
I'm hoping to get some help preparing a Macro that will ease a relatively repetitive task that I perform. Basically, I have a template in Excel that populates a table based on input data. (Sheet 'Template')
Usually I take the following steps:
1. Download input data (Sheet 'Input')
2. Copy the first row of input data into the template to populate the table (Sheet 'Template')
3. Copy the table to a new sheet (Sheet 'Output')
4. Copy the second row of input data into the template to populate a new table (Sheet 'Template')
5. Copy the table below the first one (Sheet 'Output')
6. Continue this process until end of input data
I feel like a VBA Macro would make my life a lot easier. I wish I could just dump the input data on Sheet 'Input' and press a GO button, the Sheet 'Output' would automatically populate. Is this possible?
I've attached a mock workbook for reference. Basically my template is on rows 3-16 of the Sheet 'Template'. I copy my input data into Sheet 'Input' from rows C1:JXX (The number of rows of input data varies.) For each row of input data, I copy C:J and paste on the Sheet 'Template' C3:J3. I then copy rows 3-16 from Sheet 'Template' onto Sheet 'Output.' Rinse and repeat.
Any help to make my life easier would be greatly appeciated. Sometimes my input data exceeds 100 rows so it gets quite time consuming.
Thanks in advance