I have never done any VBA programming in Excel and would like to do the following:-
I have a spreadsheet with 4 columns. Stock_Code, Description, Qty in Stock, Location
I would like to have a button on the toolbar, which when pressed will bring up a dialogue box to allow the user to input a Stock_Code. On entry the sheet would filter to only show the rows contaning this Stock_Code. I would also need to be able to turn this filter off. Posibbly another button with Show All Records.
Where do I start?