Trying to copy/paste multiple grouped columns across a workbook to another worksheet

[mreisbe]

Good afternoon. I am trying to write a macro that will take grouped data in columns A&B, C&D, E&F, G&H, ... and paste it one under the other in a new workbook. The data consists of Product Number and Inventory. An example of the data:

Product Inventory Product Inventory Product Inventory
A12314 112 A5588 11 B5587 10
B1158 0 C55478 100 D5587 5

I want to transpose the data onto a new workbook so I see:
Product Inventory
A12314 112
B1158 0
A5588 11
C55478 100
B5587 10
D5587 5

Current vba copies data to new worksheet, but stacks Col A,B,C,D,E,F... in same column.

Please Login or Register  to view this content.

I appreciate any and all help.
Regards,
Marc

[xladept]

But try this:

Please Login or Register  to view this content.

Directions for running the routine(s) just supplied

Copy the code to the clipboard

Press ALT + F11 to open the Visual Basic Editor.

Open a macro-enabled Workbook or save your Workbook As Macro-Enabled

Select “Module” from the Insert menu

Type "Option Explicit" then paste the code under it

And, you should be ready to go

With the cursor between Sub and End Sub press F5 (F8 to Single Step)

OR

Press ALT + Q to close the code window.

Press ALT + F8 then double click on the macro name

[xladept]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)