My problem:
I have a file (sheet 1) and I want a user to be able to create a new file from the data but which only contains the columns they choose.
More detail included in textbox on sheet 2 of attached file.
So if anyone can help me set up a macro that :
a) initially protects the original file/data in some way then
b) automatically creates a checkbox list on sheet 2 : (some of which are non-selectable eg name, reg group) then
c) asks the user to confirm they wish to save as a new file then
d) allows the user to specify the location and filename of their chosen columns and saves their file without any macros.
Thanks for any help you can give.
Also, if you think there is a better way to do this I'd be happy to hear your suggestions.
Bookmarks