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 of lists of there staff.
Currently I have managed to pull the different reports for all and complete a macro to split them by column and the macro splits them into individual tabs. I then have to copy the managers information from the 3 worksheets into individual tabs in the different workbooks for managers.
Ideally I would like to use macros to create individual managers spreadsheets the have the three tabs and there information from the main reports for appraisals, sickness and training.
I hope this makes sense and someone will be able help. Sorry I have some it skills but this new function to be.
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 of lists of there staff.
Currently I have managed to pull the different reports for all and complete a macro to split them by column and the macro splits them into individual tabs. I then have to copy the managers information from the 3 worksheets into individual tabs in the different workbooks for managers.
Ideally I would like to use macros to create individual managers spreadsheets the have the three tabs and there information from the main reports for appraisals, sickness and training.
I hope this makes sense and someone will be able help. Sorry I have some it skills but this new function to be.