

August 25, 2017

Can someone help? I would like to copy a range from one worksheet to another worksheet, but I would like to copy based on the criteria. For example, I would like for it to copy the 2nd week of each month. Do I have to enter a line of code for each month or is there another way to get the info. Is there a condition to for example to ask for the 2nd, week of the month. I will create another sheet with a different macro to capture the 3rd week of the month.
Thanks

VIP

Trusted Members

June 25, 2016


VIP

Trusted Members

June 25, 2016


VIP

Trusted Members

June 25, 2016

Just enter a date into cell D2 which correspond to the 1st Monday of January. In my earlier attached file, 1/1/2018 happens to be a Monday.
All the other dates will auto change to Monday. You can test this by entering =TEXT(D2,"ddd") in cell D3 and copy across the row.
All these cells will show Mon (Monday).
Hope this helps.
Sunny


August 25, 2017

Sunny
Let me see if I can do a better job of explaining. On Sheet1 the dates are listed on Row 2 beginning with D2. I would like the dates to show on Sheet2 on Row 3. For example, when the "Select Week Number" is "1", the dates should show 1/1/2018, 2/5/2018, 3/5/2018, and etc. When the "Select Week Number" is "2", the dates are 1/8/2018, 2/12/2018, 3/12/2018, and etc. I hope this helps.
1 Guest(s)
