Hi every one
I need a macro to verify if TODAY is between two different Date and if match then copy a Cell from another worksheet and paste in active worksheet and Loop it from I=1 to 100 e.g.
thanks
Hi every one
I need a macro to verify if TODAY is between two different Date and if match then copy a Cell from another worksheet and paste in active worksheet and Loop it from I=1 to 100 e.g.
thanks
Last edited by AliGW; 06-20-2023 at 11:15 AM. Reason: Thread title improved - generic thread titles are NOT permitted.
Hello @s.hme, Like example.
Think further what you need.Please Login or Register to view this content.
@s.hme
Please review our rules on thread titles - yours was generic, so I have changed it. Make sure you meet our requirements in future, please.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Thank you for your kind reply
The DATE required to be inside the loop meaning that the macro required to find that Today is matching with which bi-weekly report.
every two weeks there are new data and the data goes from column n to z e.g. the macro required to bring the date which the DATE is matching with the bi-Weekly report date and bring the data to other sheet.
If I can attach example excel sheet, I will explain more properly.
Thank you and best regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks