Consolidating data on summary sheet based on unique ID

[Evetsthegreat]

Hi,

I have a spreadsheet tracking issues & their action plans.

Sheet 1 has all the issues each with a unique ID.
Sheet 2 has all the action items that each link to an Issue ID

I want to have a consolidated view showing the Issues and their attached action items.

Any idea on how to do this?

Much easier in Access I know, but unfortunately its not available to me and i need something pretty quick and dirty for a short term solution.

I have attached a basic example of how the output should look.

Cheers,

[Marcol]

One way might be to use helper columns.

In both "Action_Plans" & "Issues" insert a column at the begining then in A2

Please Login or Register  to view this content.

Drag/Fill Down
N.B.
If you expect more than 9 actions for any one issue.

Please Login or Register  to view this content.

Copy "Action_Plans" Column A and Paste Special > Values to "Summary" Column A.
Sort this column ascending.

In B2

Please Login or Register  to view this content.

In C2

Please Login or Register  to view this content.

In D2

Please Login or Register  to view this content.

Complete your table with similar lookups adjusting the column ref to your requirements

You can hide the helper columns if you wish.

The summary will need to be manually updated and sorted (Column A only) when your data changes, but you did ask for ......

........ i need something pretty quick and dirty for a short term solution

Hope this helps