Results 1 to 4 of 4
  1. #1
    Member
    Join Date
    Feb 2005
    Location
    Palmerston North
    Posts
    108

    Default Creating Multiple Files in Excel

    I have a need to create a numerical sequence of files based on a Master Spreadsheet file.

    Is there an easy way to do this other than one at a time?

    TFYH

    Graham Bockett

  2. #2
    Senior Member
    Join Date
    Dec 2004
    Location
    Wellington, NZ
    Posts
    353

    Default Re: Creating Multiple Files in Excel

    Yes thats possible Graham with VBA code which I could write for you if you want. What data is being written to the files or are you meaning to make multiple copies of an Excel file but just with lots of different names?

    regards,
    Graham

  3. #3
    Member
    Join Date
    Feb 2005
    Location
    Palmerston North
    Posts
    108

    Default Re: Creating Multiple Files in Excel

    Hi Parry

    I have written a file in Excel which I plan to use as a Job Sheet. Each sheet needs to be sequentially numbered, either literally, or as a YearMonthNumber system (0610001,0610002, etc).Part of the sheet will include a LOOKUP formula back to a separate spreadsheet file.

    Because more than one person will be accessing the Job Sheets on a network, they need to be separate files rather than multiply sheets within a file.

    Will certainly appreciate your assistance.

    If you wish to send a file directly, please email to graham@chl.co.nz

    Regards

    GrahamB

  4. #4
    Senior Member
    Join Date
    Dec 2004
    Location
    Wellington, NZ
    Posts
    353

    Default Re: Creating Multiple Files in Excel

    Quote Originally Posted by GrahamB View Post
    Hi Parry

    I have written a file in Excel which I plan to use as a Job Sheet. Each sheet needs to be sequentially numbered, either literally, or as a YearMonthNumber system (0610001,0610002, etc).Part of the sheet will include a LOOKUP formula back to a separate spreadsheet file.

    Because more than one person will be accessing the Job Sheets on a network, they need to be separate files rather than multiply sheets within a file.

    Will certainly appreciate your assistance.

    If you wish to send a file directly, please email to graham@chl.co.nz

    Regards

    GrahamB
    Hi Graham, it shouldnt be too hard to do for you. The nature of code is that you need to be specific about what actions you take so while I could create an example and send it to you it would have to be adapted to suit your layout. Im not sure if you know any VBA so its best if you send your file to me with instructions on which sheet you want to use as the job sheet and where the number should go. If it contains sensitive info like names and addresses then just type in dummy values. My email is parryishere@yahoo.com.au

    regards,
    Graham

Similar Threads

  1. Error creating DVD from Avi files
    By Unimatrix013 in forum PressF1
    Replies: 3
    Last Post: 26-02-2007, 10:00 AM
  2. Help needed on creating more secure files
    By dreisawi in forum PressF1
    Replies: 1
    Last Post: 12-11-2006, 07:03 PM
  3. excel opens multiple files
    By in forum PressF1
    Replies: 4
    Last Post: 14-03-2002, 10:50 AM
  4. Replies: 2
    Last Post: 12-03-2002, 05:21 PM
  5. Replies: 3
    Last Post: 08-10-2001, 06:57 PM

Posting Permissions

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