| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Compare and then copy cell to separate worksheet
This is what I'm trying to do,
1. I have two workbooks, each with data numbered 1-?. 2. I need to have a function that does this: (workbook 1, cell a2)=10, if (workbook 2, cell a2)=10 also, then it inserts (w2, cell b2) into (w1, cell b2). And on and on down the line... Without having to enter the formula for each individual row as I have about 2000 rows at this point... Is there such a formula? Can it be done? It's made my head hurt so far trying to figure it out. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compare two Worksheet and copy the diferent rows to other | Excel Discussion (Misc queries) | |||
| Sort by even and odd digits and copy to separate worksheet | Excel Worksheet Functions | |||
| Compare a value and if is true copy the line to other worksheet | Excel Worksheet Functions | |||
| How do I copy each row from 1 Worksheet to separate Worksheets? | Excel Discussion (Misc queries) | |||
| Copy data automatically onto a separate worksheet | Excel Discussion (Misc queries) | |||
Threaded Mode
