Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compare 2 cells in 2 worksheets, rewrite one of the cells
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 -- dbom ----------------------------------------------------------------------- dbomb's Profile: http://www.excelforum.com/member.php...fo&userid=1478 View this thread: http://www.excelforum.com/showthread.php?threadid=26412 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compare 2 cells in 2 worksheets, rewrite one of the cells
maybe this site wille help you with this and other problems http://www.rondebruin.nl/copy2.htm very usefull site if you ask m -- Zur ----------------------------------------------------------------------- Zurn's Profile: http://www.excelforum.com/member.php...fo&userid=1464 View this thread: http://www.excelforum.com/showthread.php?threadid=26412 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
compare 2 column cells and return the adjacent columns cells data of the cell | Excel Worksheet Functions | |||
Compare 1 cell to column of cells returning adjacent cells info? | Excel Worksheet Functions | |||
Compare cells in different worksheets | Excel Worksheet Functions | |||
compare 2 worksheets for simliar cells and then comb into one work | Excel Discussion (Misc queries) | |||
How do I compare data in two worksheets to find matching cells? | Excel Discussion (Misc queries) |