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.

Excel 2010 help! Importing data from anotehr sheet

Discussion in 'Business Applications' started by racng69, Jan 9, 2013.

Thread Status:
Not open for further replies.
Advertisement
  1. racng69

    racng69 Thread Starter

    Joined:
    Aug 15, 2010
    Messages:
    4
    Hello All,

    Im in need of some help. If you look at the attachment. Im trying to take the names and corresponding data from "Sheet4" and add that data to the other sheets. Each sheet would be an attendance card for each person. So is there a quick way to add 120 tabs at the bottom of the file? And i wanted to put their name as the tab name on the bottom. Can anyone help me with this?
     

    Attached Files:

  2. Garf13LD

    Garf13LD

    Joined:
    Apr 17, 2012
    Messages:
    455
    Done.
    Sheets are not sorted though.
    Sheet4 and Calendar have to stay. If you intend to rename it, you have to change it in macro as well.
    Calendar will be the "master" sheet for all new copy.
     

    Attached Files:

  3. racng69

    racng69 Thread Starter

    Joined:
    Aug 15, 2010
    Messages:
    4
    Thanks. How can i get 120 tabs at the bottom with each name on each card? in the designated area?
     
  4. racng69

    racng69 Thread Starter

    Joined:
    Aug 15, 2010
    Messages:
    4
    did i loose ya?
     
  5. Garf13LD

    Garf13LD

    Joined:
    Apr 17, 2012
    Messages:
    455
    Go to view > Macros, then run the macro inside.
     
  6. Sponsor

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/1084473

  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