Stacking several columns into one column on another worksheet

Thank you for looking at my question, which involves the editing of an existing macro that I found on a Microsoft forum. I have attached a file to illustrate it.

In the attached file, the macro called OneColumnV2 copies several columns from the "Transport" worksheet (in this case 4 columns but it could be more or less) to another worksheet called "IndCalc1." The copied items appear on the IndCalc1 worksheet beginning on the fourth row in column A with two blank rows between each copied segment. This is exactly what I need except that I need it in column B not column A.

I have tried editing the macro to accomplish this, but my beginners level knowledge of VBA will not solve it. Thank you again.

it needed a few , 1 in Cells references changed in to , 2

have a look if this works for you

Please Login or Register  to view this content.

Hi Roel, That works great. I have one minor question. The copied data starts on row 3 instead of row 4. Is that easily changed? Thanks for the quick response!

Ah I see what happend a +1 was dropped in editing the code after the line myRng.copy
change the line

Please Login or Register  to view this content.

Perfect, thanks again!

Sorry, I did not see your response. I appreciate your assistance. Thank you.