#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 275
Default Report Function

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.

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 396
Default Report Function

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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
If Function on calendar, expense report. Paula Excel Worksheet Functions 0 June 18th 08 09:13 PM
Getting missing data from one report into another report... vlookupabyss Excel Discussion (Misc queries) 3 January 8th 08 03:26 PM
Report function? plunk25 Excel Worksheet Functions 1 October 13th 06 05:34 PM
Automate Excel report to place certain data into existing report? Craig Harrison Excel Worksheet Functions 3 July 25th 06 01:54 PM
can you use a function to recalc a pivot table report RickB Excel Worksheet Functions 1 January 2nd 05 06:54 PM


All times are GMT +1. The time now is 11:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"