A quick way to Copy/Paste this.....

G

Gunjani

In Worksheet2, a Table of 80 Columns by 50 Rows; In Row 1 Column 1 I
have a formula 'Worksheet 1'!S5 which should incremnet by 1 in the cells
in Row 1 upto Column 80. In the consecutive rows each column are all
respective replicas of Row 1.

I've tried 'Worksheet 1'!$S5 but this only increments downwards not
across.

Is there a way to increment across and then the cells below each column
to be the same as the cell in row 1.
--
Many Thanks

Gunjani
I must not have fun. Fun is the time-killer. Fun is for
inferiors, servants and the help. I will ignore fun. I will
work through it. And when the fun is gone only I will
remain -- I, and my will to win. Damn, I'm good.
-- The Litany Against Fun
(-Doon-, Harvard Lampoon)
 
A

AlfD

Hi!

Try taking the $ sign off the column letter: 'Worksheet 1'!S5

This will copy across.

Al
 
G

Gunjani

AlfD said:
Hi!

Try taking the $ sign off the column letter: 'Worksheet 1'!S5

This will copy across.

Alf
Click to expand...
But then it increments from S5 to T5,W5,V5,W5,X5 etc....
I want it to increment to S6,S7,S8,S9,S10 etc sme for all the rows...

Row 1 - S6,S7,S8,S9,S10 etc
Row 2 - S6,S7,S8,S9,S10 etc
Row 3 - S6,S7,S8,S9,S10 etc
--
Many Thanks

Gunjani
Youth is a wonderful thing. What a crime to waste it on
children.
--George Bernard Shaw
 
Top