If match then copy.. beginner in VBA

C

Charlene

Ok, I have 2 spreadsheets... Both containing the same
values in column A but some of the rows in column A are
blank in spreadsheet 1. I need something like this:

If column A in spreadsheet 1 matches column A in
spreadsheet 2,

Copy row from spreadsheet 2 into spreadsheet 1

If it doesnt match go to next row...

I hope this makes sense....

Thank you!
Charlene
 

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

Need Help with a VBA subroutine 0
Word macro that can call cells out of Excel for a find and replace 0
VBA Coding Help for Beginner 0
Formula to fill in fields when cell is blank 2
Auto Copy Data from one worksheet to another 1
Create if partial match then copy and paste data from one cell to another 1
Remove specific cells in a column. 2
Help: Find Matching Cells, If - Then Move Cell With Self 2

Top