ExcelBanter - Report Function

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Report Function (https://www.excelbanter.com/excel-worksheet-functions/196503-report-function.html)

I have a report and I have a table with Names, when I run the report I want
the user to select a name to print from on the report in a field that I set.
How would I go about setting this up. Thanks for your help.

Something that is easy to do, is make a list to pick from, using Data
Validation List. That list 'd contain the names to choose from.

In your report (either with VBA-code or without) you can reference that
particular cell and generate the report.

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music

"Anthony" wrote:

I have a report and I have a table with Names, when I run the report I want
the user to select a name to print from on the report in a field that I set.
How would I go about setting this up. Thanks for your help.