formulas on one sheet affecting data on other sheets 
Author Message
 formulas on one sheet affecting data on other sheets

I have a workbook with 10 worksheets that are set up
identically, with the exception of the raw data in each
cell.

I would like to be able to enter formulas in a specified
range of cells in the first worksheet and have those
formulas within that range automatically copy to the other
worksheets (within the same range of cells) so that their
calculations would apply to each of the worksheets
independently.

Am I making sense?

thanks,
Rick



Tue, 06 Sep 2005 07:18:43 GMT  
 formulas on one sheet affecting data on other sheets
If you select multiple sheets by Cmd-clicking the sheet tabs, the formulas
you enter on the visible sheet will also be entered on the other sheets in
the selection. This also applies to all kinds of formatting such as column
widths, fonts, borders etc.
Don't forget to de-group the sheets when your'e dine.

HTH
Anders



Quote:
> I have a workbook with 10 worksheets that are set up
> identically, with the exception of the raw data in each
> cell.

> I would like to be able to enter formulas in a specified
> range of cells in the first worksheet and have those
> formulas within that range automatically copy to the other
> worksheets (within the same range of cells) so that their
> calculations would apply to each of the worksheets
> independently.

> Am I making sense?

> thanks,
> Rick



Tue, 06 Sep 2005 07:31:46 GMT  
 formulas on one sheet affecting data on other sheets
Anders,

Is "Cmd-clicking" the same as Control-clicking?

Thanks,
Rick

Quote:
>-----Original Message-----
>If you select multiple sheets by Cmd-clicking the sheet
tabs, the formulas
>you enter on the visible sheet will also be entered on
the other sheets in
>the selection. This also applies to all kinds of

formatting such as column
Quote:
>widths, fonts, borders etc.
>Don't forget to de-group the sheets when your'e dine.

>HTH
>Anders



>> I have a workbook with 10 worksheets that are set up
>> identically, with the exception of the raw data in each
>> cell.

>> I would like to be able to enter formulas in a specified
>> range of cells in the first worksheet and have those
>> formulas within that range automatically copy to the
other
>> worksheets (within the same range of cells) so that
their
>> calculations would apply to each of the worksheets
>> independently.

>> Am I making sense?

>> thanks,
>> Rick

>.



Tue, 06 Sep 2005 07:47:31 GMT  
 formulas on one sheet affecting data on other sheets
Yes. Sorry. I was born on in a Macintosh :)

Anders



Quote:
> Anders,

> Is "Cmd-clicking" the same as Control-clicking?

> Thanks,
> Rick
> >-----Original Message-----
> >If you select multiple sheets by Cmd-clicking the sheet
> tabs, the formulas
> >you enter on the visible sheet will also be entered on
> the other sheets in
> >the selection. This also applies to all kinds of
> formatting such as column
> >widths, fonts, borders etc.
> >Don't forget to de-group the sheets when your'e dine.

> >HTH
> >Anders



> >> I have a workbook with 10 worksheets that are set up
> >> identically, with the exception of the raw data in each
> >> cell.

> >> I would like to be able to enter formulas in a specified
> >> range of cells in the first worksheet and have those
> >> formulas within that range automatically copy to the
> other
> >> worksheets (within the same range of cells) so that
> their
> >> calculations would apply to each of the worksheets
> >> independently.

> >> Am I making sense?

> >> thanks,
> >> Rick

> >.



Tue, 06 Sep 2005 08:16:07 GMT  
 
 [ 4 post ] 

 Relevant Pages 

1. Formula on one sheet not working, works on others

2. Problem with formula on one sheet that needs to be referenced another sheet

3. How to use data fron one sheet to print forms created in another sheet

4. automaticly copying data from one sheet into another sheet using VBA

5. Inserting data on one sheet from another sheet

6. HELP! Summarize sheet data on one sheet

7. using data from one sheet to populate multiple sheets

8. Formula to pull data from one sheet and paste into another

9. formula importing data from one sheet to another

10. Writing formulas drawing data from more than one sheet


 
Powered by phpBB® Forum Software © phpBB Group