Filling multiple ranges/selections across worksheets

[Excel Chimp]

Hi folks. I have a workbook with about 25 sheets, all identically formatted. Column G contains both hard coded values and formulas. I need to fill ONLY the formulas across all worksheets.

I tried using F5 to select all formulas and do so, but it appears that since the data is not contiguous, it's not possible.

Does anyone have a solution?
Thanks

Excel Workbook
	G
3	MAY
4	94.5%
5	96.0%
6	1.5%
7
8	41
9	48
10	12
11	9
12	19%
13	19%
14
15	20
16	10
Ashford

Excel 2010

Cell Formulas
Range	Formula
G5	=SUMIF(BScode,W6,Data!F74:F101)
G6	=+G5-G4
G9	=SUMIF(BScode,W6,Data!J74:J101)
G11	=SUMIF(BScode,W6,Data!K74:K101)
G12	=IF(ISERROR(+G11/G9),"NA",(G11/G9))
G13	=SUMIF(BScode,W6,Data!L74:L101)

Excel Workbook
Name	Refers To
BScode	=Data!$C$74:$C$101
Workbook Defined Names

 

[markmzz]

Excel Chimp,

Try this:

Important: make a copy of your workbook first.

1. Create a sheet with only the formulas (sheet 26).

2. Copy one rectangular region that contain the formulas and blank cells in the sheet 26.

3. Now, select the others 25 worksheets (a group of sheets).

4. Select the cell in the upper-left corner of the rectangular region (the same of the step 2) of destination in a spreadsheet of the selection (any one in the group).

4. Choose the Paste Special command, choose Formulas, select the Ignore Blank option and then click OK.

Markmzz