Reporting Using A Drop Down List From A Preconceived Table.
Rate this:
(3/5 from 1 vote)
Thanks for the very quick reply. The PM name is only in one column. I only want the contents of some (6) of the relevant columns. This may result in 4 or 5 rows each with 6 or so columns - I think that is what is throwing me. I have created a drop down list in a cell for the user. The PM name selected in that cell is to drive the selection I have described above. I'm going to try the advice you've kindly given me i.e. filter by name etc. Any other tips gratefully received.