Hi
I am trying to create an input box that will search for a number that is manually entered by a user. When the number is entered into the input box it will then search in Column "A" of both sheets which are named "OPEN 84" & "CLOSED 84" . When the value is found it will copy the complete row to a sheet named "OUTPUT". The number the user will enter is a unique number ( around 8 digits ) and will not return multiple values to copy. Both sheets will have approx 10-15000 rows of data.
Thanks miff3436
I am trying to create an input box that will search for a number that is manually entered by a user. When the number is entered into the input box it will then search in Column "A" of both sheets which are named "OPEN 84" & "CLOSED 84" . When the value is found it will copy the complete row to a sheet named "OUTPUT". The number the user will enter is a unique number ( around 8 digits ) and will not return multiple values to copy. Both sheets will have approx 10-15000 rows of data.
Thanks miff3436