How to create formula series

[Michele P.]

I am working with many sheets with in one workbook.

I have a data sheet, that contains all of my information.
I am trying to transfer this information to other sheets
by using formulas.

To help cut down the data entry of all of these formulas,
I thought I could use "fill".

Example: ='DATA SHEET'!$B$1 through ='DATA SHEET'!$CU$1

This information would be in column A.

When I use the auto fill it copies only the first formula
that i keyed in, it does not create a series, like Sun,
Mon, Tues, Wed, etc.

 

[Tom Ogilvy]

remove the $ signs:

in A1:
='DATA SHEET'!B1

if you copy that down column A, in A2 it will be

='DATA SHEET'!B2

if you copy it across, in B1 it will be

='DATA SHEET'!C1