Insert Rows and Populate

I'm setting up a template worksheet that I need to pull data from other sheets and input into the template. The data will change from one project to the next, including the number of rows of data.

I want to build a macro that initiates when the worksheet is opened. The macro will insert the number of rows necessary at specific locations and then populate the new rows with the new information. Essentially a copy paste with variable data.

Any suggestions on how to proceed?

Hi

How about putting up a sample workbook so we can see what you are working with. Detail the data, where it has to go, where it comes from, what are the variable number of rows, etc....


rylo

For example, suppose three schedules are imputted into SHEET 1. Each schedule has a different number of line items: Schedule 1 has items 101, 102, and 103; Schedule 2 has items 201, 203, 204, 205, and 206; and Schedule 3 has items 303, 306, 307, and 310. Each line item has its own row. For simplicity, say each item has 3 pieces of data: The "Item Number", the "Item Description", and the "Estimated Quantity".

I need SHEET 2 to pull the information from SHEET 1, adding a couple of columns of editable data and doing some calculations: Lets say two added columns of data are "Revised Quantity" and "Difference". The "Difference" column will subtract the "Estimated Quantity" from the "Revised Quantity". Below each schedule we sum up the quantity, sum up the revised quantity, and show the difference between the two. Below the final schedule we sum up the total quantity, sum up the total revised quantity, and show the total difference.

As I mentioned before, I need this to be a template that will update when line items are changed, added, or removed from a schedule.

Can anyone help me set this up?

Here's a sample of the worksheet I'm trying to create. SHEET 2 is the Over-Under sheet that I need to populate from the Estimate sheet. Columns do not transfer straight across. See below for transfer pattern

From Sheet 1 A B C D E F G H
To Sheet 2 A B C G H - - E

I've set up Schedule 1 as I need it, but would rather have the spreadsheet update the Over-Under sheet automatically when changes are made to the Estimate sheet, including variations in the number of line items (as stated in previous thread statements).

Again, any help on this would be great. Thanks!