+ Reply to Thread
Results 1 to 7 of 7

New worksheet and auto tab help needed

  1. #1
    Registered User
    Join Date
    08-24-2009
    Location
    Californa
    MS-Off Ver
    Excel 2003
    Posts
    4

    New worksheet and auto tab help needed

    I am trying to make a macro that will take information i highlight, then make a new worksheet and copy the information there and name the worksheet based on information in cell A1 i need it to be able to do this about 180 times. if some one can show me how to do this i would greatly apreaciate it very much!
    (its excel 2003 if that matters)

    updated in my reply!



    Ok on the 1st page for the charts i have a highlighted area, and on the page titled sheet 1 is where i want the data to go if i had highlighted an area and hit a command i want it to open a page like on sheet one and then name the page based on c-4's content
    Attached Files Attached Files
    Last edited by Jazko123; 08-24-2009 at 03:49 PM. Reason: update

  2. #2
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: New worksheet and auto tab help needed

    Welcome to the forum.

    Mockup a sample workbook showing the data, show how data is being selected to be copied, and show your desired results, point out where the results came from if not obvious in your sample data.

    Then click GO ADVANCED and use the paperclip icon to post up your workbook.

    (Version does matter, so that's good to know.)
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  3. #3
    Registered User
    Join Date
    08-24-2009
    Location
    Californa
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: New worksheet and auto tab help needed

    .sorry posted in the worng area
    Attached Files Attached Files
    Last edited by Jazko123; 08-24-2009 at 03:50 PM.

  4. #4
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: New worksheet and auto tab help needed

    Perhaps this:
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    08-24-2009
    Location
    Californa
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: New worksheet and auto tab help needed

    Quote Originally Posted by JBeaucaire View Post
    Perhaps this:
    Please Login or Register  to view this content.
    yes that works but how can i make it so every time i enter new information and highlight it, it takes that information and puts it on a new page then titles the tab with the information in c4

  6. #6
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: New worksheet and auto tab help needed

    Enter new information where?
    Highlight information how?
    On a new blank sheet? Fill out a template? What?

  7. #7
    Registered User
    Join Date
    08-24-2009
    Location
    Californa
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: New worksheet and auto tab help needed

    Quote Originally Posted by JBeaucaire View Post
    Enter new information where?
    Highlight information how?
    On a new blank sheet? Fill out a template? What?
    i want to be able to highlight the area displayed on the charts area and have excel take that information and copy it to a new page with a set up macro key i.e. alt+q or something then name that new tab with that is in c4 and be able to do this many times

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1