Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search for the cell content between sheets and copy corresponding
Hi Everyone,
I am working with this problem since some time, it will be a great if you can help me to find out the solution. I have two sheets ("Sheet 1" and "sheet 2") with multiple columns and rows. I have the task to search for the integer in cell "B2" of "sheet 1" in the column "C" of "Sheet 2" and copy the corresponding "D column" value to "C2" in Sheet 1. And this procedure should be executed untill the empty cell of "Coloumn B" of "sheet 1" which might be after 100 or 200 rows. e.g.: B2 of sheet 1 has a value of 2000. The macro has to find for 2000 in column "C" of "sheet 2" and if it finds the value 2000 in C10 then the value of D10 in sheet 2 has to be copied and pasted to the cell "C2" of "Sheet 1". Thanks alot for your help.... Regards |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search for the cell content between sheets and copy corresponding
See VLOOKUP in Excel Help
-- Gary''s Student - gsnu200904 "Venkat" wrote: Hi Everyone, I am working with this problem since some time, it will be a great if you can help me to find out the solution. I have two sheets ("Sheet 1" and "sheet 2") with multiple columns and rows. I have the task to search for the integer in cell "B2" of "sheet 1" in the column "C" of "Sheet 2" and copy the corresponding "D column" value to "C2" in Sheet 1. And this procedure should be executed untill the empty cell of "Coloumn B" of "sheet 1" which might be after 100 or 200 rows. e.g.: B2 of sheet 1 has a value of 2000. The macro has to find for 2000 in column "C" of "sheet 2" and if it finds the value 2000 in C10 then the value of D10 in sheet 2 has to be copied and pasted to the cell "C2" of "Sheet 1". Thanks alot for your help.... Regards |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search for the cell content between sheets and copy corresponding
In sheet1, cell C2: =vlookup(B2,Sheet2!C:D,2,false) then copy down to the bottom of sheet 1 Sam "Venkat" wrote: Hi Everyone, I am working with this problem since some time, it will be a great if you can help me to find out the solution. I have two sheets ("Sheet 1" and "sheet 2") with multiple columns and rows. I have the task to search for the integer in cell "B2" of "sheet 1" in the column "C" of "Sheet 2" and copy the corresponding "D column" value to "C2" in Sheet 1. And this procedure should be executed untill the empty cell of "Coloumn B" of "sheet 1" which might be after 100 or 200 rows. e.g.: B2 of sheet 1 has a value of 2000. The macro has to find for 2000 in column "C" of "sheet 2" and if it finds the value 2000 in C10 then the value of D10 in sheet 2 has to be copied and pasted to the cell "C2" of "Sheet 1". Thanks alot for your help.... Regards |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
search, copy and paste through multiple sheets | Excel Discussion (Misc queries) | |||
Search and Replace Entire Cell Content | Excel Discussion (Misc queries) | |||
Copy sheets with content into same workbook | Excel Programming | |||
Can I search a cell for a value and extract part of content? | Excel Discussion (Misc queries) | |||
How to search and copy cell content to another sheet? | Excel Worksheet Functions |