Good Morning. I'm looking for some help with VBA. I am still learning this, and I have done copy and pasting with it, but I cant seem to get this to work.
On the attached workbook I am only concerned with 2 sheets. "Dynamic Calc" and "OTIF"
On the Dynamic Calc sheet, Cell B2 is going to change monthly. So while it currently shows May-22, next month it will show June-22 when I run my reports.
What I want to do is click my command button and have the VALUES only from B4:B122 copy and paste to the OTIF sheet in the same range 4:122 based on the month value in row 2.
So when I push the button now, it should copy Dynamic Calc B4:B122 to and paste the values to OTIF B4:B122 because 'Dynamic Calc B2' is the same as 'OTIF B2'
However, next month when I change 'Dynamic Calc B2' to "June-22" Then when I press the button the values should paste into "OTIF C4:C122" and so on each month.
Bookmarks