I am a beginner at this so sorry for my ignorance.
I'm trying to make a macro that searches an Excel Spread sheet. I plan on using Data validation in cell A1 that the user selects the value they want to see, then I want them to be able to click a button roughly in cell A2 that will initiate the search through that worksheet only. I know how to make the butotn and assign a macro to it, I don't know how to make the macro search off of a value in a cell. The search just needs to take them to the specified location in the worksheet.
I do not know if this will be a difficult task, but all of my searching of google turned up nothing. Any help would be greatly appreciated.