Update and Fill Links

P

pennyb9

I have a worksheet that needs to pull info each month from another new
worksheet. Is there an easy way of doing a copy & fill from cell A1 through
A31 in the first worksheet linking to the other worksheet cells A8 through
AE8?
Thanks for any help you can offer.
 
G

Gord Dibben

Entered in sheet1 A1 and copied down to A31

=INDEX(newsheet!$8:$8,ROWS($8:8))

Where newsheet is the name of the new worksheet.


Gord Dibben MS Excel MVP
 
Top