Results 1 to 2 of 2

Code to create many files named "staff code - name" from many tabs in one workbook

Threaded View

suikt Code to create many files... 10-31-2019, 08:33 AM
Pepe Le Mokko Re: Code to create many files... 11-01-2019, 04:18 AM
  1. 10-31-2019, 08:33 AM #1
    suikt is offline
    Registered User
    Join Date
    03-08-2013
    Location
    Vietnam
    MS-Off Ver
    Excel 2010
    Posts
    9

    Code to create many files named "staff code - name" from many tabs in one workbook

    Hi All,

    Please help to write code to create many files named "staff code - name" (ex: 28195 - A) from the workbook which has many sheets as attached file named "File - Total".

    One staff code may has many transactions in one sheet or many sheets in the File - Total.

    Oops! I cannot post attachment. Any advice?

    Many thanks. Suikt
    Last edited by suikt; 10-31-2019 at 08:40 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] how to code "if tab name starts with a string, then move these tabs to a new workbook"
    By lynnsong986 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-21-2019, 10:55 PM
  2. "file opener" - code to open another workbook, save as, and close both original files
    By Arnold Layne in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-10-2019, 01:08 PM
  3. [SOLVED] vba code to create an "index" page which lists every worksheet in the workbook
    By trenzalore888 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-22-2016, 01:14 PM
  4. How to use named ranges in VBA code using "Columns" and a variation on "Range"
    By haljam in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-17-2014, 02:48 PM
  5. [SOLVED] Add New Sheet,named based on cell value VBA problem and "smoother" code
    By herukuncahyono in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-09-2013, 01:59 AM
  6. Create copy of current workbook using vba which has the code in the "thisworkbook" module
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 05-15-2012, 01:22 PM
  7. [SOLVED] VBA code to create "variable" worksheets within a workbook
    By Chris in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-13-2005, 10:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1