Help with copying

R

Richard

I'd like to copy the contents that are in Column A Sheet1
to Column A Sheet2 using a Private Sub procedure, in the
worksheet_change, I guess. For example: Once something is
entered in Column A Sheet1 then copy it to Sheet2 in the
next available cell. Simple but over my head! Thanks in
advance
 
J

John P

Richard
Do you want col a from sheet one to be the same as col a in sheet two or is
there a criteria for doing so?

John
 

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

Similar Threads

Transpose between sheets 4
Excel VBA to move cells to sheet2 based on selection in sheet1 0
Fill formula down for cells 74 rows apart 3
Need macros for copy data into new workbooks 2
copy data from sheet2 to sheet1 when sheet2 has variable # of rows 6
Combining Data help? 1
bookkeeping-payment confirmation 7
Help with formula 1

Top