copy and paste to a different workbook, change data, then repeat x 7

[vg05]

Hello all. I'm hoping someone can help me write some code for the following commands. I took a stab at it and couldn't quite get it to work. This code is going to be for a command button. I want to copy a range of data into a 2nd workbook, on a specific sheet, into a specific range of cells - then repeat the process after changing a date.

Step one is press the button
Pop up box: "Is the date in B2 set for a Monday?" Yes or No - Yes = continue on / No = end process
Unlock worksheet
Select Range B173:E182
Copy selection
Open Target Workbook
Goto Sheet 14
Paste selection into cells A3:D12 (VALUES ONLY)
Return to original workbook, sheet 1
Select cell B2
Change B2 to its current value + 1 (B2 is a date, and I want to repeat this process for all dates Mon-Fri so if B2 starts at 5/30, the next time around it will be 5/31, and the following time 6/1 etc)

This process, starting with select range B173:E182, would then repeat 4 more times except the "paste selection into cells.." would change each time to E3:H12, I3:L12, M3:P12, Q3:T12

Let me know if there are any questions.

Thanks in advance!

[davesexcel]

Did you have a code you needed help with, what happened when you used the macro recorder?

[vg05]

I kept getting an error, sorry I don't remember exactly what it was. It seemed to be getting stuck on the opening the target workbook if I remember correctly. Also, when pasting it wouldn't do values only.

Im very new to this, I use code snippets from youtube. So I thought it would be easier if I posted exactly what I need so someone could help with doing it in a less convoluted way than I maybe doing it.

[davesexcel]

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[Artik]

Try it

Please Login or Register  to view this content.

Artik