|Thanks for your reply. I really didn't explain it very well, sorry. Let me try again.|
Column A on the current sheet lists document filenames.
The headings along Row 1 of the current sheet (beginning at Column C) are WP references. These are numerically in order, the first few being 121 in C1, 1200 in D1, 1215 in E1, and so on.
In another sheet, called WP Rpt, I have a full report on all associations between WP number (the 121, 1200, 1215, etc) and the filenames they relate to. This means if I sort them by WP, all the filenames with that association will be listed, so there are multiple WP associations to each filename. In Column A, all the WPs are listed. In Column E, all the filenames are listed.
The first sheet will (hopefully) be a concise record of WP associations already applied (indicated by an X) so the users can choose other WPs that may apply, which haven't yet been applied (saving them choosing all of the WP associations every time a new revision comes in).
Does that better explain it?