Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Compare and copy/paste
Hi
I have two sheets with about 500 rows "Sheet1": A1 3000 B1 3001 C1 3002 and furter on to about 500 "Sheet2": A1 3002 B1 3000 C1 3001 and furter on to about 500 The function I need has to be put in cell D1 in "sheet1" and need to check of any of the cells in column A in "sheet 2" has the value of A1 in "sheet1", if it does I need to put the value of F1 in "sheet2" into D1 in "sheet1" The cells in column A "sheet1" one has not the same rows as in "sheet2",, if they had the same row it would be easy :) Eks : A1 in "sheet1" have the value 3000, but in "sheet2" the value 3000 is in A7 Do anyone understand what I am looking for???? PLS help :) -- Just a regular user |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Compare and copy/paste
sorry got posted 2 times, got a errormessage the first time, and tried again,
sorry -- Just a regular user Rockbear skrev: Hi I have two sheets with about 500 rows "Sheet1": A1 3000 B1 3001 C1 3002 and furter on to about 500 "Sheet2": A1 3002 B1 3000 C1 3001 and furter on to about 500 The function I need has to be put in cell D1 in "sheet1" and need to check of any of the cells in column A in "sheet 2" has the value of A1 in "sheet1", if it does I need to put the value of F1 in "sheet2" into D1 in "sheet1" The cells in column A "sheet1" one has not the same rows as in "sheet2",, if they had the same row it would be easy :) Eks : A1 in "sheet1" have the value 3000, but in "sheet2" the value 3000 is in A7 Do anyone understand what I am looking for???? PLS help :) -- Just a regular user |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
Compare col and match then copy and paste | Excel Discussion (Misc queries) | |||
Compare two wk sheets with common data using copy paste macro | Excel Worksheet Functions | |||
Excel cut/Paste Problem: Year changes after data is copy and paste | Excel Discussion (Misc queries) | |||
I cannot paste from one workbook to another. Copy works, paste do. | Excel Discussion (Misc queries) |