+ Reply to Thread
Results 1 to 3 of 3

Plotting the brand

  1. #1
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    2016
    Posts
    3,628

    Plotting the brand

    Hi All,

    Here I am attaching a excel explanation for plotting the brand from a text string.

    Regards,
    Ankur Shukla
    Attached Files Attached Files
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)

  2. #2
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    Excel 2007
    Posts
    4,769

    Re: Plotting the brand

    Although I have 1 remark. Why not make Brand_List a dynamic range instead of a fixed one so you can add or delete brands freely without having to append formula in NameList every time.
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

  3. #3
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    2016
    Posts
    3,628

    Re: Plotting the brand

    Quote Originally Posted by bakerman2 View Post
    Although I have 1 remark. Why not make Brand_List a dynamic range instead of a fixed one so you can add or delete brands freely without having to append formula in NameList every time.
    Yes it is good idea I will add this too in this file.

    Thank you for consideration it

+ 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