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

On Fri, 7 Dec 2007 12:13:02 -0800, pennyb9
wrote:

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.