R/ sir
i am create a vba code for (Add & clear) Button but This code Will not work in my Sheet i am click on the Add & clear Button the massage was displayed "please fill on the all cells!) please correction in this vba code, Balance, Advance, Due Date, No of Days was fill on the customer requirement if is this was blank, sale date & sale inv. No was not clear click on the Add & Clear Button
Click on the Add & Clear button The Old Sale Invoice No was Clear & new Sale Invoice No was Genrate
i am insert the formula in B10 Cells (=IF(ISERROR(MATCH($B$9,Customers!A:A,0)),"AllCustomers",IF(INDEX(Customers!C:C,MATCH($B$9,Customers!A:A,0))="","",INDEX(Customers!C:C,MATCH($B$9,Customers!A:A,0)))) This Formulla Was working fine but Another cells B11(Show Address line1 & address line2),B12(show City, state, Zip Code) , B13(show Country , E-Mail) , B14 (Show Phone, Mobile, Fax) in thease Cells this formula was not working
Please see the attachments & vba code than correct this vba code
Bookmarks