Thanks sir perfect answer .... :-)
Here is the excel sheet to download http://www.datastatz.com/INDEPTHStats/INDEPTHStats_automation.xls
This is the current sheet [img alt_text='' description='']http://vbaf1.com/q/wp-content/uploads/2017/04/current.jpg[/img] What I want is below [img alt_text='' description='']http://vbaf1.com/q/wp-content/uploads/2017/04/expected.jpg[/img] Last...
Could you please provide the screen-shots of the both the sheets.
Hi, Here is the VBA code to save the file at desired Location with Today's date: [code] Sub VBAF1_SaveFileWithTodaysDate() strFolderPath...
Excel Formula for Last Quarter Criteria: =COUNTIFS(Sheet2!C:C,"sev-1",Sheet2!B:B,">="&DATE(YEAR(TODAY()),FLOOR(MONTH(TODAY())-1,3)+1-3,1),Sheet2!B:B,"
Sir, this code is not producing any output. can you recheck once. Regards, Narsing Rao
Sir, Thanks a ton , the formulas are working perfectly. i had a great difficulty in finding the formula...
I used to fill the dates for a “database” with STD text boxes. How can I change it to comboboxes? …