UNIC0RN
New Member
- Joined
- Oct 9, 2017
- Messages
- 13
Hi and Good Day...
I have 1 command button that will link to another workbook when clicked. I want to upgrade this command button function not only opens to another workbook but it will automatically search on same value in column J on all worksheet, base on value on E17 in active workbook. If not found then message box show "value not found" Appreciate if anyone can show how can it be done. Hopely not to difficult to understand what I need here. Thanks in advance.
I have 1 command button that will link to another workbook when clicked. I want to upgrade this command button function not only opens to another workbook but it will automatically search on same value in column J on all worksheet, base on value on E17 in active workbook. If not found then message box show "value not found" Appreciate if anyone can show how can it be done. Hopely not to difficult to understand what I need here. Thanks in advance.
