VBA, Macro changes

Closed

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

Skills: Visual Basic for Apps

See more: starting with visual basic, me vba, macro vba, B2, stop visual basic macro, macro vba cell, copy paste macro vba, vba sheet, data vba, attached vba, macro changes cell, macro copy cell contents paste, visual basic applications 2013, macro add, vba match, copy vba, match macro, match paste data, copy paste macro, match data macro, range macro, macro copy paste, can copy cell contents macro, vba copy paste data, visual basic macro

Project ID: #4145269

Awarded to:

paintthesky14

Hi, Thanks for explaining the requirements so clearly. Your macro is ready with me. Please check your PM.

$40 USD in 1 day
(4 Reviews)
2.7

14 freelancers are bidding on average $48 for this job

slavisatosic

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
(47 Reviews)
4.9
Rahul2012

I am VBA expert.

$70 USD in 1 day
(1 Review)
4.0
danielgpratidya

Hi, I am sure you'll get the best codes from me to work on your spreadsheet

$55 USD in 1 day
(6 Reviews)
3.9
excel4engineers

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
(10 Reviews)
2.9
adim

Top 1% in VB6 on Freelancer and lot of experience in this field, please check PM.

$56 USD in 1 day
(2 Reviews)
2.9
manishadk

Very Easy Job For Me. Please Check PMB For Details.

$30 USD in 1 day
(3 Reviews)
2.5
microk

Expert Here.. Please check PM...

$45 USD in 2 days
(1 Review)
2.3
vikashgadia

we are excel vba expert

$55 USD in 1 day
(1 Review)
0.4
LDSkils

I can do this very quickly. thank you

$30 USD in 1 day
(0 Reviews)
0.0
jerrySq

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 Reviews)
0.0
winbond

Hi, your job is done. more detail in PM

$30 USD in 0 days
(0 Reviews)
0.0
benefitworks

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 Reviews)
0.0
Conderella

Plz check PM.

$70 USD in 2 days
(0 Reviews)
0.0
tmihos

2 macros, 2nd calling 1st

$30 USD in 3 days
(0 Reviews)
0.0