Results 1 to 5 of 5

Create Check List to Delete Columns and Create New File

Threaded View

  1. #1
    Registered User
    Join Date
    05-26-2011
    Location
    Cornwall, England
    MS-Off Ver
    Excel for Mac Office 365
    Posts
    27

    Question Create Check List to Delete Columns and Create New File

    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.
    Attached Files Attached Files
    Last edited by margetc; 07-25-2011 at 07:05 PM. Reason: forgot attachment

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1