Regarding copying

  • Thread starter Thread starter chandrashekar
  • Start date Start date
C

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
 
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 A1:D200, 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
 
Back
Top