I can answer questions related to the following topics: 1. MS Excel - Creating and Linking Formulae, Running Pivot Tables, Vlookup etc. 2. Macros / VBA - Creating Macros to do specific jobs. Importing / Exporting / Validating Data in excel through Macros.
I've been working on excel for over 10 years and on VBA macros for over 3 years now.
Bachelor of Commerce, Chartered Accountant from The Institute of Chartered Accountants of India
To me, excel is the most powerful and versatile software I have ever come across. I have not come across any problem which couldn't be handled in Excel.
Learn more and more in excel by answering more and more questions.
|Nat||08/17/16||10||10||10||Thank you very much, works great.|
|Bimmy||08/04/16||10||10||10||Only 1 thing... Hope and Wish that .....|
|Natalie||06/15/16||10||10||10||Thank you Gulshan, i will give the .....|
|Natalie||05/06/16||10||10||10||Thank you very much Gulshan, this works .....|
|Dimitris||04/01/16||10||10||10||Very fast and accurate answer, you are .....|
Dear Jayendran, Can you share more specific details of your problem: 1. What is the error message you're getting 2. What is the pivot table setup you're using 3. Can you share a copy of the file which
Hello Khaled, This can be easily achieved using a Macro. I need a few answers before I start working on it: 1. How does the macro identify the row to be copied, is it the first row / last row / or
Dear Jeff, Excel has a limitation that it can allow only a maximum if 7 if statements within a loop. If you want to use more than 7 conditions, then you'll either have to split the formula across 2
Dear Jason, Thanks for the detailed question. Let me rephrase the question as per my understanding and try to answer it: You are looking for a value in column Z based on certain logic but you don't
Dear Richard, I'm not clear with the question. 1. First up, the dropdown cannot be made conditional upon the value in another cell. Excel supports simple dropdowns. If you still want to have conditional
Answers by Expert: