Microsoft Excel - MACRO or VB/VBA - help to EXTRACT rows from data
$10-30 USD
Paiement à la livraison
I have data…sometimes 100’s, sometimes 1,000’s of “rows” – data is typically from Indeed.com.
Of this data, I need help with a solution that allows me to EXTRACT entire ROWS…
Then I need to DELETE entire ROWS from remaining records/lines
All from the Source Data, and put into another SHEET in the same WORKBOOK.
I would need to do 2X…2 steps involved, after I assemble all the data into first SHEET of Excel Workbook File.
First, Job Title (extract from large sheet/records, put into new sheet/records) filtered by “title” keywords
Second, Employer, filtering “Employer” names – and DELETING their entire ROW/RECORD from the data
AGAIN:
I will have 100’s or 1,000’s of rows/records of [login to view URL] Job Postings/Listings
FIRST:
Of the 100’s or 1,000s:
I want to EXTRACT entire rows WITH/CONTAINING specific key words in the job titles, like:
Administrator
Client
Customer
Network
Systems
Technology
And more ( I will have/create a list – it will require adjustments/additions )
Get all those records/rows, into another SHEET – different/separate than original (still keep for reference)
SECOND:
Of the records EXTRACTED into the separate SHEET…
Then I want to DELETE entire row(s) with “specific” employer names, such as:
Amazon
Boeing
Oracle
Microsoft
Starbucks
And more ( I will have/create a list – it will require adjustments/additions )
FINALLY
I would then have a SHEET…
With SPECIFIC JOB KEY WORDS/TITLES and no SPECIFIC COMPANIES included (to be deleted)
Can you help?
If yes…
How much time do you need to create the task(s)/order(s)?
AND
How much will you charge?
Nº du projet : #37233554
À propos du projet
65 freelances font une offre moyenne de 41 $ pour ce travail
I am pleased to submit this proposal to provide Excel Macro/VBA data extraction services for you. My expertise in Microsoft Excel and VBA programming uniquely positions me to assist you in streamlining your data extrac Plus
Hi There Nice to know your requirement. I have delivered more than Two Hundred Excel Automation Projects in the past five years. Can discuss and work with you to get this task done. Thank you.
Hello, I'm interested in your project. Your task is clear to me and I am ready to solve it. I have extensive and successful practical experience in processing and analyzing data in Excel, including using formulas and m Plus
Hi, I can develop Excel VBA Macro to extract record according to title and then get employer name and delete an entire row as per your requirements. Macro will find last record dynamically so, you don't need to worry Plus
Hello, I can finish this in a few hours You will have support for all bug fixes and small changes Please contact me if you are interested Thank you, Sorin
Hi, I have gone through the Job details and am interested in taking it up. I need you to share the file with me along with the required changes and I will deliver the required tasks fast and accurately. I’m Ahmed Hassa Plus
Hi there! My name is Anuradha, and I am an expert in Microsoft Excel, Google Sheets, Dashboard Creation, VBA Programming, Power BI with 4+ years of experience in excel projects involving Data management, Excel automate Plus
Hello there! My name is Zafar and I am a top-rated Freelancer with over 5 years of experience in the field of Microsoft Excel, Visual Basic/VBA, Data Entry, Data Processing and more. I can expertly assist you with Plus
Hi, I've checked all the details, very clear and this is a very simple/basic requirement, I will script the macro and deliver it almost the same day and for $20 total. Will be happy to help out.
Hi, I have a few years of experience in programming VBA macros and importing, exporting, sorting, calculating, and manipulating data in Excel, so this makes me the perfect fit for this project. I can create VBA macro t Plus
Hello there! I'm Mohammad from Freelancer.com and I'm excited to help you with your project. I understand that you need help with Excel macros or Visual Basic/VBA to extract rows from data and delete them from remainin Plus
Hello there! I am a clinical research professional and proficient with preparing spreadsheets and automation. I understand that you need help with extracting specific rows from data and deleting rows from remaining Plus
Hi I have read the requirements and understand them. I can assure you that if you work with me once, you will always work with me on these kinds of projects. would you like to discuss the project with me?
I'm excited to offer my freelance services for your Excel project. Your project's success is my priority, and I'm confident I can deliver outstanding results. With 9 years of experience working extensively with Excel, Plus
Hello, I am interested in your project and i can complete it within required time. I have appropriate experience in Microsoft Office Products(Word, Excel, PowerPoint, Visio, Project as well as VBA etc) of more than 10 Plus
Hello there! My name is Shri Ram and I am an experienced professional with 12+ years of web design and development experience. Services: ======== ✅ Mobile App Development (iOS/Android/Hybrid Apps) ✅10+ Years in IT ind Plus
Greetings! I am a certified Data Analyst with a Master's degree in the field and over 5 years of professional experience. My core areas of expertise cover the full scope of Data analysis, including data collection, cl Plus
I am a certified Data Analyst with a Master's degree in the field and over 3years of professional experience. My core areas of expertise cover the full scope of Data analysis, including data collection, cleaning, analy Plus
Sir/Ma’am, With 12 years of government experience in Administrative Assistant in Commission on Audit, Local Government Sector, Philippines. I know that I have the skills and expertise you are looking for the Virtual Plus
