Hi All
I would really appreciate your help. I would like to create a manager workbook for individual managers which include different tabs for appraisals, training and sickness.
I have managed to pull the different reports for all and complete a macro split them into by column into individual tabs. I am currently having to copy the information from the spreadsheets into individual tabs in separate workbooks.
Ideally I would to create individual spreadsheets for each manager by using a macro with the spreadsheet including three tabs with their appraisal, sickness and training.
I hope this makes sense and some will be able help
I would really appreciate your help. I would like to create a manager workbook for individual managers which include different tabs for appraisals, training and sickness.
I have managed to pull the different reports for all and complete a macro split them into by column into individual tabs. I am currently having to copy the information from the spreadsheets into individual tabs in separate workbooks.
Ideally I would to create individual spreadsheets for each manager by using a macro with the spreadsheet including three tabs with their appraisal, sickness and training.
I hope this makes sense and some will be able help