I've got another idea and would appreciate any assistance.
The userform from which the user would select the stockitem, contains the
full product description in "D2" [absolute reference]
The sheet name might contain whatever name of the specific stockitem
Thus: The item the user selects from the list must contain the sheet name
[whatever that might be].
My question: What is the possibility that the sheet can be identified solely
on the users choice and activate the sheet?
I know you wise guys will be able to help me
Thanks
--
HJN