Thread: How do I use a formula to give me a cell reference in excel?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stan Brown Stan Brown is offline
external usenet poster
  
Posts: 524
Default How do I use a formula to give me a cell reference in excel?
Mon, 2 Apr 2007 03:08:02 -0700 from CJWilson
:
I want to be able to copy the following formula sequence down an excel sheet:
='By Name'!A2
='By Name'!A5
='By Name'!A8
...
But excel will not recognise the sequence. Can I
a) Do something so it will recognise it and copy it
b) Make the cell references the result of a formula e.g. ='By Name'!A(B1),
where B1 contains the reference I need.

=INDIRECT
or =OFFSET

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/
Reply With QuoteReply With Quote