Search results

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...

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...

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...

Hi.. Enclosed file with Database and Report to be generated. Here The database may run in 5000 to 1000 rows. I need to generate Report as under Out Put Report to be Generated Emp Code Green Group Blue Group Others Total 13637 11 9 6 26 12950 9 10 18 37 10670 12 6 0 18 I...

Hello Friends, Enclosed here zip file with two files. 1. Sample File - Sample Data.xls a. First Sheet - Database b. Secord to Forth Sheets - Output for Slide 1, Output for Slide 2 and Output for Slide 3 2. Output file Required - Output Sales...

Hi.. I have an Excel file where I wanted to run my own macro. But when I go to Developer-->Macro menu, I find that there is already one macro available, and only Run and Cancel buttons are enabled. All other buttons are disabled. Require help ## 1. How to activate other buttons. 2. If present...

Dear Experts, I use simple formulas... Attached herewith sale report where Branch Name, Opening balance, Day Sales and closing balance available in the file. Now, there may be some occassions where some of branch(s) do not send any report and I need to mention this at the bottom of report...

Hellow Friends.. Attached herewith file with requirement.. Can any one help here.. Thanks.. Kundanlal

Dear Sir, Using something like at K5, =COUNTIFS($D$5:$D$35,$J5,$I$5:$I$35,">=&($G$5/ROUND((($E$5/12)*$E$2),2))100%",$C$5:$C$35,"BM").. Please help me in this.. Attaching sample file with required output. (Basically, wanted to count all such records in range with another condition of role='BM'...

Required to create report for each country with same sheet names and data for that country.

I have taken a help from Chandoo's Portfolio Manager. The simple portfolio manager that Chandoo has designed is very good. I have a statement in pdf file where date-wise investment is listed. So as to update similar data in XLS file, I need to append this data in .pdf file into Excel. Need help pl.

I have a file with data in sheet1 as follows which is being updated by downloading through WEB every day. The data gets replaced for every date. Date Name of Fruit Price 10-Oct-10 Banana 12 10-Oct-10 Apple 60 10-Oct-10 Mango 100 I need to create a consolidated data for each day as...