Compare 2 cells in 2 worksheets, rewrite one of the cells

D

dbomb

So I have 2 worksheets, lets call them W1 & W2. W1 is my master file
W2 is my working file( I actually have several, so they would be W2-W8
W1 has say 1000 rows. W2 has 200 of them in it. I want to update the QT
cells in W2 based on the matching SKU cell in W1.

So basically
IF
SKU of W2 = SKU of W1,
THEN
QTY of W2 = SKU of W1.

I've tried the following program found at:
http://www.cpearson.com/excel/whatsnew.htm
Search for Compare.XLA

but it doesn't quite do it. This seems like it would be a fairly commo
problem people run into, so I'm hoping somene has come up with
solution
 

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

Compare cells in different worksheets 1
Compare 2 excel sheets -Error Checking of entered names 1
compare and color cells with similar values in a column using vba 5
Referring to same cells in all worksheets 2
Compare two worksheets in the same workbook and highlight difference 7
How do I reference a Range of cells in excel using variable names 4
how to compare parts of text in different cells 1
Macro to compare and copy ranges of cells 4

Top