Create Sheets, separate records, copy-paste cell values from master to created sheets

[Hisham Ezzat]

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

 

[Fluff]

Hi & welcome to MrExcel.
Unfortunately your thread is in breach of the rules.

Cross-Posting
While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

Cross posted https://www.excelforum.com/excel-pr...ell-values-from-master-to-created-sheets.html

 

[Hisham Ezzat]

Dear Admin and Members,

Thank you so much for advising. And I appreciate your precious effort and time.

I admit that I have posted the same post on 4 forums/support groups with no bad intention at all. It was just my urgency to get a notifications if there is a way or a solution in Excel that can fit with my need, as I'm not a MS Excel expert. And this is the first time for me to use such forums for help/expert advice.

I apologize for unintentionally breaking the rules.

I am giving here the links for the cross-postings:

[/COLOR]https://www.excelforum.com/...reated-sheets.html#post4958901[COLOR=#3E3E3E]


[/COLOR]https://answers.microsoft.c...-2e3aaa0112da?tm=1534671690694[COLOR=#3E3E3E]


[/COLOR]https://ccm.net/forum/affich-1058008-separating-records-by-relocating-cells[COLOR=#3E3E3E]


I apologize again, and thank you for guiding.
Hisham Ezzat

Hi & welcome to MrExcel.
Unfortunately your thread is in breach of the rules.

Cross-Posting
While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

Cross posted https://www.excelforum.com/excel-pr...ell-values-from-master-to-created-sheets.html