I'm using a project to help me learn VBA. I was searching Google for answers and came upon this forum... fantastic! This is my first post.
The topic I'm focusing on today is copying a range from the current, active sheet to a new sheet, with a date entered on a user-form as the sheet's name. Hopefully the attached image will explain more. It's a little more complicated than some of my other "lessons," so I thought I'd try to get some help.
The project is a yearly preventative maintenance worksheet. The equipment specifics remain the same from year to year, but the measured data will be different. So after entering in the date of the PM (ie, 2020-03-15) a the current, active sheet (specific column range, ie. A thru J) is copied to a new sheet, which is given the date-name entered in the user form text field. All of my Command buttons on the top of the page would need to be copied as well, since they activate forms to edit each record ("get" and "let").
Any thoughts on how to accomplish this?