+ Reply to Thread
Results 1 to 2 of 2

Navigate/auto-scroll inside a spreadsheet (excel clothing visual-inventory sheet)

  1. #1
    Registered User
    Join Date
    02-04-2010
    Location
    canada
    MS-Off Ver
    Excel 2011 mac
    Posts
    4

    Navigate/auto-scroll inside a spreadsheet (excel clothing visual-inventory sheet)

    Hi Excel Forum

    The problem is simple and yet can't find a solution searching these forums and even using google site: option search... I think it's because I cannot formulate it correctly due to my basic (but still good) english skills.

    I want to have a button or some text/hyperlink that when it gets hit it scrolls down to a certain row and place it at the top of my window - so I can see the categorie's content that is listed below.

    I am attaching my sheet.
    I have text cell at the top depicting Top, Bottom, Denim and so on so forth, so basically I want to hit those and be scrolled down to those categories (inside the same spreadsheet) and have them presented to me with the title (first row concerned) at the top of the screen (I do not want to have only the title of the category at the bottom of my excel window and have to actually scroll more to see the content)

    Hope I can make sense to someone, I've spend (wasted?) enough time on this simple feature that it's just not worth it anymore so I figured I ask you and wait to see if something happen.

    best regards to you, reader,
    JB

    PS any other comments, suggestions or hints of how i could improve this inventory list would be, will be, can be for ever and ever greatly appreciated. All hail to Excel Help Forum!

    since my file is slightly too big I will host it on my dropbox and share the link below:
    my excel file - thank you (1.75MB because of images)

    EDIT1: ULTIMATELY - I just had a flash in my head.
    What I would like to be able to do is use the exported file from my inventory system (code with their qty) to update the quantity in my visual excel inventory listing (that I send to customer so they can use to order by replacing the value they want and highlighting them)...
    Last edited by jimstr; 02-04-2010 at 09:00 PM.

  2. #2
    Forum Contributor sauerj's Avatar
    Join Date
    11-11-2009
    Location
    Lafayette, IN
    MS-Off Ver
    Excel 2019
    Posts
    163

    Smile Re: Navigate/auto-scroll inside a spreadsheet (excel clothing visual-inventory sheet)

    Hello, Returning edited file w/ following changes:
    1) WARNING: I deleted all of the pictures so to reduce size, so I could send via forum. Be careful not to save this version over your REAL copy. You will have to copy & paste the specific changes over to your REAL copy.
    2) See VB module "z_GoTo_Macros" for SUBs that do what you want.
    3) Added Forms Buttons for user to "click" that drives these SUBs. These buttons are inserted via the FORMS toolbar. They are NOT the same as Text Boxes, and not the same as Command Buttons (via the Control Toolbox toolbar). I like these FORMS buttons as they are easy to program, easy to read the button text (even w/ very small font) and I like the 3-D look they offer. NOTE: You may need a different button to give you better security for this sort of application. In that case, the Control Toolbox Command Button may be better suited. That, however, gets beyond my "know how".
    NOTE: Credit goes to the following site for developing this VB code (http://www.ozgrid.com/forum/showthread.php?t=35881).
    ... Regards, sauerj
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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