Regarding copying

[chandrashekar]

I have two worksheets in an excel application.
I want to write a function/macro such that i will copy
worksheet no 1 contents to worksheet no 2 only if a
column A value in worksheet2 equal to column A in
worksheet 1.
OR
i want to copy columns b,columns c, columns d in
worksheet 2 with the corresponding columns in worksheet 1
only if the text in column 1 of worksheet 2 equals to
text in column 1 of worksheet 1.

Another Point. There are no numbers only text in both the
sheets

If any one knows the solution, plz do let me know.
Sincere regards to them
chandrashekar

 

[JulieD]

Hi chandrashekar

you might like to look at the VLOOKUP function - which you can write in
column b, c & d of worksheet 2
for example in cell B2 you could write:

=VLOOKUP(A1,Sheet1!$A$1:$D$200,2,false)
this means, look at the value in A1 (of sheet 2), find a match in sheet1, in
the range A1200, and return the information in the column to the right of
where you find the number.

for column you would use
=VLOOKUP(A1,Sheet1!$A$1:$D$200,3,false)

Hope this helps

Cheers
JulieD