6 reputation
1
bio website
location
age
visits member for 1 year, 6 months
seen Nov 2 '11 at 4:57
stats profile views 1

Nov
1
comment Setting one worksheet cell range reference to another worksheet
this is partially meeting my requirements,i need Wrk1 cell references any where on wrk2, by using aobve formaulla if the row index in both sheet are same then only it willl set the reference,for exmple if i write this formula(=wrk1!A1:wrk1!A10) on wrk2 between cell range (A1:A10 or B1:B10 ot C1:C10 and so on) then it will work. but in case i want reference in (A10:A20) the it will give me error. Please suggest, it will be great help.
Oct
31
awarded  Student
Oct
31
asked Setting one worksheet cell range reference to another worksheet