Find Jobs
Hire Freelancers

I need a VBA/Macro Expert

£20-250 GBP

Completed
Posted over 4 years ago

£20-250 GBP

Paid on delivery
What I need is: An example of a VBA code/Macro that runs based on the column title/name and not the column number. Why do I need this: I am sent raw data on a weekly basis I can create a Macro for the data I need to remain/filter/change order/etc. But the columns where this data is located may change, (one week it could be in column C, the next week it could be column D, etc.) So my macro then will not work because it is referencing the column number. For Example: I need the data in column C and F (columns of data which are names and locations) So I create my Macro in VBA to delete columns A, B, D and E. The Macro then filters column C and F (that remain) and changes the order to ascending. But then the next week the raw data has an extra column of data added, meaning column C and F are now D and G. The Macro I created then does not work. So instead of the Macro looking for Column C and F, it looks for 'Name' and 'Location'. Meaning that no matter where these columns are in the worksheet the Macro will look for these named Columns and delete the rest... all through a Macro. If an example can be created but then explained how it was created and works then I can use this as a template to build my own reports. Hopefully this makes sense? David
Project ID: 20822805

About the project

13 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
hi there... no problem we could right VBA (macro) that perform by 'Name' and 'location' I have rich experience in excel (advanced formulas, VBA, Macro,....), and I do my best to save your time and pocket. Please feel free to contact me. Services: # Accuracy # Customer satisfaction is my first "Priority" # Time Commitment # Availability Thanks, Shahin
£30 GBP in 1 day
5.0 (52 reviews)
5.3
5.3
13 freelancers are bidding on average £73 GBP for this job
User Avatar
Hi, Would you like to see a quick demo of your project on creating or recreating your Excel macro that will run and filter data based on columns; 'Name' and 'Location' completed before you award the project? You can consider it professionally done in less than 24 hrs. I am confident I can exceed your expectations since I am accustomed to doing this sort of job on a regular basis. I am highly skilled in the following areas: 1. Excel 2. Data Entry 3. Excel Macro 4. Data Processing 5. Visual Basic for Apps I am passionate about flawless results and I can assure you of a job well done. I’d love to discuss more on what would make this project a success for you. Can we have a quick chat? Thanks for your time.
£150 GBP in 3 days
4.9 (55 reviews)
6.5
6.5
User Avatar
VERY EASY FOR ME, I can do it within 30m Hi, Nice to meet you. When it comes to Excel, Google Sheet, VBA, I am an expert Please see product I made recently using VBA and C#, python, java, excel management https://www.freelancer.com/projects/excel/need-calculate-KPI-scoring-matrix/?w=f https://www.freelancer.com/projects/excel/Excel-Macro-pull-data-from/?w=f https://www.freelancer.com/projects/excel/Excel-VBA-Time-Series-Decomposition-20459676/?w=f https://www.freelancer.com/projects/excel/Build-appraisal-record-card/?w=f https://www.freelancer.com/projects/visual-basic-for-applications/Connect-Word-Userform/?w=f https://www.freelancer.com/projects/excel/Need-HELP-this-excel-form/?w=f https://www.freelancer.com/projects/php/create-outlook-add-rule-shortcut/?w=f https://www.freelancer.com/projects/data-entry/add-excel-table-rows-outlook/?w=f https://www.freelancer.com/projects/excel/Convert-Text-file-XML-file/?w=f https://www.freelancer.com/projects/data-entry/excel-expert-19406573/?w=f https://www.freelancer.com/projects/excel/Compare-CSV/?w=f https://www.freelancer.com/projects/excel/ascii-excel-converter/?w=f https://www.freelancer.com/projects/software-architecture/Excel-xml-file-online-wizard/?w=f https://www.freelancer.com/projects/software-architecture/Combination-creator/?w=f I have a lots of experiences in Excel, Access and VBA programming After complete project, I can support fixing bugs with free. and support update features with low price. Thanks
£50 GBP in 1 day
5.0 (58 reviews)
6.2
6.2
User Avatar
I am good at Excel formula and VBA/Macro, I need to see the data so I can understand your requirement, I have a few question to discuss so I need you to send a message on chat.
£80 GBP in 4 days
4.7 (80 reviews)
6.3
6.3
User Avatar
I can create a template file in which columns name provided by you will be searched in all sheets and when found, all other columns will be deleted except those columns you want to keep. Please find below a brief introduction of myself. I am postgraduate with more than 5 years of experience in advanced excel based tools, VBA automation, google scripting and data processing. I have successfully completed similar projects, please have a look at my portfolio for details. I have developed excel based automation tools for Ernst and Young also. You can get your work done here with highest quality at lowest price. Looking forward to work with you
£40 GBP in 1 day
4.9 (40 reviews)
5.6
5.6
User Avatar
Hello, I've read your project requirements thoroughly. It's quite an easy task and I have already created what you're asking. If interested, we can discuss this further on chat.
£60 GBP in 1 day
4.9 (13 reviews)
4.2
4.2
User Avatar
I'm VBA Expert!!! Hi. How are you? I read your description carefully and am very interesting in your project. I can start right now and can help you. If you hire me,i will do my best for your job and you can get the best results. Looking forward to hearing from you. Thanks.
£135 GBP in 7 days
4.8 (11 reviews)
4.2
4.2
User Avatar
Hello, I have read the details of the project and I will complete the VBA/Macro perfectly with my 6+ years experience in it. Kindly check my profile https://www.freelancer.com/u/mzdesmag to see my past works and reviews. thanks
£35 GBP in 1 day
4.9 (5 reviews)
3.9
3.9
User Avatar
I have hands-on experience working with VBA. I built several macros to automate daily/weekly projects at my workplace. I got your problem and I can work on resolving this. Please let me know how can we proceed further
£135 GBP in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have three years of experience in web development I have worked as senior php developer in software development company.i have made many wordpress and codiegniter website.I have develop many websites, online store, scrappers, MIS etc etc. Basically I have high command on PHP language.. Also I have very much expertise in customizing theme of many themeforest wordpress theme and other CMS frameworks. for examples of my previous work please inbox thanks
£77 GBP in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I have 7 yrs experience in VBA macros and automation I will provide you the quality output. also I have experience in web scrapping using VBA
£111 GBP in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I think I understand the problem. If you can use for loop in VBA and check for the column name(Assuming A1,B1,....Z1 are the column name ) which contains the exact name and location as values you can solve this problem. I have done many Process Improvement using VBA Macros. You can contact me for this and I can give you a solution in a day. I can make this for free if u wish. I am new to free lancing so dont judge me based of my profile
£20 GBP in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
Chatham, United Kingdom
5.0
1
Payment method verified
Member since Aug 16, 2019

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.