Excel Table Filter through formula - VBA or Macro


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.

Evner: Databehandling, Excel, Software Arkitektur, Visual Basic, Visual Basic for Apps

Se mere: excel vba filter multiple criteria, how to create a filter macro in excel, how to filter data in excel using macro, vba code to filter data in excel, excel vba filter table by column name, excel vba autofilter, excel vba filter column based on cell value, excel filter macro button, vba macro excel unicode, excel vba macro paste adjacent column, vba macro generate report excel word, paste excel vba macro, excel vba macro databases, excel vba macro programming bids, excel 2003 paste clipboard vba macro excel, excel vba macro calculate business days, excel vba macro find text morld, generate report excel vba macro, vba macro script difference excel, excel word vba macro example

Om arbejdsgiveren:
( 3 bedømmelser ) Offenbach, Germany

Projekt ID: #17836498

Tildelt til:


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 EUR på 1 dag
(39 bedømmelser)

20 freelancere byder i gennemsnit €31 på dette job


Hello, Hope you are doing well. I can help with your project Excel Table Filter through formula - VBA or Macro. I can assure you the quality job. I have good experience in Data Processing, Excel, Software Arch Flere

€39 EUR på 1 dag
(294 bedømmelser)

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

€30 EUR på 1 dag
(380 bedømmelser)

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

€30 EUR på 1 dag
(264 bedømmelser)

Hello, I am experienced excel expert. I can help with this task with quick turnaorund. Looking to hearing from you. Kind regards

€29 EUR på 1 dag
(85 bedømmelser)

Hello sir Welcome in my profile appreciate if you contact me to see how can work on your project , I am cost engineer and deal with huge data base for different fields in mega projects ... and expert in excel and ca Flere

€30 EUR på 1 dag
(21 bedømmelser)

Please share the sample excel sheet which you hvae with the requirement.. Please ping me if you are OK with my bid rate and thank you..

€100 EUR på 1 dag
(24 bedømmelser)

Erstellen von Excel Macro oder VBA Code. Guten Tag, ich bin professioneller Software-Entwickler mit viel Erfahrung im Bereich Automatisierung in Excel oder Word. Ich kann ihre Wünsche ohne Probleme erfüllen. Für weit Flere

€50 EUR in 2 dage
(10 bedømmelser)

Hello. I have rich experiences in Excel and Pivot table. I'm interest to your project. Contact me please. Thanks.

€30 EUR på 1 dag
(10 bedømmelser)

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

€34 EUR på 1 dag
(14 bedømmelser)

Hi Good Day! I can help you to complete your VBA works in less than a day. I am a vba macro developer for over 8 years now and has strong knowledge with Ms Excel Formulas and Functions. I created different templ Flere

€15 EUR in 0 dage
(7 bedømmelser)

Hello! I have experience in Microsoft Excel and Visual Basic for Applications. I can create a VBA macro for your spreadsheet as you want.

€25 EUR in 3 dage
(3 bedømmelser)

About me & what I can provide - • 5 Yrs. of Experience in Excel & VBA. • Knowledge of Formatting, Graphs, Chart & Formulas. • Macro coding for repetitive tasks. • Have worked directly with client for an MNC IT Com Flere

€20 EUR på 1 dag
(2 bedømmelser)
€34 EUR på 1 dag
(0 bedømmelser)
€29 EUR in 2 dage
(0 bedømmelser)
€19 EUR in 7 dage
(0 bedømmelser)

Hi I am Premkumar. I saw your proposal on Freelancer site. I placed my bit and I can do well and deliver correct time .

€24 EUR in 2 dage
(0 bedømmelser)

I can do this very easily I work in bank industry and do this many times My outputs are clean and very nice

€8 EUR på 1 dag
(0 bedømmelser)

Hi. It's me you are finding for. I've developed and I can show you my example. Why don't you send me message? I have read your project with great care and I am sure I can do a perfect job for you. I have good expe Flere

€25 EUR på 1 dag
(0 bedømmelser)

Work with Excel for more than 20 years. Work with all kind of formulas including searching via Index, match and vlookup functions. Building search based on VBA codes based on date, text or numbers. Like any Excel offi Flere

€23 EUR på 1 dag
(0 bedømmelser)