Dear all,
I have 3 tables, which are in 3 different tabs. (called PM, jobplan, jobtask).
A PM has 1 jobplan and a jobplan can have multiple jobtasks.
This information I would like to show in 1 sheet. (see attachment where this is possible in Access via forms).
I tried already in Excel 2013 the relations in pivot table but this did not work out. The pivot table returns 1 jobplan but all the values available in the table jobtasks, not only the ones relevant for that plan.
I don't mind using VBA, I just would like to work this out in Excel because the customer only works in Excel, not in Access.
Jobplan contains jobtask.png
Kind regards,
Laura
Bookmarks