+ Reply to Thread
Results 1 to 2 of 2

VBA move multiple and selected sheets/tabs to new file and copy file as value

  1. #1
    Registered User
    Join Date
    05-17-2012
    Location
    Sydney
    MS-Off Ver
    Excel 2007
    Posts
    15

    VBA move multiple and selected sheets/tabs to new file and copy file as value

    HI All,

    I am trying to do the following using VBA if someone can help me.

    I have ‘FILE 1’ in ‘FOLDER A’.

    I want to copy the whole ‘FILE 1’ and paste it in FOLDER B, and call it ‘FILE 2’ but I want It to be a valued version.

    Then from ‘FILE2’ I want to move ‘Sheet2’ and ‘Sheet4’ in to another file and name it ‘FILE55’.
    Then from ‘File2’ I want to move ‘Sheet5’, ‘Sheet6, and ‘Sheet8’ into another file and anme it ‘FILE66’

    And so on.

    If you can help with the VBA that can do this I will be able to adjust it to how many times ill need to move the sheets around. Thank you very much!

    Remember, I do need a valued version first before moving sheets. I can remane it based on what word is in cell A1 as well would be great. But top part is more important.

    Thank you!!!!!!!!

  2. #2
    Registered User
    Join Date
    11-14-2010
    Location
    Macau
    MS-Off Ver
    Excel 2003
    Posts
    66

    Re: VBA move multiple and selected sheets/tabs to new file and copy file as value

    Please do not you thinking is other one is.
    advice sample file would be assisted.

+ 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. Merging multiple Excel files into tabs of one excel file without having to copy and paste?
    By BrettRCourtney in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-13-2013, 03:43 PM
  2. Replies: 1
    Last Post: 10-04-2012, 08:11 PM
  3. VBA Macro to search for unique ID from one file in multiple sheets of another file
    By Timmo246 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-11-2012, 06:24 AM
  4. Replies: 3
    Last Post: 02-22-2012, 11:40 AM
  5. Save workbook with multiple sheets as csv file and xlsx file
    By excel_vb in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-25-2010, 02:41 PM

Tags for this Thread

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