Find Jobs
Hire Freelancers

VBA, Macro changes

$30-250 USD

In Progress
Posted over 11 years ago

$30-250 USD

Paid on delivery
The attached sheet contains a macro, I want the macro to perform as it currently does, but with the following additions. Below are the steps I want the macro to run through. (1) Add 1 day to the Working Date in cell B2 (2) Delete the contents of cells A22:E37 (3) Range Data Source:- Copy all rows that match the date in Working Date cell B2 (copy the date and the next four columns), Paste to cells starting at A22. (4) If no cells matched the Working Date in B2, then go to step (1) and repeat, however if some cells matched B2, go to step (5) (5) Run the existing macro (6) After the existing macro add VBA to repeat the above starting with (1), repeat, The cycle should stop, preferably when it gets to today´s date, or if it stops when it has copied everything across, or if I can set it to run Xamount of times. I would like some notation to allow me to understand the macro and where I might tweak it in the future. I hope this is clear, if not please don´t hesitate to ask
Project ID: 4145269

About the project

14 proposals
Remote project
Active 11 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, Thanks for explaining the requirements so clearly. Your macro is ready with me. Please check your PM.
$40 USD in 1 day
5.0 (4 reviews)
2.7
2.7
14 freelancers are bidding on average $48 USD for this job
User Avatar
Hello, I am offering you to make this project in one or two working days, depending of the complexity of the worksheet. Please see PM for details
$60 USD in 2 days
5.0 (47 reviews)
4.9
4.9
User Avatar
I am VBA expert.
$70 USD in 1 day
5.0 (1 review)
4.0
4.0
User Avatar
Hi, I am sure you'll get the best codes from me to work on your spreadsheet
$55 USD in 1 day
5.0 (6 reviews)
3.9
3.9
User Avatar
Thanks for your detailed instructions. I can do it to day. I can start now. Please, send my the file.
$30 USD in 1 day
4.9 (10 reviews)
2.9
2.9
User Avatar
Top 1% in VB6 on Freelancer and lot of experience in this field, please check PM.
$56 USD in 1 day
5.0 (2 reviews)
2.9
2.9
User Avatar
Very Easy Job For Me. Please Check PMB For Details.
$30 USD in 1 day
4.6 (3 reviews)
2.5
2.5
User Avatar
Expert Here.. Please check PM...
$45 USD in 2 days
4.0 (1 review)
2.3
2.3
User Avatar
we are excel vba expert
$55 USD in 1 day
5.0 (1 review)
0.4
0.4
User Avatar
Plz check PM.
$70 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Greetings!!! I just bid for just 30USD. Payment only after work is completed for your satisfaction. Just let me know your acceptance. Regards Benefit Works
$30 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, your job is done. more detail in PM
$30 USD in 0 day
0.0 (0 reviews)
0.0
0.0
User Avatar
2 macros, 2nd calling 1st
$30 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I can do this very quickly. thank you
$30 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I have extensive experience programming Macros and VBA in the entire Microsoft office suite. Before a proper bid could be made I would need to see the existing sheet with the current Macro.
$75 USD in 4 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
Los Barrios, United Kingdom
3.9
8
Payment method verified
Member since Jan 15, 2013

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.