Altering a referenced cell's formula consistently

[Alex]

I am working on a population pyramid template for age,
sex, and race. I use simple linking between worksheets to
get the raw data into a usable form for the first race,
but then I need to systematically change the row on the
raw data listing to reflect a new race. I am wondering if
there is a way to create a formula that takes the
referenced formula in a different location and alters it
to reflect a consistent pattern.

For example:
A B C
4 White County
5 Male Beaverhead Big Horn
6 0-4 =ARSPop2000!G3 =ARSPop2000!G4
7 5-9 =SUM(ARSPop2000!H3:I3) =SUM(ARSPop2000!H4:I4)
8 ...
....
44 Black County
45 Male Beaverhead Big Horn
46 0-4 =ARSPop2000!G59 =ARSPop2000!G60
47 5-9 =SUM(ARSPop2000!H59:I59) =SUM(ARSPop200...
48 ...
....

I want to something like for B46 =alter(B6,G3+56)
(Alter the formula in B6 by adding 56 to G3 to make G59)
Is my idea a possibility in some worksheet function?
If not, any ideas for another way to get to the solution
would be appreciated.

Thanks.
Alex

 

[Jonathan Cho]

You can try the search and replace function. In your
exmaple, highlight the relevant cells, hit alt E, E and
replace G3 with G59.

Regards,

Jonathan

 

[Alex]

I am going to have to do that for 58 counties, 6 times.
that is a lot of manual labor time doing something I may
have to repeat for other states beside Montana.