Macro for Selecting and Pasting into new cells??

Hello, I have many orders or products and when listed in excel it shows the SKU's and name along with other data. I would like to take this data and use just the SKU's and Product name. Everything else would not be used. Here is what the data looks like

Quantity Product Details Price
1 Product A
SKU: 7Z-36Q9-LK1P
ASIN: B009BTQ8S4
Listing ID: 0916M1DMLSL
Order-Item ID: 28255029918234
Condition: New $14.99 Subtotal:
Shipping: $3.66
________________________________________
Total: $18.65

2 Product B
SKU: QP-PQXS-3CA8
ASIN: B009FRAVUS
Listing ID: 0924M9480RX
Order-Item ID: 63126777937842
Condition: New $12.99 Subtotal:
Shipping: $6.34
________________________________________
Total: $32.32

ORDER TOTAL: $50.97

I would like to run a macro and it show like the following
SKU:7Z-36Q9-LK1P Product A
SKU:QP-PQXS-3CA8 Product B

The Sku's are in Column A, while the Product name is one row above the Sku in column B. I have tried many different ways of extracting this but all the code I have tried will only highlight the first SKU, it will not select ALL the Sku's and the copy them. Not sure where to really go from here....Anyone with knowledge of this I would appreciate help from. Thanks everyone!

You want to get rapport of the orders in another sheet or want to delete unnecessary rows?

Example.xlsx

I have attached the file. There are many more than the 4 orders shown. I have removed the buyers names and address and replaced with xxx. All other data is original. Sheet 1 contains how the data looks, Sheet 2 shows how I would like it shown after the macro is ran. I hope there is a way to do it as it would be a great time saver for us and the business. Thanks for your help!

I would like to get the Sku's and the Product name extracted in another sheet. I attached an example. Any help would be great. Thanks so much!

Originally Posted by alansidman

Try this:

Please Login or Register  to view this content.

Worked like a charm! Thanks so much!!!!

Hi alansidman,

Can you also check my data because it's the same issue, but my data are all in 1 cell instead of separate cells.
The result on my sample Sheet 2, I use RIGHT, MID to pull the data, so I wonder if I can run a macro to have all the data in 1 click.
The header in Sheet 2 is to show you the order of the data to pull, having them or not is not the main thing. I need the data in the same order, that is more important.

format.xlsx

Please help!

Thanks.

Sorry, I thought it would be too much to recreate another same topic. I will create another topic now.

Thanks.