Đang Thực Hiện

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

Kỹ năng: PHP, Kiến trúc phần mềm

Xem thêm: 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

Về Bên Thuê:
( 67 nhận xét ) munich, Germany

Mã Dự Án: #14921577

Đã trao cho:

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 Thêm

€30 EUR trong 1 ngày
(8 Đánh Giá)
4.2

8 freelancer đang chào giá trung bình €89 cho công việc này

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 Thêm

€350 EUR trong 3 ngày
(98 Đánh Giá)
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 Thêm

€26 EUR trong 40 ngày
(54 Đánh Giá)
5.8
€34 EUR trong 40 ngày
(7 Đánh Giá)
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 Thêm

€100 EUR trong 40 ngày
(33 Đánh Giá)
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 trong 40 ngày
(22 Đánh Giá)
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 Thêm

€100 EUR trong 3 ngày
(10 Đánh Giá)
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 Thêm

€34 EUR trong 2 ngày
(0 Đánh Giá)
0.0