MS Excel - Macros, VB/VBA Automation - Data Filtering
Budget: $30 – $250 USD
I have Job Listings, from Indeed, in Workbook, on SHEET 1.
SHEET 2, i want to have/use, 3 Columns for FILTER the data in SHEET 1.
COL_1=Job Title or Position, I want to ADD key words (even use of ASTERISK) in this COLUMN to FILTER (add/approve/allow) from SHEET 1 to SHEET 3, final OUTPUT SHEET
COL_2=Company or Business Name, I want to ADD key words (even use of ASTERISK) in this COLUMN to FILTER OUT (remove/ignore/delete) from SHEET 1, to SHEET 3, final output SHEET.
COL_3=Location, I want to ADD key words (even use of ASTERISK) in this COLUMN to FILTER (add/approve/allow) from SHEET 1 to SHEET 3, final OUTPUT SHEET
SHEET 3 - is the OUTPUT, from ALL DATA in SHEET 1, using the SHEET 2 Filters (3 columns with a FILTER/APPLY button), and SHEET 3 ends up with the results of both, SHEETS 1 (orig data) and 2 (filtered data) - thus SHEET 3 will have "results", which will be LESS RECORDS/ROWS than SHEET 1, after SHEET 2 filters are applied, then OUTPUT to SHEET 3
SHEET 1 data, will be COPY/PASTED frequently, sometimes daily, each 3 days, 7 day, 14 days or maybe up to 30 days. Data in SHEET 1 will change frequently.
SHEET 2 will always be adjusted/changed/altered, to ADD or REMOVE specific column data, COL 1 = specific jobs/types/titles, COL 2 = specific companies will be listed, added too frequently and COL 3 will probably change (add/remove) maybe 1-2 times per month, minimal changes.
Proof of Concept / POC is REQUIRED to proceed with electing/choosing a Candidate for the Task/Project/Order. I will provide samples, give examples of what i am trying to achieve and you will provide to me, BEFORE COMMITMENT/AWARDING, proof you can do the job!!! No exceptions...
If you are interested, please let me know:
1. How long it will take you to do the project
2. How much you will charge for it
I will provide SAMPLE DATA only upon request.
Thank you!
SHEET 2, i want to have/use, 3 Columns for FILTER the data in SHEET 1.
COL_1=Job Title or Position, I want to ADD key words (even use of ASTERISK) in this COLUMN to FILTER (add/approve/allow) from SHEET 1 to SHEET 3, final OUTPUT SHEET
COL_2=Company or Business Name, I want to ADD key words (even use of ASTERISK) in this COLUMN to FILTER OUT (remove/ignore/delete) from SHEET 1, to SHEET 3, final output SHEET.
COL_3=Location, I want to ADD key words (even use of ASTERISK) in this COLUMN to FILTER (add/approve/allow) from SHEET 1 to SHEET 3, final OUTPUT SHEET
SHEET 3 - is the OUTPUT, from ALL DATA in SHEET 1, using the SHEET 2 Filters (3 columns with a FILTER/APPLY button), and SHEET 3 ends up with the results of both, SHEETS 1 (orig data) and 2 (filtered data) - thus SHEET 3 will have "results", which will be LESS RECORDS/ROWS than SHEET 1, after SHEET 2 filters are applied, then OUTPUT to SHEET 3
SHEET 1 data, will be COPY/PASTED frequently, sometimes daily, each 3 days, 7 day, 14 days or maybe up to 30 days. Data in SHEET 1 will change frequently.
SHEET 2 will always be adjusted/changed/altered, to ADD or REMOVE specific column data, COL 1 = specific jobs/types/titles, COL 2 = specific companies will be listed, added too frequently and COL 3 will probably change (add/remove) maybe 1-2 times per month, minimal changes.
Proof of Concept / POC is REQUIRED to proceed with electing/choosing a Candidate for the Task/Project/Order. I will provide samples, give examples of what i am trying to achieve and you will provide to me, BEFORE COMMITMENT/AWARDING, proof you can do the job!!! No exceptions...
If you are interested, please let me know:
1. How long it will take you to do the project
2. How much you will charge for it
I will provide SAMPLE DATA only upon request.
Thank you!