I have a workbook with 5 worksheets. I need vba code to select a specific sheet based on text entered in Sheet1(Register), Column J14:J40 of a table. Column J14:J40 contains a drop down list with the names of the worksheet tabs. I need to complete, either Sheet5 (PP-Pearson) or Sheet6 (HC-HeatCare) and populate the data from the last row of data entered in Sheet1(Register) to the appropriate cells in whichever sheet is selected and then print 2 copies. I have searched the internet, but I not found exactly what need.
New to VBA and really need help to complete this for my office.
Thanks
New to VBA and really need help to complete this for my office.
Thanks