Apply fomulas to additional worksheets as added

Giganews Newsgroups
Subject: Apply fomulas to additional worksheets as added
Posted by:  Brent E
Date: Thu, 25 May 2006

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