Hi,
On the Status sheet I need the INVOICE AMOUNT but these are calculated on the Lookup Invoice sheet which are only done when the particular Invoice Number is present on that sheet.
Is there a work around with formulas to achieve this please?
Thank you very much,
bj
I am sorry for this difficult posting.
Does anyone have a suggestion on perhaps a helper column to store the invoice totals?
Should I close this thread due to no responses?
You are being impatient again.
Threads are never closed unless they are duplicates or not welcome here.
I woudl suggest updating the thread title to give a more accurate indication of what you are trying to do - this probably requires more than three words.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Okay thanks
Not clear idea, but as per my view.
"a10"Formula:
Please Login or Register to view this content.
Criteria mentioned in "A1" ='Lookup Invoice'!H3
File attach : Refer status sheet
Last edited by avk; 08-08-2019 at 09:29 AM. Reason: file attach
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
Thanks for the help but I was hoping to have all totals on the Status sheet from all Invoice Numbers. I put what should be the amounts for each Invoice.
Can you show me step by step calculate. How comes value?
The value comes from the Lookup Invoice sheet based on the Invoice Number entered in cell H3. As you change the Invoice Number from 101, 102, 103 the value in H44 changes in the Lookup Invoice sheet. There are many steps to get to that value.
But you will need to explain the steps.
As you have only one reusable invoice sheet, Excel will need to take the value from elsewhere, as what's on that sheet is ephemeral.
If you want it to be taken from that sheet, then we are back to VBA, and of course you don't really want that.
There are so many calculations and is overwhelming for me to figure it out in one formula. If it isn't possible I will make a note and manually copy and paste when each invoice is created.
I really do appreciate experienced help because this may be beyond my capabilities at the moment.
If you don't want to use VBA to write the invoice data to the record sheet, then that's what you will have to do.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks