Hi,

For a specific project at work, I have been requested to create a
spreadsheet using range names that has 3 identically structured sheets,
one for inputs, one for overrides and one for the actual value to use. I
know this isn't that logical but it has been specified that I do it like
this. What I would like to do is prefix the input range names with FC_
(for financial console), then FCO_ and FCA_ for the overrides and
actual but I don't want to have to type them out 3 times just to add
one letter, especially as there are over 400 range names per sheet. (I
have already entered them on FC_ so maybe I could pastelist the range
names and references and use those somehow??)

Is there a way to create a series of range names using the range names
I have already set in the FC_, so that it copies and applies the
existing range names to the same range on another sheet, but with the
slightly changed prefix?

I have no idea apart from maybe I should use a loop function???

Any help would be greatly appreciated..

Thanks

Adam


--
soteman2005
------------------------------------------------------------------------
soteman2005's Profile: http://www.excelforum.com/member.php...o&userid=29078
View this thread: http://www.excelforum.com/showthread...hreadid=488056