software

I have a reference to another sheet and I need to copy the reference like this:
sheet 2
A B
1 ='sheet1'B1 ='sheet1'B2
2 ='sheet1'E1 ='sheet1'E2

if I try to copy/paste or fill I get b1, b2, b3 going down which I don't
want - I know I can do this manually but I have about 100 rows each approx 10
columns to fill like this.

Put this in Sheet2 A1 and copy across as far as needed then copy down

--

Regards,

Peo Sjoblom

quot;Kiaquot; gt; wrote in message
news
gt; I have a reference to another sheet and I need to copy the reference like
this:
gt; sheet 2
gt; A B
gt; 1 ='sheet1'B1 ='sheet1'B2
gt; 2 ='sheet1'E1 ='sheet1'E2
gt;
gt; if I try to copy/paste or fill I get b1, b2, b3 going down which I don't
gt; want - I know I can do this manually but I have about 100 rows each approx
10
gt; columns to fill like this.
Oops!

=OFFSET(Sheet1!$B$1,COLUMNS($A$1:A1)-1,ROW(1:1)*3-3)
--

Regards,

Peo Sjoblom

quot;Peo Sjoblomquot; gt; wrote in message
...
gt; Put this in Sheet2 A1 and copy across as far as needed then copy down
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; quot;Kiaquot; gt; wrote in message
gt; news
gt; gt; I have a reference to another sheet and I need to copy the reference
like
gt; this:
gt; gt; sheet 2
gt; gt; A B
gt; gt; 1 ='sheet1'B1 ='sheet1'B2
gt; gt; 2 ='sheet1'E1 ='sheet1'E2
gt; gt;
gt; gt; if I try to copy/paste or fill I get b1, b2, b3 going down which I don't
gt; gt; want - I know I can do this manually but I have about 100 rows each
approx
gt; 10
gt; gt; columns to fill like this.
gt;
gt;
Thank you for the super speedy reply.
that solved my needs
much appreciated