Log In
Register
Home
August 25, 2017
Offline
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
Offline
Hi Melinda
Give this a try.
I have added a helper row to identify the week number (hope it is correct)
Select the required month and then click the copy button
Hope this helps.
Sunny
August 25, 2017
Offline
Sunny
You are the BEST!!! This is way more than I imagined. I love how you simplify excel, which makes it so exciting.
Thank you so very much...
VIP
Trusted Members
June 25, 2016
Offline
Hi Melinda
Thanks for your feedback.
Cheers
Sunny
August 25, 2017
Offline
Sunny
how would I add the actual date for each. For example the first Monday of each week?
Thanks
VIP
Trusted Members
June 25, 2016
Offline
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
Offline
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)
