Log In
Register
Home
New Member
July 28, 2019
Offline
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.
October 5, 2010
Offline
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
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
November 8, 2013
Offline
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.
1 Guest(s)
