Search results

Hi All, Almost, Dianacris has provided done 95% of task, now only challenge left is how to copy data for today's date and insert in column E. Regards, Maunish Patel

Hi Ninjas / Membes / Experts, Can someone provide some lights on above given query. Regards, Maunish Patel

Hi Dianacris, I am okay if data is pasted in another sheet and then send it to outlook mail. Could you please work on copying data for specific date range? Which i have asked at starting in this post. Once that is seen than we can have go for few altertation or modification. Also i was not...

Hi Dianacris, Yes, i want data inserted into email body not attachment. For attachment I have macro which i found from Chandoo Forum. Here it goes attached, however even this will not be useful. Regards, Maunish Patel

Hi Team, I am clubbing my previous thread here, due to Thread name i have posted incorrect, hence there were no views towards it. http://chandoo.org/forum/threads/send-mail-from-excel-to-outlook.22962/ Here goes my query : I have an excel file each month with three different worksheet. I...

Hi Team, Can some expertize look into this ? Its very urgent. Regards, MP

Hi Team, Just to add-in i found this code, however can you also add requirement which i have said - 4 different mails from 3 different worksheets and data need to be pasted for today's date only. I have attached excel which i found. Sub Preview() I = Cells(2, "B").Value ' dynamising...

Hi Team, I was going through many articles in this forum to check VBA code to send mail from Excel to Outlook directly. I got a great link http://www.rondebruin.nl/win/s1/outlook/bmail3.htm, however this still doesnt full fill my requirement. This is a snapshot what my requirement are...

Thanks Luke, I initially used same kind of formula if Countif :-). All credits goes to ninja's like you. I search this formula from forum and tried to apply it. Hats off to all of you Ninja's & members. Regards, Maunish PAtel

Hi Team, I am creating a dashboard for my helicopter view, I was not able to think best what can be done from this pivot table and Dashboard output. I was looking for a Overview sheet which will show me all information in single go such as : If I select Name it should show which team he /...

Thanks a ton Pavan S.

Hi Team, I want to count cells conditional formatting highlighted cells from on another worksheet here ... Please find attached workbook. Regards, Maunish Patel

Yes, Pavan again you are genius !! It worked !!! Awesome !!!

Hi Nebu, Data is showing incorrect on dashboard. Also each sheet has some data, still data is not copied on Dashboard! Also Check worksheet Reaff Audit, count is showing 108 however dashboard is showing 1386. Each sheet data needs to be pasted on said header name on dashboard. Regards...

Pavan.S helped me a lot in my previous post regarding data collecting. Now its time for upgrade :-) Team, Please help here in this VBA error glitch

Hi Team, Could you please check below given error while running macro > I tried to replace VBA code, however some glitch happed which turned this error. How to get rid of it. Please find attached file also along with VBA code I havent pasted VBA code here due to character limitations...

Yuppy Yuppy Great worked Perfecto ... 1000+ Likes to you Pavan. HatsOff !!!! Now Lets take a sitution> Regarding you have use Range as Sheet #, if i have fixed sheet names. How to Replace them ? I have highligthed it.

Makes Sense. I can start this from today itself, but i need to prepare data review for last quarter. Try to help out here Also, I tried to use Index & Match formula, i was succesful at start but didnt saved file and later tried again, values i am not getting. Please Help out for both issues...

Reason moving dashboard to different sheet, team members will update data daily. Hence i will require to have a dashboard for each day :-( hence i need a universal dashboard where i will move dashboard in beginning of each day sheet and get output resulted. Hope this information helps you :-)...

Hi Pavan, I did tried to replace formula from first row and dragged till end, however still facing issue. Please find attached different workbook for your reference to test. Even after replacing formula it still gives error or values are not correct. Also I have done some alternation...

@ Ninja's Could you also have a look here. Only challenge now is when i copy dashboard sheet to another workbook, formula reference is selected from previous workbook.

Thanks Nebu ! This is what i want !!!

Hi Pavan, Issue got resolved but sorry to bother you again, new issue generated that whenever i move this Dashbaord sheet to another Queue Workbook, formula still consists of Queue (1) book, it doesnt get replaced. Is there a way to get it replaced ? Please find attached 2 different...

Hi Team, Is there a way for a I will insert data in sheet and run VBA code to umerge horizontal data then transpose it to vertical data and refresh pivot. Once data is collected then I would also like to have a Macro for RESET which will reset my VBA code. Merged Data Looks Like this ...

Hi Pavan, I have unmerged cell --> aligned them centrally. However still formula gives error. Please check