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
 
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