PDA

View Full Version : FindAll on sheet3 then display in sheet1 user form



tx7399
05-20-2015, 04:19 PM
Hi everyone,

From a sheet1 UserForm, how can I find all instances of a user input value that exist in Col A of sheet3?
Then, for each instance of the user input value, display the values that are in columns A thru E of Sheet3 for that row.
Can these ranges (A:E from sheet3 for the rows identified by finding the searched for value in Col A) be displayed in some sort of pop up form from the User Form?

Totally lost; any ideas are much appreciated.

Paul_Hossler
05-20-2015, 04:50 PM
Totally lost

Me too -- you'll have to mock up an example with a lot more detail I'm afraid

tx7399
05-20-2015, 06:21 PM
I'll try to come up with some test data.