Results 1 to 5 of 5
  1. #1
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Auto create with similar names! (Excel 2000>)

    Using Name | Create is great to assign auto names to ranges of cells. But it can't be used if products (say for a different region, or quarter) are captured on the same sheet. When I use the create command on the second block of data, it informs me that range names will be replaced.

    Is the a way to automatically name similar ranges eg.. Prod1, Prod2, Prod3... if the names are identical? Any suggestions before I start searching or wasting time with a macro or something!

    Thanx
    Regards,
    Rudi

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Auto create with similar names! (Excel 2000>)

    I don't think there is a built-in method to do this. You could perhaps create a macro for it, but I don't have code at hand.

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Auto create with similar names! (Excel 2000>)

    Thanx for the reply Hans. I will let this post hang around and see if anyone has some shortcut for me. If not, I guess I'll need to dabble into VBA and see what I can build!
    Regards,
    Rudi

  4. #4
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Auto create with similar names! (Excel 2000>)

    Maybe just use the first table and then use my Name Manager's List/pickup feature to quickly create indexed "copies" of the names?
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  5. #5
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Auto create with similar names! (Excel 2000>)

    Pieterse, I'll give that a try. I'll post back if I get stuck!
    Thanks
    Regards,
    Rudi

Posting Permissions

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