RohitDangi
New Member
Hi Team,
I have a process which will always be run on every Monday of the month. Before running the 1st time on the 1st monday of the month, we have received a Excel file which have a single worksheet which contains some Vlook up tables.
My requirement is that when it is running on 1st monday of the month it already have the worksheet to work on, but when it is running on 2nd monday and so on..it should create 2nd worksheet which is the copy of the 1st worksheet to work on. same need to done for 3rd monday, 4rth monday. I stuck at the logic of How i get to know which monday is the 1st monday or 2nd or 3rd or 4rth or 5th of the month and according to that i have to create the worksheet and work on that.
I'll be very gratefull if you can help with this.
I have a process which will always be run on every Monday of the month. Before running the 1st time on the 1st monday of the month, we have received a Excel file which have a single worksheet which contains some Vlook up tables.
My requirement is that when it is running on 1st monday of the month it already have the worksheet to work on, but when it is running on 2nd monday and so on..it should create 2nd worksheet which is the copy of the 1st worksheet to work on. same need to done for 3rd monday, 4rth monday. I stuck at the logic of How i get to know which monday is the 1st monday or 2nd or 3rd or 4rth or 5th of the month and according to that i have to create the worksheet and work on that.
I'll be very gratefull if you can help with this.