Hi,
You have an answer where you posted at:
http://www.ozgrid.com/forum/showthread.php?t=42907
Dave
soteman2005 Wrote:
Hi,

For a specific project at work, I have been requested to create
spreadsheet using range names that has 3 identically structured sheets
one for inputs, one for overrides and one for the actual value to use.
know this isn't that logical but it has been specified that I do it lik
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 an
actual but I don't want to have to type them out 3 times just to ad
one letter, especially as there are over 400 range names per sheet. (
have already entered them on FC_ so maybe I could pastelist the rang
names and references and use those somehow??)

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

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

Any help would be greatly appreciated..

Thanks

Ada

--
Desert Piranh
-----------------------------------------------------------------------
Desert Piranha's Profile: http://www.excelforum.com/member.php...fo&userid=2893
View this thread: http://www.excelforum.com/showthread.php?threadid=48805