Forum home » Delegate support and help forum » Microsoft Excel Training and help » Creatin g formulas that reference cells on multiple sheets
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Creatin g formulas that reference cells on multiple sheets
Resolved · High Priority · Version 2007
Reply Wed 1 Dec 2010, 10:54Delegate Esmee said...
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
For upcoming training course dates see: Pricing & availability
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
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.
Thu 30 Dec 2010: Automatically marked as resolved.
|