Combine 2 VBA codes in one

[Adile]

Good evening,

I have 2 VBA codes that I use in one worksheet, these codes both refer to something that is transformed into cell A3.
These two codes I want to combine into one code. I also want to change the code so that it works instantly, even when something changes in a cell that
the formula refers to in cell A3. the contents of cell A3 changes by the date of today(). at a certain date, it uploads information from one sheet to another worksheet. but with the codes I have now, he does so only when I adjust cell A3, and then enter or click another cell.

these are the codes;

Please Login or Register  to view this content.

I hope someone caNn help me out.

Adile

[mehmetcik]

Please Login or Register  to view this content.

[Adile]

@mehmetcik

Thank you for combining the codes!

Now that they are combined. can somebody help me out to get the code work instantly instead of entering or click another cell?

Adile

[Indi_Ra]

CrossPost

http://www.ozgrid.com/forum/showthread.php?t=194682