Hi
I have combobox1 contains customers names and combobox2 contains two words PAID,NOT PAID and combobox3 contains BUYING , SELLING , BUYING RETURNING , SELLING RETURNING , textbox1 contains invoice number and textbox2 contains amount .
what I want if I select CUSTOMER from combobox1 and select BUYING or SELLING RETURNING from combobox3 and select NOT PAID FROM combobox2 then will copy date today in column A and combobox1 to column B and combobox3 & textbox1 to column C and textbox2 to column E ,if I select CUSTOMER from combobox1 and select SELLING or BUYING RETURNING from combobox3 and select NOT PAID FROM combobox2 then will copy date today in column A and combobox1 to column B and combobox3 & textbox1 to column C and textbox2 to column D , if I select CUSTOMER from combobox1 and select BUYING or SELLING RETURNING from combobox3 and select PAID FROM combobox2 then will copy date today in column A and combobox1 to column B and combobox3 & textbox1 to column C and textbox2 to column D ,f I select CUSTOMER from combobox1 and select SELLING or BUYING RETURNING from combobox3 and select PAID FROM combobox2 then will copy date today in column A and combobox1 to column B and combobox3 & textbox1 to column C and textbox2 to column E. with considering the sheet name is CUSTOMER and there is lastrow (TOTAL) in column A to sum the whole columns D,E and column F =D-E
so if there is no empty row before TOTAL row then should add before TOTAL row to add data from userform with the same formulas and formatting .
thanks.
I have combobox1 contains customers names and combobox2 contains two words PAID,NOT PAID and combobox3 contains BUYING , SELLING , BUYING RETURNING , SELLING RETURNING , textbox1 contains invoice number and textbox2 contains amount .
what I want if I select CUSTOMER from combobox1 and select BUYING or SELLING RETURNING from combobox3 and select NOT PAID FROM combobox2 then will copy date today in column A and combobox1 to column B and combobox3 & textbox1 to column C and textbox2 to column E ,if I select CUSTOMER from combobox1 and select SELLING or BUYING RETURNING from combobox3 and select NOT PAID FROM combobox2 then will copy date today in column A and combobox1 to column B and combobox3 & textbox1 to column C and textbox2 to column D , if I select CUSTOMER from combobox1 and select BUYING or SELLING RETURNING from combobox3 and select PAID FROM combobox2 then will copy date today in column A and combobox1 to column B and combobox3 & textbox1 to column C and textbox2 to column D ,f I select CUSTOMER from combobox1 and select SELLING or BUYING RETURNING from combobox3 and select PAID FROM combobox2 then will copy date today in column A and combobox1 to column B and combobox3 & textbox1 to column C and textbox2 to column E. with considering the sheet name is CUSTOMER and there is lastrow (TOTAL) in column A to sum the whole columns D,E and column F =D-E
so if there is no empty row before TOTAL row then should add before TOTAL row to add data from userform with the same formulas and formatting .
thanks.
