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

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
 

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"
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
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,223,162
Messages
6,170,431
Members
452,326
Latest member
johnshaji

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top