View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith
 
Posts: n/a
Default Data row wise, formula column wise

I have data in cells b2:aj2

I want to refer to these cells in a column from a2 down. I can manually type in:

A2: =B2
A3: =C2
A4: =D2

Rather than doing so, is there a formula I can type in once in A2 then copy
down?

--
Regards,
Fred