Hello All,
I have a master sheet with a table listing 260 items and their tech. specifications - under 20 headings.
I need to create a separate sheet for each item of the 260.
Naming the created sheet by its item code, which is listed in the first column in the master table.
The created sheet will have a template Report Form that have titles the same as the 20 headings in the master sheet, but in different arrangement, to be like a one-page form summarizing the tech. specifications for a single item of the 260.
The Macro is required to fill up the Report Form for each item by looking for the value under the relative heading in the master sheet and copy it and go to the created sheet to paste that value adjacent to the appropriate heading, doing so until completing the Report Form.
Then repeating the whole process for the 260 created sheets to end up having a 260 Report Forms for the 260 items.
ITEM CODE ITEM DESCRIPTION Package Manufacturer Model Dimensions (mm) Mounting Type Weight Heat Gain Power
Volt Current Power Source Phase Remarks Data Port QTY Plumbing Connection Pressure
These are the 20 headings.
Note: The Excel file showing a sample of the master sheet and the complete Report Form is attached along with this thread.
Thanks so much...
Hisham Ezzat
Bookmarks