"Bonnie" wrote in message
...
Hi there! Using E02 on XP. Not a programmer but love
learning better ways to do stuff.

I have data being generated from an ooooold Lotus 1-2-3
file that can be pasted into Excel as values. There are 5
reports. Need about 100 cells from each for a big one page
summary report. (Someone has been typing it each month!)

So, I have created a file with the summary report on sheet
1 and the 5 Lotus reports are pasted to sheets 2-6. And
now I'm experiencing the joyous pain of typing a few
thousand formulas to link the cells. If I try to
copy/paste the formulas to speed things up, Excel keeps
using the wrong logic to 'change' the cell reference.
Problem is, my links on sheet 1 are linear and my data on
sheets 2-6 is running columnar. (Transposing the report
data is not an option.) So, what I want is:

=P4!R26 =P4!R27 =P4!R28
=P4!S26 =P4!S27 =P4!S28

When I try a copy/paste, I get something like this:

=P4!S27 =P4!T27 =P4!U27

Is there a way to paste a formula EXACTLY as you copied
it? Then I could just edit the letters as I go. Also, once
I get sheet2 linked to sheet1 is there a way to copy all
the links to sheets 3,4,etc.?

Just looking for a quick overview of tips and shortcuts to
best use my brain rather than frying it with monotonous
typing. Thanks in advance for any help or advice!!!

Instead of =P4!R26, try =$P$4!$R$26

/Fredrik