+ Reply to Thread
Results 1 to 6 of 6

VBA Code to Move and/or Copy Sheets out to a New Workbook based on Cell Values

  1. #1
    Registered User
    Join Date
    08-25-2014
    Location
    New York, New York
    MS-Off Ver
    Excel 2013
    Posts
    36

    VBA Code to Move and/or Copy Sheets out to a New Workbook based on Cell Values

    I have a Main Workbook with multiple worksheets. After certain cells are completed on the "Set-Up" worksheet, I would like to do the following: (A) automatically move out three (3) different sheets to new individual workbooks and save them in a specific location, (B) Copy five (5) sheets to a new workbook and save them in a specific location and then delete only three (3) of them from the original workbook, (C)
    __________

    (A) The first three workbooks are named "Doc List", "Quals", "RFI Log". I would like for these to be moved, saved to individual workbooks and deleted from the Main Workbook.

    I would like to create a VBA that allows me to create a checkbox on the Set-Up Tab of the Main Workbook that the user can click on to move each of these files out of the Main Workbook only if cells C6, C7 and C10 are not blank.

    I would like an individual checkbox for each of the three (3) tabs.

    I would like the like the files to be saved with the following name on the user's desktop (C:/):
    (1) Doc List
    (2) Assumptions and Qualifications
    (3) Turner Precon RFI Log - Current

    ______________

    (B) The next five workbooks are named "DO NOT EDIT or DELETE", "BID LIST - To be Copied", "Gen. Project Info", "Trade Scope", "Scopesheet". I would like for these to be copied, saved to one workbook and then delete only the sheets named "Gen. Project Info", "Trade Scope", "Scopesheet" from the Main Workbook.

    I would like to create a VBA that allows me to create a checkbox on the Set-Up Tab of the Main Workbook that the user can click on to perfom the action above only if cells C6, C7, C10, C12, C13, C15, C16, C17, C18, C21, C44, C46, C50, C51, C52, C53, C59, C110 are not blank.

    I would like an single checkbox for this action.

    I would like the like the files to be saved with the following name on the user's desktop (C:/):
    (1) Scopesheet - Template

    Please help!

  2. #2
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: VBA Code to Move and/or Copy Sheets out to a New Workbook based on Cell Values

    There are lots of articles on this on this site, someone asks each week. Have a search on the forum 1st.

    HTH
    Hope this helps

    Sometimes its best to start at the beginning and learn VBA & Excel.

    Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
    Available for remote consultancy work PM me

  3. #3
    Registered User
    Join Date
    08-25-2014
    Location
    New York, New York
    MS-Off Ver
    Excel 2013
    Posts
    36

    Re: VBA Code to Move and/or Copy Sheets out to a New Workbook based on Cell Values

    Can you direct me to the forum? I searched and cannot find anything that is close to what I am asking for.

  4. #4
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: VBA Code to Move and/or Copy Sheets out to a New Workbook based on Cell Values

    There was one yesterday, it wont be identical to yours, but will assist, this is a common post, and you are in the forum.

    If you hang on someone may do it for you.

  5. #5
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: VBA Code to Move and/or Copy Sheets out to a New Workbook based on Cell Values

    http://www.excelforum.com/excel-prog...-criteria.html

    just did a search, lots similar.....

    Cheers

  6. #6
    Registered User
    Join Date
    08-25-2014
    Location
    New York, New York
    MS-Off Ver
    Excel 2013
    Posts
    36

    Re: VBA Code to Move and/or Copy Sheets out to a New Workbook based on Cell Values

    Thanks for the search - however I am looking to move entire sheets out of a workbook and save in a new workbook. All the posts below are related to moving data between sheets. Do you have any other suggestions? I am pretty new to writting code and new some help.

  7. #7
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: VBA Code to Move and/or Copy Sheets out to a New Workbook based on Cell Values

    Well, i know that move or copy is on right click of the tabs, so i'd start be having a go myself at recording that action, copy to another workbook

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Vba code to copy/move 12 sheets to master sheets
    By tieyanna in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-25-2014, 08:32 PM
  2. Vba code to copy/move 12 sheets to master sheets
    By tieyanna in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 06-24-2014, 11:16 PM
  3. Save a copy of the workbook including only sheets with values in a certain cell
    By Melisendk in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-11-2013, 08:47 AM
  4. Replies: 4
    Last Post: 09-15-2012, 02:18 PM
  5. [SOLVED] copy/move sheets within workbook
    By Roger B. in forum Excel General
    Replies: 1
    Last Post: 05-05-2005, 01:06 PM

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