Esmee has attended:
Excel Intermediate course
Creatin g formulas that reference cells on multiple sheets
I have been creating a work book which has two sheets. One sheet has monthly targets and in the other I am creating a sheet that i can add monthly invoicing figures to and then using a formula that uses the monthly target from the other sheet and the cell where I input the invoicing to tell me monthly shortfall.
I have recently done the intermediate excel 2007 course and have been using the notes on page 14 of the manual.
The formaulas have all been calculating correctly but now half way throught the sheet they are not working - not sure what I am doing wrong?
thanks,
esmee
RE: creatin g formulas that reference cells on multiple sheets
Hi Esmee
Thanks for your question
This is ahrd to answer without seeing the files in question
Could you email me copies of the files (perhaps with dummy data in if they are confidential and I will take a look for you)
My email address is sw@stl-training.co.uk
Regards
Stephen
Will be marked as resolved in 5 days
Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.
