I have a workbook that has multiple copies of the same data entry spreadsheet in different tabs labeled for each month of the year. Basically 12 tabs, each exactly alike just named differently according to the month. Depending on what month it is, the user will select the appropriate sheet and enter data using a userform. There is a button on each sheet at the top that accesses the userform. The code I have is
This code only works for sheet 1, which is named January. How can I modify code to use it on any sheet that I happen to be on and paste the data into that respective sheet. For instance, if I'm on the March sheet and using the Userform to enter data then I want it to paste in the last unused row in March. Right now the userform only works if I'm on the January tab even though it still opens up on all the other tabs. Help would be very appreciated.
Bookmarks