RE: Apply fomulas to additional worksheets as added

Giganews Newsgroups
Subject: RE: Apply fomulas to additional worksheets as added
Posted by:  Miguel Zapico
Date: Thu, 25 May 2006

You can use replace, from the Edit menu.  In the "Find what:" box type the
old worksheet name, and in the "Replace with:" type the new worksheet name.

Hope this helps,
Miguel.

"Brent E" wrote:

> Good morning,
>
> Is there an easy way to apply formulas to additional worsheets as they are
> added, e.g. take all formulas on SheetA that calculate data on SheetB, and
> make the formulas now point and calculate data on sheetC (if worksheet is in
> same format and placement)?
>
> For instance, If I build a worksheet (on Sheet2) that has numerous formulas
> to conduct calculations on Sheet3, then if I import a download data from an
> online source into Sheet4 (in the same format as sheet3), is there an easy
> way to make all the formulas in my Sheet2 now calculate Sheet4 data?
>
> Thanks, Any suggestions are greatly appreciated.

Replies

In response to

Apply fomulas to additional worksheets as added posted by Brent E on Thu, 25 May 2006