Macro to copy and paste transpose between different sheets

meiirmeiir21

New Member
Joined
Jan 18, 2010
Messages
22
Hello,

I am looking for a macro or Excel Add-in that can copy from my BOM sheet to my Level 2 and Level 1 sheets with the below defined formats
BOM Sheet has the sites distributed over the columns , while i need the sites to be distributed over the rows in L2.I filled the first 2 sites in Level2 to give an example for what i am looking for.Model code as well as Model description shall be copied also from BOM sheet to Level2 sheet.
Green headers rows at the BOM sheet shall be discarded from the copy and transpose at Level2 sheet.

at Level 1 sheet i need to copy the Model code , Model description , and Model Qty from BOM sheet Rows#1,2,3 and paste it to Level 1 column A , B, and F.

PS: BOM sheet has lots of Columns and Rows , and it is time consuming for me to do this manually..

Any hero can help here :eeek: ?


BR,
M.Eid

BOM




Model Code Route#A_Config type_Site1 Route#A_Config type_Site2 Route#A_Config type_Site3 Route#A_Config type_Site4 Route#A_Config type_Site5 Route#A_Config type_Site6 Route#A_Config type_Site7 Route#A_Config type_Site8 Route#A_Config type_Site9 Route#A_Config type_Site10 Route#A_Config type_Site11 Route#A_Config type_Site12 Route#A_Config type_Site13 Route#A_Config type_Site14
Model Description This Model is for Route#A_Config type_Site1 This Model is for Route#A_Config type_Site2 This Model is for Route#A_Config type_Site3 This Model is for Route#A_Config type_Site4 This Model is for Route#A_Config type_Site5 This Model is for Route#A_Config type_Site6 This Model is for Route#A_Config type_Site7 This Model is for Route#A_Config type_Site8 This Model is for Route#A_Config type_Site9 This Model is for Route#A_Config type_Site10 This Model is for Route#A_Config type_Site11 This Model is for Route#A_Config type_Site12 This Model is for Route#A_Config type_Site13 This Model is for Route#A_Config type_Site14
Model Qty 1 1 1 1 1 1 1 1 1 1 1 1 1 1
Customer code Orderable Item Our code Unit price TOTALS Site_1 Site_2 Site_3 Site_4 Site_5 Site_6 Site_7 Site_8 Site_9 Site_10 Site_11 Site_12 Site_13 Site_14
Hardware
HW00001 0
HW00002 0
HW00003 0
HW00004 0
HW00005 0
HW00006 0
HW00007 0
HW00008 0
HW00009 0
HW00010 0
HW00011 0
HW00012 0
HW00013 0
HW00014 0
HW00015 0
HW00016 0
HW00017 0
HW00018 0
HW00019 0
HW00020 0
HW00021 0
HW00022 0
HW00023 0
HW00024 0
Software (-) (-) (-) (-) (-) (-) (-) (-) (-) (-) (-) (-) (-) (-)
SW00001 0
SW00002 0
SW00003 0
SW00004 0
Services (-) (-) (-) (-) (-) (-) (-) (-) (-) (-) (-) (-) (-) (-)
SV000001 0
SV000002 0
SV000003 0
SV000004 0
SV000005 0
SV000006 0



Level2

Model Code Model Description Item code Qty Per site
Route#A_Config type_Site1 This Model is for Route#A_Config type_Site1 HW00001
Route#A_Config type_Site1 This Model is for Route#A_Config type_Site1 HW00002
Route#A_Config type_Site1 This Model is for Route#A_Config type_Site1 HW00003
Route#A_Config type_Site1 This Model is for Route#A_Config type_Site1 HW00004
Route#A_Config type_Site1 This Model is for Route#A_Config type_Site1 HW00005
Route#A_Config type_Site1 This Model is for Route#A_Config type_Site1 HW00006
Route#A_Config type_Site1 This Model is for Route#A_Config type_Site1 HW00007
Route#A_Config type_Site1 This Model is for Route#A_Config type_Site1 HW00008
Route#A_Config type_Site1 This Model is for Route#A_Config type_Site1 HW00009
Route#A_Config type_Site1 This Model is for Route#A_Config type_Site1 HW00010
Route#A_Config type_Site1 This Model is for Route#A_Config type_Site1 HW00011
Route#A_Config type_Site1 This Model is for Route#A_Config type_Site1 HW00012
Route#A_Config type_Site1 This Model is for Route#A_Config type_Site1 HW00013
Route#A_Config type_Site1 This Model is for Route#A_Config type_Site1 HW00014
Route#A_Config type_Site1 This Model is for Route#A_Config type_Site1 HW00015
Route#A_Config type_Site1 This Model is for Route#A_Config type_Site1 HW00016
Route#A_Config type_Site1 This Model is for Route#A_Config type_Site1 HW00017
Route#A_Config type_Site1 This Model is for Route#A_Config type_Site1 HW00018
Route#A_Config type_Site1 This Model is for Route#A_Config type_Site1 HW00019
Route#A_Config type_Site1 This Model is for Route#A_Config type_Site1 HW00020
Route#A_Config type_Site1 This Model is for Route#A_Config type_Site1 HW00021
Route#A_Config type_Site1 This Model is for Route#A_Config type_Site1 HW00022
Route#A_Config type_Site1 This Model is for Route#A_Config type_Site1 HW00023
Route#A_Config type_Site1 This Model is for Route#A_Config type_Site1 HW00024
Route#A_Config type_Site1 This Model is for Route#A_Config type_Site1 SW00001
Route#A_Config type_Site1 This Model is for Route#A_Config type_Site1 SW00002
Route#A_Config type_Site1 This Model is for Route#A_Config type_Site1 SW00003
Route#A_Config type_Site1 This Model is for Route#A_Config type_Site1 SW00004
Route#A_Config type_Site1 This Model is for Route#A_Config type_Site1 SV000001
Route#A_Config type_Site1 This Model is for Route#A_Config type_Site1 SV000002
Route#A_Config type_Site1 This Model is for Route#A_Config type_Site1 SV000003
Route#A_Config type_Site1 This Model is for Route#A_Config type_Site1 SV000004
Route#A_Config type_Site1 This Model is for Route#A_Config type_Site1 SV000005
Route#A_Config type_Site1 This Model is for Route#A_Config type_Site1 SV000006
Route#A_Config type_Site1 This Model is for Route#A_Config type_Site1 SV000007
Route#A_Config type_Site2 This Model is for Route#A_Config type_Site2 HW00001
Route#A_Config type_Site2 This Model is for Route#A_Config type_Site2 HW00002
Route#A_Config type_Site2 This Model is for Route#A_Config type_Site2 HW00003
Route#A_Config type_Site2 This Model is for Route#A_Config type_Site2 HW00004
Route#A_Config type_Site2 This Model is for Route#A_Config type_Site2 HW00005
Route#A_Config type_Site2 This Model is for Route#A_Config type_Site2 HW00006
Route#A_Config type_Site2 This Model is for Route#A_Config type_Site2 HW00007
Route#A_Config type_Site2 This Model is for Route#A_Config type_Site2 HW00008
Route#A_Config type_Site2 This Model is for Route#A_Config type_Site2 HW00009
Route#A_Config type_Site2 This Model is for Route#A_Config type_Site2 HW00010
Route#A_Config type_Site2 This Model is for Route#A_Config type_Site2 HW00011
Route#A_Config type_Site2 This Model is for Route#A_Config type_Site2 HW00012
Route#A_Config type_Site2 This Model is for Route#A_Config type_Site2 HW00013
Route#A_Config type_Site2 This Model is for Route#A_Config type_Site2 HW00014
Route#A_Config type_Site2 This Model is for Route#A_Config type_Site2 HW00015
Route#A_Config type_Site2 This Model is for Route#A_Config type_Site2 HW00016
Route#A_Config type_Site2 This Model is for Route#A_Config type_Site2 HW00017
Route#A_Config type_Site2 This Model is for Route#A_Config type_Site2 HW00018
Route#A_Config type_Site2 This Model is for Route#A_Config type_Site2 HW00019
Route#A_Config type_Site2 This Model is for Route#A_Config type_Site2 HW00020
Route#A_Config type_Site2 This Model is for Route#A_Config type_Site2 HW00021
Route#A_Config type_Site2 This Model is for Route#A_Config type_Site2 HW00022
Route#A_Config type_Site2 This Model is for Route#A_Config type_Site2 HW00023
Route#A_Config type_Site2 This Model is for Route#A_Config type_Site2 HW00024
Route#A_Config type_Site2 This Model is for Route#A_Config type_Site2 SW00001
Route#A_Config type_Site2 This Model is for Route#A_Config type_Site2 SW00002
Route#A_Config type_Site2 This Model is for Route#A_Config type_Site2 SW00003
Route#A_Config type_Site2 This Model is for Route#A_Config type_Site2 SW00004
Route#A_Config type_Site2 This Model is for Route#A_Config type_Site2 SV000001
Route#A_Config type_Site2 This Model is for Route#A_Config type_Site2 SV000002
Route#A_Config type_Site2 This Model is for Route#A_Config type_Site2 SV000003
Route#A_Config type_Site2 This Model is for Route#A_Config type_Site2 SV000004
Route#A_Config type_Site2 This Model is for Route#A_Config type_Site2 SV000005
Route#A_Config type_Site2 This Model is for Route#A_Config type_Site2 SV000006
Route#A_Config type_Site2 This Model is for Route#A_Config type_Site2 SV000007



Level 1

Model Code Model Description Model Qty
Route#A_Config type_Site1 This Model is for Route#A_Config type_Site1 1
Route#A_Config type_Site2 This Model is for Route#A_Config type_Site2 1
Route#A_Config type_Site3 This Model is for Route#A_Config type_Site3 1
Route#A_Config type_Site4 This Model is for Route#A_Config type_Site4 1
Route#A_Config type_Site5 This Model is for Route#A_Config type_Site5 1
Route#A_Config type_Site6 This Model is for Route#A_Config type_Site6 1
Route#A_Config type_Site7 This Model is for Route#A_Config type_Site7 1
Route#A_Config type_Site8 This Model is for Route#A_Config type_Site8 1
Route#A_Config type_Site9 This Model is for Route#A_Config type_Site9 1
Route#A_Config type_Site10 This Model is for Route#A_Config type_Site10 1
Route#A_Config type_Site11 This Model is for Route#A_Config type_Site11 1
Route#A_Config type_Site12 This Model is for Route#A_Config type_Site12 1
Route#A_Config type_Site13 This Model is for Route#A_Config type_Site13 1
Route#A_Config type_Site14 This Model is for Route#A_Config type_Site14 1



I can send a sample excel file over mail , if anybody is ready to help just mail me om meiir21@gmail.com
 
Last edited:

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