PDA

View Full Version : display worksheet data in user form



tommy1234
08-06-2012, 03:52 AM
hello
i have a worksheet with a pivot table called "analysis"
i want that the user will be able to press on a command button on another worksheet called "user" and a popup userform will show on screen and will display the data (4 columns from worksheet "analysis") on the userform

thanks

Rob342
08-06-2012, 01:02 PM
Tommy

I think you need to be more specific, perhaps a copy of the WB

tommy1234
08-16-2012, 03:51 AM
Hello
i attached an excel file with 2 worksheets.
refer to worksheet "Pivot",
i want that when the user choose to filter a project manager name on report filter a popup form will show and display the data shown on the pivot table :
project cod and project name in some kind table (grid view will be the best)

thank you