Activate the other file depending on the input value from the input button
Posted by pessona on July 25, 2000 8:35 PM
I think my problem here is a bit complicated. I have a sheet in a workbook where in that sheet I have created an input box function to ask for the user to enter the value they want. Then I need to check the value entered by the user with a value in one particular column in every workbook that is in the same directory.
The user has entered the value of 5,
Then i need to take this value and browse through in let say cell C3 in every files to search which cell contains the value of 5. Once found I need to activate the file to be used with the current workbook that is opened.
Hope there will be somebody that can help me.
Many thanks in advance!