#1
|
|||
|
|||
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. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Creating a table that automatically updates based on entries of a heading in the document | cahphoenix | Word | 3 | 10-29-2014 01:11 PM |
I need to add multiple values based on multiple criteria in a cell not sure what to do | AUHAMM | Excel | 3 | 10-27-2014 09:11 PM |
Need help creating a Word document that is populated based on certain selected values | alidaanish | Word | 1 | 01-10-2014 10:44 PM |
Creating Report based on 'Task Summary' and 'Sub Tasks' | alijahed | Project | 1 | 02-01-2013 04:20 AM |
Creating formula based on if data is correct in cell | MattMurdock | Excel | 1 | 08-06-2012 03:11 AM |