1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Dividing the Excel file

Discussion in 'Business Applications' started by Seroglazka, Jul 26, 2006.

Thread Status:
Not open for further replies.
  1. Seroglazka

    Seroglazka Thread Starter

    Joined:
    Jul 26, 2006
    Messages:
    2
    In an excel macro, i was wondering how to do it:

    You have names of sheets in one of your worksheets per person. It is every name in every cell. Example:

    Name of Person Sheet 1 Sheet2 Sheet3 Sheet4
    Anna USRT President_Boar President Board
    Joe President_Boar President Board
    Peter OPP
    Wallis Systems
    Marts Administration
    Nara Revenue_Process
    Carn HR
    Towe Market_Dev_Total SVP_MkDev General_Contr SE_National


    I want the macro to take that name (above) and look in another file for the exactly name of sheet and create a new file for every person. So every person received a special pages which he/she exactly needs.

    Thank you:confused:
     
  2. OBP

    OBP

    Joined:
    Mar 8, 2005
    Messages:
    19,895
    Can you clarify what is required, you wish to use a name from your worksheet, open another workbook and name a Worksheet with that person's name?
    Then repeat this for other people's names?
     
  3. Seroglazka

    Seroglazka Thread Starter

    Joined:
    Jul 26, 2006
    Messages:
    2
    I want to take names of department from one file.
    Find the same sheets name from another file
    And put these shhets in folder of every person who should have it. Info in first file.

    Thank you
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/486646

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice