Find Jobs
Hire Freelancers

VBA Macro multiple filter 50CAD FIXED PRICE READ CAREFULLY -- 4

$30-250 CAD

Cancelled
Posted about 3 years ago

$30-250 CAD

Paid on delivery
I need macro to do: In the initial sheet with the macro, it has buttons at the top one besides the others. From left to right, buttons: "Import From Folder & Run", "Filter" "Clear Filter" "Help" (where all this info gets into) 1. "Import From Folder & Run" button to be able to choose Import from folder: From the Import Folder location, once clicked Select Folder, Application starts and it Opens each excel sheets in order to copy the data into the main sheet (the sheet with the buttons) (after copy of each sheet close each sheet). The copy is done in the following format: Title of the sheet comes first, second all the data from the sheet and a space at the end so there is a space between the last cell of data and the next sheet. 2. Move all columns starting with B 2 additional columns on the right. 3. Calculate number of words in A and insert on B. 4. Calculate the now J * F and put info on C. 5. Open form with all columns to filter. Form contains fields to enter numbers as filters. Form filter has the title of the column that it filters for and has min and max fields. Ex if want to put Min 50 Max 500. "Submit" button in order to filter by criteria entered. Functions "Import From Folder" chooses the import from folder and runs the application "Filter" is to open form with filter fields "Clear Filter" is to clear the pasted info in the initial sheet "Help" Prompts this document "Submit" on the form field to Submit filters and close form
Project ID: 29855674

About the project

11 proposals
Remote project
Active 3 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
11 freelancers are bidding on average $95 CAD for this job
User Avatar
Hi there VBA macro is my basic skill. I assure you the BEST work as per your requirements. If you hire me, you will be happy with excellent work, high quality and short period. My budget is NEGOTIABLE. Looking forward to hearing from you soon. Sincerely regards
$150 CAD in 7 days
5.0 (18 reviews)
6.0
6.0
User Avatar
Hello, I've read your project requirements thoroughly. It's quite an easy task and I can achieve this through a VBA script. It will be quick and accurate. I will start immediately and complete it within a few hours. If interested, we can discuss this further on chat.
$50 CAD in 1 day
4.5 (24 reviews)
4.9
4.9
User Avatar
I can perfectly help you with that. I am a professional Data Analyst and Excel expert holding years of experience in utilizing advance level tools and functions of Google sheets & Excel (including VBA and Macro) to perform Data Analysis, Data Visualization, Financial Analysis, Financial Modeling and various types of Analysis, Automation and complex calculations. I will be happy to discuss in detail how I am highly suitable for this project. Thanks Jayant
$50 CAD in 2 days
4.9 (19 reviews)
3.9
3.9
User Avatar
Hello, I can design your vba with the functions you request, in fact I have already made a script that performs some of these functions, such as importing and filtering by date and time, contact me to let me know what you need. regards
$45 CAD in 7 days
4.9 (3 reviews)
2.7
2.7
User Avatar
Hello, Please review my profile as I have the relevant skills and experience required for this project. I can start working right now. Kindly send me a message to discuss further for references, portfolio, and case studies. Thanks, Muhammad
$80 CAD in 2 days
5.0 (2 reviews)
0.5
0.5
User Avatar
I am here for doing data entry logo designing web posting i am under graduate student i m here for earning money with loyality i am here for doing any fraud i am a student of commerce section and doing BBA from universtiy
$140 CAD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Demo available.... Hi I have done similar kind of projects earlier and this can be done in short span of time. let's discuss this further and start working on it asap.
$50 CAD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I have extensive experience in VB and VBA, and I can help you with your Excel macro. I look forward to start working on this. I appreciate the thorough information. Regards, Nicolas
$140 CAD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of CANADA
Montreal, Canada
4.8
12
Payment method verified
Member since Dec 6, 2017

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.