This is my first time trying to write a macro and I am having a lot of trouble with it. I could really use some help writing this code properly.
I am trying to create a search field that will search multiple worksheets and bring that data back to a range of cells. The customer will put in a product into cell B1, hit enter, and the results will be displayed starting at cell B2. It needs to search column A on 6 different worksheets.
Please help if you can! Thank you!
I am trying to create a search field that will search multiple worksheets and bring that data back to a range of cells. The customer will put in a product into cell B1, hit enter, and the results will be displayed starting at cell B2. It needs to search column A on 6 different worksheets.
Please help if you can! Thank you!