formula problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
I have a spreadsheet which is linked to a source spreadsheet. Links in the
target spreadsheet repeat every 100 rows.
ex; FL_EDEN State Submission Plan 2005-06.xls]Middle'!E1
FL_EDEN State Submission Plan 2005-06.xls]Middle'!E2
 
One way you could it:

First, click Edit/Find, enter the = sign in Find What. Replace with %%.
Replace all. This will change your formulas to text. Now copy your formulas
and paste them to another blank worksheet. Go back to your first worksheet
and click Edit/Find, enter %% in Find What. Replace with = and replace all.
This will change your original formulas from text back to formulas.

Now go to the formulas you copied to the empty sheet and cut/paste them back
to the first worksheet starting at row 101. Now click Edit/Find, enter %%VA
in Find What. Replace with =NY and replace all.

Be sure to back up your work. Hope this helps.
 
Back
Top