I want to run a macro that extracts data from a master spreadsheet into a new
file. This is no problem.
Within the master Spreadsheet(MSS) I have columns b- ca. One column is a
date.
What I want is the extra command that will allow me run the macro that will
allow me to select only a particular date. but I want to be able to select
the date when asked.
can the macro be written so at some stage it comes up with a message what
date do you want to select? and for me to type the date in and enter for the
rest of the macro to continue

Regards

Sean...