software

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.quot;Bobquot; wrote:

gt; Hi
gt; I have a spreadsheet which is linked to a source spreadsheet. Links in the
gt; target spreadsheet repeat every 100 rows.
gt; ex; FL_EDEN State Submission Plan 2005-06.xls]Middle'!E1
gt; FL_EDEN State Submission Plan 2005-06.xls]Middle'!E2
gt; .
gt; .
gt; .
gt; I would like to copy the above 100 formulas to row101-200 and replace the
gt; VA with another value like NY without changing the rowcount (lt;---) in the
gt; formula. When I use paste special or insert cells the rowcount at the end of
gt; the formula is changing
gt; VA_EDEN State Submission Plan 2005-06.xls]Middle'!E101 lt;----
gt; VA_EDEN State Submission Plan 2005-06.xls]Middle'!E101 lt;-----
gt; .
gt; .
gt; .
gt;
gt; result should look like this:
gt; NY_EDEN State Submission Plan 2005-06.xls]Middle'!E1
gt; NY_EDEN State Submission Plan 2005-06.xls]Middle'!E2
gt; .
gt; .
gt; .
gt; How can I do this.
gt;
gt;
gt;
gt; Please Inform.
gt;
gt;
gt;
gt;
gt;
gt;
gt;
gt;
gt;