Hi,
I am wanting to know if I can in VBA;
Have a button that when it is clicked;
Searches the name written in a drop down box, the name is then located on another sheet column 1 of "Breakfast" the sheet name of the sheet from which I want the data is located in column 54 of the same page...