Excel, formulas on one sheet affecting data on other sheets

formulas on one sheet affecting data on other sheets

Author	Message
Rick #1 / 4	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

Anders #2 / 4	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

rick #3 / 4	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

Anders #4 / 4	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

Page 1 of 1

[ 4 post ]