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

**suikt** · 10-31-2019, 08:33 AM

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

**Pepe Le Mokko** · 11-01-2019, 04:18 AM

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

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

LinkBack

Thread Tools

Rate This Thread

Display

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

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

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] how to code "if tab name starts with a string, then move these tabs to a new workbook"

"file opener" - code to open another workbook, save as, and close both original files

[SOLVED] vba code to create an "index" page which lists every worksheet in the workbook

How to use named ranges in VBA code using "Columns" and a variation on "Range"

[SOLVED] Add New Sheet,named based on cell value VBA problem and "smoother" code

Create copy of current workbook using vba which has the code in the "thisworkbook" module

[SOLVED] VBA code to create "variable" worksheets within a workbook

Bookmarks

Bookmarks

Posting Permissions