i need to create a link between 2 worksheets i need all the information from
sheet 1 to go to sheet 2. but, sheet 1 is an invoice an all the information
is enter vertically and sheet 2 all the information is enter horizontally for
each invoice. can i have this information to be link to sheet 2? thank you.

To get Sheet1 A1:A10 copied to Sheet2 A1:J1 enter this is Sheet2 A1 and
drag/copy across to J1

=INDEX(Sheet1!$A:$A,(ROWS($1:1)-1)*1+COLUMNS($A:B)-1)


Gord Dibben MS Excel MVP


On Sat, 22 Sep 2007 13:34:01 -0700, anier614
wrote:

i need to create a link between 2 worksheets i need all the information from
sheet 1 to go to sheet 2. but, sheet 1 is an invoice an all the information
is enter vertically and sheet 2 all the information is enter horizontally for
each invoice. can i have this information to be link to sheet 2? thank you.

i'm gone try, its a hard to understand formula. because in my sheet i have
to jump cells like: g5:g9,b11,b15:b20,g4,g23,g24,g,27 i'm still trying to
figure it out. thank you.


"Gord Dibben" wrote:

To get Sheet1 A1:A10 copied to Sheet2 A1:J1 enter this is Sheet2 A1 and
drag/copy across to J1

=INDEX(Sheet1!$A:$A,(ROWS($1:1)-1)*1+COLUMNS($A:B)-1)


Gord Dibben MS Excel MVP


On Sat, 22 Sep 2007 13:34:01 -0700, anier614
wrote:

i need to create a link between 2 worksheets i need all the information from
sheet 1 to go to sheet 2. but, sheet 1 is an invoice an all the information
is enter vertically and sheet 2 all the information is enter horizontally for
each invoice. can i have this information to be link to sheet 2? thank you.