Hi

Change the formula a bit
=Sheet!$A$1

Or, when you are coping the formula to singel cell, and don't want to use
absolute references for some reason:
Select the cell with original formula, select the formula in formula bar (at
top of Excel window, below menus), and copy it.
Select the cell you want to copy the formula in, point with mouse into
formula bar, and paste the formula in.


--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets


"HHTV Rich" <HHTV wrote in message
...
Trying to copy formulas but don't want to have to readjust them when i've
finished.
Is there any way to prevent this?

eg:

Row 1: =sheet!A1

pasted to:
Row 3: =sheet!A3

but I want:
Row 3: =sheet!A1

Trying to create a timesheet file, quite complex and want to minimise the
workload!