Referenceing NonConsecutive Cell with Macro

pepper24

New Member
Joined
Feb 29, 2008
Messages
4
I need to extract data from Sheet1 into Sheet2. The data being extracted is sample book analysis and each book has a series of row headers and column headers. The row headers are repeated for every book while the column headers are repeated once at the top. Each book is separated by a blank row. I need to take specific data values from each book in sheet1 and copy it into sheet2. The problem is in sheet2 all the data needs to be in separate columns. For ex:

Sheet1:
A1 = Book name
A2 = Sales
Ect…

Then, (for the same book)
D1 = Costs
E1 = Qty made
Ect..

I need to take A1 and move it to Sheet2 A1
A2 and move it to Sheet2 B1
D1 and move it to Sheet2 C1
E1 and move it Sheet2 D1
Ect…

Any Ideas for a macro????

Please help.
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

Forum statistics

Threads
1,136,433
Messages
5,675,829
Members
419,586
Latest member
RoteichA

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
Top