Excel Copy cells from one worksheet to another workseet - increment row & do again

Oct 10, 2020
Reaction score
ina Excel macro
I need to move cells in one column from 1st worksheet to another worksheet..
(in the first worksheet is column of Purchase Order data: PO #, PO name, Item, etc)

The 2nd worksheet is a PO form. each cell in a column in the 1st worksheet needs to be copped to the PO.

example cell A2 in 1st workbook needs to be copied to G12 in the 2nd workbook
cell A3 in 1st workbook needs to be copied to H6 in the 2nd workbook
When done Ill print the PO

next step will be to increment column in 1st worksheet to B and repeat building a PO then print.

Thanks for your help

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question