En cours

Excel Script Filter table and write result in new table

VB Excel script

Hello,

1. due to loads of spam generic bids, please write "i will explain in short how i my macro will work"

2. and also then explain me how the macro will work to make sure i get what i need

3. JOb description:

In general, this is a macro taht is similar to the existing "extended filter" method in excel. but as a script

I have an excel sheet with multiple tabs

• One tab I name FILTER_TAB and contains column names and filter data of the desired filtering method

• Other tabs have different names

• All tabs contain data with column names

Makro sript must:

1. Select the active tab and then

2. filter that active tab table according the columns and filter values of tab FILTER_TAB

3. write the filter result in an new Result_tab (name ideally to be specified by user interactive or as a random name by the macro and user rename them himself)

see attached PDF file for a sample

4. NEED THE JOB DONE IMMEDIATELY

as I need it urgent. so only bidf if you can start and deliver within 1 or 2 hours latest

THANK YOU VERY MUCH

PS: any questions i am available all the time pre bid and during the job execution

Compétences : PHP, Architecture Logicielle

Voir plus : excel vba copy filtered data to another sheet, how to filter data in excel using macro, excel vba filter table based on cell value, excel copy filtered data to another sheet automatically, excel dynamic filter to new sheet, excel macro to filter data and copy to new sheet, macro to filter data and copy to another workbook, vba filter data and copy to new sheet, excel vba filter table, mysql export table excel script, import excel sheet existing access table vb, filter related table vb, filter data excel script, excel pivot table vb script, update table excel script

Concernant l'employeur :
( 67 commentaires ) munich, Germany

N° du projet : #14921577

Décerné à :

alexanderrubtsov

i will explain in short how i my macro will work My algorithm is as follows: Cycle throw rows of the active tab and check if the filter matches. Relevant Skills and Experience I have done a lot of VBA programming. I Plus

30 € EUR en 1 jour
(8 Commentaires)
4.2

8 freelance ont fait une offre moyenne de 89 € pour ce travail

A2Design

Hello, We are a team of 30 developers based in Russia. If you you need help with: - Website/web application/e-commerce development (any complexity) from scratch or using a premade solution - Front-end and back-en Plus

350 € EUR en 3 jours
(98 Commentaires)
8.5
expertjlm

I have 5 years experience about CMS ( WordPress, Joomla), PHP, HTML, CSS, Javascript, PSD to CMS, PSD to HTML. Relevant Skills and Experience PHP, WordPress, CSS, HTML, Website Design, SEO, HTML5, Javascript Proposed Plus

26 € EUR en 40 jours
(54 Commentaires)
5.8
34 € EUR en 40 jours
(7 Commentaires)
4.0
oliviainfotech

Hi greetings of the day I am a Experienced PHP Developer based out in Chennai,India. My experience revolves around development of web and mobile applications,Ecommerce websites. Relevant Skills and Experience I believ Plus

100 € EUR en 40 jours
(33 Commentaires)
4.4
shanymathew

Dear Sir, am excellent in PHP. i can do it perfectly please reply wish to do this task Relevant Skills and Experience PHP,MYSQL,CODEIGNITOR,EXCEL,AJAX,JQUERY,HTML,CSS Proposed Milestones €39 EUR - 2 DAYS

39 € EUR en 40 jours
(22 Commentaires)
3.8
huongth

Hi. I can create auto scripts to scrape websites, auto click, format txt, csv, xls, xlsx, doc, docx, rtf, json, xml, database files as you request. I can start right now Relevant Skills and Experience I am an expert i Plus

100 € EUR en 3 jours
(10 Commentaires)
3.8
gpa0323

I have 3+ years of experience with Website Design and Development with php, WordPress, Wix, Magneto, Shopify, php based cms, Bootstrap, HTML, CSS, asp.net. Relevant Skills and Experience I can provide my services in P Plus

34 € EUR en 2 jours
(0 Commentaires)
0.0