I have a table in sheet 1 and want in sheet 2 a formula which is connected to a filter which shows me depending on the filter I choose in sheet 2 only particular rows from sheet 1. Sheet 1 will be replaced monthly. Sheet 2 should be programmed that it pulls the numbers from sheet 1. An easy way to illustrate is Pivot table. The only thing is that I need this all formula based, maybe via VBA or Macro. So that always when the sheet 1 1 is being replaced by a new report I click on a button in sheet 2 and it gives me what I want to see.
I am an Excel expert with a lot of experience in VBA and complex formulas. I am confident that I am the best freelancer for this project. Feel free to contact me so we can discuss the details of this project.
20 freelancere byder i gennemsnit €31 på dette job
Hello , I have read your project description and understood your requirement. I have 5 years experience in Excel VBA programming. I can complete task within time with 100% accuracy. With Regards, Sai
Hello client I understand what is to be done in this project. I will provide a button which will fetch the data from sheet 1 to 2 depending on the filter you provide. Kindly contact me. Roy
I can do this. please review my profile and inbox me. I have good command over MS Excel especially povit table, charts, advance formulas, formatting, macro, VBA etc. thanks