Creating multiple spreadsheets based on text
I'm looking to devlope a macro that will save myself a ton of manual hours.
I need to populate a form multiple times based on unique vendor name in Column A. Each vendor name should have its own form. Is this possible?
It should take information from attached spreadsheet called "Test Data1" and populate attached, "Form"
Here is the breakdown:
"Test Data1" column A should populate "Form" sheet1, cell D8
"Test Data1" column B should populate "Form" sheet1, cell D12
"Test Data1" column C should populate "Form" sheet2, cell B6
"Test Data1" column D should populate "Form" sheet2, cell C6
"Test Data1" column E should populate "Form" sheet2 cell D6
Any help would be greatly appreciated.
|