multiple if formulas

I think the above answers what is asked, but I imagine the values need to stay on the maintenance due tab, when another bill is to be printed, and they will disappear.

I can not see the point of the formula, and how in the real world it would help Sharbazk. this is more a reflection on the question not the answer!

I could see the formula becoming a value and staying there (although a VBA approach is likely) until it had been paid, but with a formula it will just disappear

Thanks for your help.

But the values are getting disappeared when selected another flat number. it should not get override.

Can you please help me with that

Thanks Davsth,

You are right !!!

The question is when are you going to populate information and where

if you directly entered the information on the background sheet, you could pull it into the invoice

But with regards to overwriting existing values or writing to the sheet with vba Im not sure you have explained how you wish it to work

currently you would match the month and the flat


something like this to keep it simple for you
in o7 =IF($K$11>0,MATCH(G6,'Maintenance Due'!5:5,0),"")
in o8 =IF($K$11>0,MATCH(D7,'Maintenance Due'!A:A,0),"")


then some code to update value in due sheet, attach to a button

Please Login or Register  to view this content.

you clikc the button and it updates the background sheet. save as xlsm