I would like to copy a range of data to different customers/contract #s (to the bottom of a template) and would love to have a VBA code to automate this process.
Worksheet name = Template
Template (tab) range of data = Column A-AK
The process would be done twice on two different tabs (Product Template and Group Template) for the same list of customers.
The data (which already exists on the template) needs copied for each Contract#/Cust# listed in the "Info" tab.
The "Info" tab contains the Contract # & Cust #
The Contract # would be inserted into the Product Template in Column A.
The corresponding Cust # would be inserted into the Product Template in Column C.
Using the same list (Contract #/Cust #) copy the data in the Group Template using the same process as above.
The range of data and the number of customers will vary, but the Template headers (columns A-AK) remain constant. Sometimes I'll have info as product or groups only, so if the template is blank, the VBA would skip those tabs.
I hope this makes sense. Any help is appreciated!!!!
Worksheet name = Template
Template (tab) range of data = Column A-AK
The process would be done twice on two different tabs (Product Template and Group Template) for the same list of customers.
The data (which already exists on the template) needs copied for each Contract#/Cust# listed in the "Info" tab.
The "Info" tab contains the Contract # & Cust #
The Contract # would be inserted into the Product Template in Column A.
The corresponding Cust # would be inserted into the Product Template in Column C.
Using the same list (Contract #/Cust #) copy the data in the Group Template using the same process as above.
The range of data and the number of customers will vary, but the Template headers (columns A-AK) remain constant. Sometimes I'll have info as product or groups only, so if the template is blank, the VBA would skip those tabs.
I hope this makes sense. Any help is appreciated!!!!