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.

Taidot: tietojenkäsittely, Excel, tietojärjestelmäarkkitehtuuri, Visual Basic, Visual Basic for Apps

Näytä lisää: 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

Tietoa työnantajasta:
( 3 arvostelua ) Offenbach, Germany

Projektin tunnus: #17836498

Myönnetty käyttäjälle:


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 1 päivässä
(39 Arvostelua)

20 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


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 Lisää

€39 EUR 1 päivässä
(294 arvostelua)

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 1 päivässä
(380 arvostelua)

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 1 päivässä
(264 arvostelua)

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

€29 EUR 1 päivässä
(85 arvostelua)

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 Lisää

€30 EUR 1 päivässä
(21 arvostelua)

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 1 päivässä
(24 arvostelua)

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 Lisää

€50 EUR 2 päivässä
(10 arvostelua)

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

€30 EUR 1 päivässä
(10 arvostelua)

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 1 päivässä
(14 arvostelua)

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 Lisää

€15 EUR 0 päivässä
(7 arvostelua)

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 3 päivässä
(3 arvostelua)

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 Lisää

€20 EUR 1 päivässä
(2 arvostelua)
€34 EUR 1 päivässä
(0 arvostelua)
€29 EUR 2 päivässä
(0 arvostelua)
€19 EUR 7 päivässä
(0 arvostelua)

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 2 päivässä
(0 arvostelua)

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 1 päivässä
(0 arvostelua)

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 Lisää

€25 EUR 1 päivässä
(0 arvostelua)

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 Lisää

€23 EUR 1 päivässä
(0 arvostelua)