+ Reply to Thread
Results 1 to 3 of 3

Adding new sheet

  1. 03-07-2014, 10:25 PM #1
    rjayaram.rj is offline
    Registered User
    Join Date
    03-02-2014
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    22

    Exclamation Adding new sheet

    Hello

    Sheet1 contains the data C41:C70
    Sheet2 is the format with different formulas.
    Sheet2 to be copied and renamed based on values in C41:C70 in sheet1.

    Can I get any suggestion.

    Thanks
    Jayaram
    Reply With QuoteRegister To Reply
  2. 03-07-2014, 11:08 PM #2
    Leith Ross is offline
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259

    Re: Adding new sheet

    Hello rjayaram.rj,

    Sheet2 to be copied and renamed based on values in C41:C70 in sheet1.
    That is a lot possible names. What are the naming rules for this new sheet?
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)
    Reply With QuoteRegister To Reply
  3. 03-07-2014, 11:59 PM #3
    rjayaram.rj is offline
    Registered User
    Join Date
    03-02-2014
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    22

    Re: Adding new sheet

    Quote Originally Posted by Leith Ross View Post
    Hello rjayaram.rj,

    That is a lot possible names. What are the naming rules for this new sheet?
    The values in sheet1 C41:C70 contains the EmployeeID say (36204,36696,31745....).
    The sheet2 to be copied with EmployeeID...
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Adding a number to a sheet, then nuber increase by one on each printed sheet
    By Flaverdure in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-24-2012, 06:58 PM
  2. Macro - Copying from sheet 1 to sheet 2 and adding certain cells!
    By gavster89 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-26-2012, 03:23 PM
  3. Searching a phrase across a multi-sheet .xls, then adding the results on final sheet.
    By Agronis in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-22-2009, 11:36 PM
  4. VBA to stop XL from adding the Path Sring to Sheet-to-Sheet Links
    By EagleOne@discussions.microsoft.com in forum Excel General
    Replies: 5
    Last Post: 08-18-2006, 08:50 AM
  5. adding data from one sheet to another sheet as a dropdown list bo.
    By gatorguy in forum Excel General
    Replies: 1
    Last Post: 02-18-2005, 07:06 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1