Hisham Ezzat
New Member
- Joined
- Aug 19, 2018
- Messages
- 2
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.
Sample of the master sheet ...
ITEM CODE ITEM DESCRIPTION Package Manufacturer Model
_____________________________________________________________________________________
ANAPH64 Blood Gas MF Siemens Rapidpoint
Dimensions (mm) Mounting Type Weight Heat Gain Power Volt
_____________________________________________________________________________________
90 x 80 x 150 Wall fixed 15 Kgs 854 264 230
Current Power Source Phase Remarks Data Port QTY Plumbing
____________________________________________________________________________
1 Normal 1 N/A Data Port 1 Drain
Connection Pressure
_________________________
2.5 inch 90
I put it here on 4 parts due to limited space.
The Report Form have the same headings but redistributed (or grouped) to make a one page summary report for each individual item.
Thanks so much...
Hisham Ezzat
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.
Sample of the master sheet ...
ITEM CODE ITEM DESCRIPTION Package Manufacturer Model
_____________________________________________________________________________________
ANAPH64 Blood Gas MF Siemens Rapidpoint
Dimensions (mm) Mounting Type Weight Heat Gain Power Volt
_____________________________________________________________________________________
90 x 80 x 150 Wall fixed 15 Kgs 854 264 230
Current Power Source Phase Remarks Data Port QTY Plumbing
____________________________________________________________________________
1 Normal 1 N/A Data Port 1 Drain
Connection Pressure
_________________________
2.5 inch 90
I put it here on 4 parts due to limited space.
The Report Form have the same headings but redistributed (or grouped) to make a one page summary report for each individual item.
Thanks so much...
Hisham Ezzat