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


Joined
Oct 10, 2020
Messages
3
Reaction score
0
HI
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
Steve
 
Ad

Advertisements


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

Top