Search results

Hi Excel Gurus, This is an automation issue I am trying to solve and seek help from experts in various forums. I need my excel macro to do the following on Internet explorer (or chrome): 1. Open URL - Click This Link 2. Select Dropdown - "M-Option on UK Natural Gas NBP Future" 3. Click on...

Hi Guys, I got this working now. Seems like the problem is with the Extract. When I extract the CSV file with Date formatted as TEXT, ADO engine is able to identify the date correctly and calculate the correct value. Thanks for you time. Cheers, Ravi.

Hi Excel Gurus, I have this weird problem that is bugging me since yesterday. I am trying to Automate a complex dashboard that queries data from various data input files (in CSV). I am using ADO connection to fetch the calculation queries such as below. The issue I have is when I run this...

Hi Gurus, I have a query to solve in Power Pivot. Seems like a small formula in Excel, I am unable to crack it on Power Pivot. I have 2 tables. Table1: Name, DateIn, DateOut, Product Table2: Name, DateAsOn There are multiple values for the User to use different Product, but falls in different...

Hi Khalid, Unfortunately, data is in an Access table and I got to use the VBA to fetch the value. Any VBA solution to iterate the table and see which grade the value falls and fetch the Grade? Thanks in advance, cheers, Ravi.

Bump!!! Gurus, help please! cheers, Ravi.

Hi VBA Gurus, I need help with this code to fetch the Grade from the following Access Table. Low Score High Score Grade 39 Fail 40 59 Pass 60 74 1st Class 75...

Thank you Hui. Got that solved. cheers, Ravi.

Hi Excel Gurus, I need help with developing VBA code to get a CountIf summary statement from a table. Requirements: I have some data in a table with Name and Activities the person is involved. (there might be multiple activities for one person). There are two tags for each activity - Priority...

Thank you very much Luke. I am sure I tried doing that and thought it isn't working. Probably I am sleepy :) Thanks again. cheers, Ravi.

Hi Gurus, I have an problem with pivot. Ashamed of not to be able to get the thing working. But hopefully one you might enlighten me. Problem data: Month Sales Person Quantity Jan Smith 101 Jan Kiran 125 Jan Smith 111 Jan Smith 110 Jan John 149 Jan Laura 145 Feb Smith 102 Feb Laura 120 Feb...

Hi Gurus, I need help with a macro that copy-pastes an Excel Table (table name: PPTData) into a new Powerpoint slide. And adjust it to the slide size leaving some space on the top. I am quite new to PPT objects. I am able to achieve this for copy-pasting charts but not with tables. Please help...

@SirJB7, Thank you JB7. I should have included the link. It slipped my mind. Thanks for the edit anyway. @kchiba, Your formula worked great. I saw a better approach with the macro, as this is supposed to be used by Excel beginners. Click of a button and everything working fine. Thanks for the...

Yes Abdul, the logic works fine in this attachment. Can you please download and check the last file you sent me? There are 20 tasks. Add Task21 to it and then try running the allocation macro without changing the percentage. cheers, Ravi.

Thanks Abdul. This is exactly what I am after. Made some changes to the code as some scenarios are not working. E.g if we have 21 tasks instead of 20, the last one is left without being assigned. I modified the code and it's working fine. Is there a chance to have generate a report at the end...

Hi All, I have an issue developing a VBA program for a small logic. I tried posting it earlier here with no luck. Seems like I didn't communicate my requirement properly. So I am re-writing my requirements: I need help with a small VBA logic that can loop through a set of tasks and assign...

Hi Kanti, That would be great. I am just trying to get this done through VBA because the number of tasks vary everyday and I need to copy paste the formulae every often. In addition to that, the number of employees is also not fixed. It varies. The only step I need to take is to insert the...

Hi Kanti, Thank you. This helped me and I am trying to build over it. But I am more interested in getting a macro to do this job. I am working on it. Thanks for all the help. cheers, Ravi.

Sir JB7, Thanks for pointing out the gaps in my communication. I uploaded the sample file with possible 3 scenarios and what the outcome should be like. Input: Number of Employees % of Allocation Task List in A:A Outcome: There is no relation between Level 1 and Level 2 tasks. I am going to...

Sir JB7, Thanks for looking into this. Sorry for that. I am loading tasks with Level 1 difficulty assign them to users and the load tasks with Level 2 difficulty. For all level 2 tasks, if there are not enough of them to allocate based on percentage, I need to identify them and allocate 1 after...

Hi Sangram, I have trouble understanding your concept for the VBA macro. It would help if you can upload a sample excel file with the pivot table and data. Regards.

Hi Excel Ninjas, I need help with a small macro to automatically allocate tasks to users based on the % of allocation. Missing clarity? Let me put down the example: I have few tasks (with 2 levels of difficulty) that come up everyday (say 20 in this case) and I have 2 or more employees to be...

Thanks Narayan. This has been quite useful. I'll follow your suggestion here forth and see if I get feedback from implemented projects. I am sure these suggestions converted into a Blog post will be a huge welcome. Please! cheers, Ravi.

Thank you Luke. Your inputs are helpful. It seems like this has been an untouched territory for such a huge Excel Community :( I would be glad if any fellow developers can share screenshots of their best userforms (complex/simple). cheers, Ravi.

Hi Gurus, I have a curious request. I have been an aggressive VBA Developer for the past few years. I observed that the forms I design change for almost every project. I usually take two factors into considerations while designing - End User Age and Type of computer they use (mainly resolution...