Matching rows in 2 sheets and copying matching rows from sheet 1 t

F

fbagirov

I've got 2 sheets in the same workbook - A and B.
Sheet B is a new unvalidated list of customers, sheet A is the validated
list of customers. Each sheet has a column with customer number.

I need to go through all customer numbers in Sheet B, and for each customer
number to go to Sheet A to see if there is a match. If there is a match, then
copy the whole row of the matching number from sheet A, and paste it to the
matching row of sheet B (it should be converted to uppercase before pasting).

Can you help me with macro ? Thanks!
 

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

Matching Rows 2nd try 2
Grouping {MERGEFIELD} into 2 or 3 Columns 0
Find matching cell and return value of a different cell 5
Shift Collate sheet 1-20 when printing entire workbook? 0
Macro to Combine Data from Multiple Sheets with Cell References 4
Macro to Compile Data from Different Sheets 2
Create if partial match then copy and paste data from one cell to another 1
Search an array of sheets for an array of numbers & return count of numbers 11

Top