Using rangename in relative reference

A

Arthur

Say I have 12 months of data in 12 columns of one row. I'd
like to create a rangename for the January data, use that
rangename in a formula elsewhere, and then copy that
formula to the 11 columns to the right. But I don't want
to lock in the original rangename cell as an absolute
reference when I copy it. Lotus 123 has this flexibility
with rangenames, but it seems Excel does not. Am I just
missing this feature somewhere?

Art
 
C

Charles Williams

Hi Art,

create your range name and the edit the refersto formula to remove the $
before the column reference.


Charles
______________________
Decision Models
FastExcel 2.1 now available
www.DecisionModels.com
 
F

Frank Kabel

Hi
AFAIK Excel does not have this feature. You could create some
workarounds using INDEX and a range name in combiantion
 
Top