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 Richard, 923505 looks like a feasible solution but then I'm not a big fan of copied versions of excel, not sure how the update could affect the bus ability of your excel file. If it was me, I'd
Dear Richard, This looks like an issue with the particular font. Can you try one of the following options: 1. Try changing the font on the chart labels and see if the image gets clearer. 2. Try increasing
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
Answers by Expert: