How would I....

  • Thread starter Thread starter Bruce
  • Start date Start date
B

Bruce

I have a worksheet that I created. I want to give it more flexibility.
I would like to refereace a cell from another sheet. But....
I would like to have a number in cell A3 that I can put in that would
control what row the info is being pulled from.

Ex: On current worksheet, I have cells B4 and B5 that have First and last
name. Lets call this WS1

On Worksheet 2, I have row for diffent clients. If I put the numer 3 in CELL
WS1:A3, then B4 will put the first name from the 3rd client on worksheet2

I would have something like =WorkSheet2!I2 if this is static, but I need to
replace the !I (row(a3)) and get it to be valid.

Help....

TIA
 
Hi Bruce!

Use INDIRECT to build up the reference that you want.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top