Good day Forum.
Please see if anyone can assist.
Firstly I have this on one worksheet:
A B C D
1 D1001 John Wick Builder 890908399033
2 D1002 Terence Hill Actor 720505690876
I want create a payslip on the next worksheet with the cell reference of employee D1001
Then I want to copy the payslip to cells next to the first one, but it must automatically ad the cell reference of employee D1002 in the relevant cells.
Trust someone can help.
Hi Herman,
Please supply your workbook with the data laid out as you will use it, and as you expect it to look in the end result. Giving you an answer without this makes it more difficult than it needs to be.
Thx
Phil
Hi Herman,
You can do this with a pivot table, then from Pivot Table analyze tab tools in ribbon, choose Options-Show Report Pages.
This action will create a sheet for each ID in the report filter field, see attached example.
Philip.
Thank You for your prompt response.
Herewith the file I am busy with.
Trust it will help.
Regards
