Hi,

I have my business accounts on Excel.

I have a worksheet called Hours with 5 column headers; Week Ending
(formatted as date), Invoice (formatted general), Hours (formatted custom
00), Rate (formatted currency), Total (formatted currency)

I have another worksheet called Invoice and I would like to be able to
display the contents of the last cell in each column from the Hours
worksheet so I can automatically derive the data on the Invoice sheet from
the hours sheet.

Each week I add another line on the Hours sheet and the contents will be
different in each cell again.

How do I do this please ?

Thanks

Jane xxx