I have a spreadsheet with columns A - N populated, at the moment there are 89
rows of data text and numeric. The number of rows can change if new items are
added.

I would like to be able to select Col A and then another column of the users
choice, copy the data to a new worksheet, keeping the original format. so eg
col A and Col F need to be copied into new w/b in Col A and Col B. Even
better if I could use the heading from Col B to Col N for the user to select
instead of Col F

I would then like the user ID, date and time to be entered into C1, the name
of a customer in C2 ( could this be entered via an input box) and then the
command file save as appear, so that the user can save the file.

Any ideas?

Thanks

Winnie