"Sean" wrote in message
...
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

Yes. See Excel (VBA) Help for "InputBox Method".