+ Reply to Thread
Results 1 to 5 of 5

Keeping Master List updated and in Alphabetical order.

Hybrid View

  1. #1
    Registered User
    Join Date
    12-22-2014
    Location
    Brookvale NSW Australia
    MS-Off Ver
    2013
    Posts
    1

    Keeping Master List updated and in Alphabetical order.

    Hi all!
    I work in a T-shirt company where we work in a very old-fashioned way... We stock our Tees manually and we use this kind of sheet (test1 attached).
    My problem is we can create new designs and also delete some old ones.
    On sheet2 I would like to have a database where I could insert an new line (for a new design) or delete one (obsolete) but keep the "test1" sheet updated in alphabetical order.
    I hope you can understand and help me...

    ThanksTest.xls
    Last edited by FDibbins; 12-22-2014 at 05:59 PM.

  2. #2
    Forum Expert
    Join Date
    10-09-2014
    Location
    Newcastle, England
    MS-Off Ver
    2003 & 2013
    Posts
    1,986

    Re: I don't even know how to start...

    what gets populated in the rows between designs on Sheet1?
    If someone has helped you then please add to their Reputation

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: I don't even know how to start...

    Hi, welcome to the forum

    It might be easier top offer suggestions if you included some dummy data, and a few examples of your expected outcome
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Autoupdate sheet

    Hi Redge and welcome.

    Can I ask that you rename your query.

    One of the moderators will chastise you and any respondant as your title stands.

    Some thing like: Keeping Master List updated and in Alphabetical order.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: Autoupdate sheet

    mehmetcik, I had already changed the title for the OP, but I like your suggetion better

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Copy variable amount of rows between Start and End to Start
    By EDo1981 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-19-2013, 07:37 AM
  2. [SOLVED] OT :Start your own online business today !start making dollars
    By ag281962@hotmail.com in forum Excel General
    Replies: 0
    Last Post: 05-06-2006, 04:35 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1