Hi Everyone..
Need some help from experts.
Sample file attached..
1. There is input list where on daily basis there will be records will be added
2. Every time need to unique values from Input values (code+Branch Name) and paste in output colum J and k, paste formula
3. I don't want to...
Dear Experts,
My query is if Outlook software is not installed in computer, and if user is using outlook (Office 365 outlook through brower based login), whether excel VBA will be operative.
If yes, what changes would be required to carry out for email sending vba.
Thanks..
Kundanlal
Dear Experts,
I am using an Automailer which is taken from our this forum posted by one of our expert friends which I find as an excellent tool for sending mail to multipler email ids. I really appreciate for this code. I don't remember the name of creator but I really want to thank him.
I...
------------------------------------------
Dear Sir,
The formula worked fine for entire table. However, now if I add dates in column say (I) in table and if need to generate the report monthwise, how do I go for that.. i.e. for June 19, July 19, August 19, Sept 19 etc., means now unique...
Dear Sir,
But whether it will count while there is formula Vlookuobin those all cells.. I tried this but got error.. Using excel 2007 ver..
Thanks and Regards..
Kundanlal
Hello Everyone,
Need small help.
Enclosed herewith a sample file cosist of table as under :
Code
Emp Name
Date
Emp Code
CON113511
CANEE
19-Jun-19
CON122250
Dodya
20-Sep-19
CON126295
Sumeet
26-Sep-19
CON132221
Pradeep
4-Jun-19
CON132221
CON134709
Laksmikant...
Hello Every One..
Need one help..
Enclosed please find a Sample file with some data.
I need to Save Each Sheet as a Seperate File (with what ever data available in respective sheets) with Same Name as that of Sheet.
Also need to add some Text and date alongwith file name(if vba can as Text...
Appreicated.. Thanks Sir.. I will certainly use this...
Actually, these report so generated is part of my other report.. Forumula based solution is very much welcome..
Regards,
Kundanlal
Hi..
There is a Raw data (running in 500 rows with multiple Sub-Agent No for earch Main Agent Name) which is required to sum (My Sale Rs-total and Others Sale Rs-total) on the basis of Sub-Agent No+Main Agent Name, rank it on the basis of Others Sale Rs-Total and generate report for top 3 as...
Thanks.. The Report so generated are counting of what ever items (irespective of repeatation) available in column A for given condition.
However, the requirement is to Generate Report on the basis of ...
Unique Values in Column A for Emp Code=12950 and Customer Type=Green Group or Blue Group...