itsraghus
02-12-2019, 02:42 PM
Hi All,
Hoping you can help I've been searching and searching for the right VBA code for the job but so far haven't found anything. I have limited working knowledge of macros and love using them as it makes my life much easier but as of yet havn't worked out how to write them myself, hence why i need your help.
I have a workbook with around 5 sheets with two columns each. Column A - Name of Test Type and Column B - Definition of Test Type and i want create a search function on the first sheet where i can type in a search criteria in a certain cell e.g. "Test Automation" and press the search button and it will search all the sheets and will give me the definition of this test type.
Thanks in advance!
Hoping you can help I've been searching and searching for the right VBA code for the job but so far haven't found anything. I have limited working knowledge of macros and love using them as it makes my life much easier but as of yet havn't worked out how to write them myself, hence why i need your help.
I have a workbook with around 5 sheets with two columns each. Column A - Name of Test Type and Column B - Definition of Test Type and i want create a search function on the first sheet where i can type in a search criteria in a certain cell e.g. "Test Automation" and press the search button and it will search all the sheets and will give me the definition of this test type.
Thanks in advance!