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)...
Bookmarks