Ask Experts Questions for FREE Help !
Ask
    Laurieclm's Avatar
    Laurieclm Posts: 1, Reputation: 1
    New Member
    		  
    #1

    Mar 27, 2011, 09:27 AM
    Inventory list
    I am making an inventory list for work. I want to be able to click on the item from the list and have it appear on another page so I can order just what I clicked on. Does Excel do this?

    Thank you
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #2

    Mar 28, 2011, 08:58 AM

    The behavior as you describe would require VBA, macros. Is that OK?

    If you changed your process to putting an "X" or something in the cell next to the items you wanted, then those items could appear on another sheet using just worksheet formulas.

    Click GO ADVANCED and use the paperclip icon to post up a copy of your workbook. We can look at it together.

    Macro or formula?
    plhapb's Avatar
    plhapb Posts: 2, Reputation: 1
    New Member
    		  
    #3

    Apr 13, 2011, 10:17 PM
    Without special settings, you will be redirected to the item view page. Maybe you could make use of SharePointBoost workflow to finish order while clicking on any item in this list.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Inventory accounting - cost of inventory destroyed [ 2 Answers ]

Please assist me with the following questions: Citi-Wholesalers marks its purchases up by 25%. Its inventory was insured against fire, the policy being subject to average. A fire took place on 30th October 2007 and all inventory was destroyed except for items which had cost $40 000 which were...

Differentiate merchandising inventory and manufacturing inventory? [ 2 Answers ]

Differentiate between merchandising inventory and manufacturing inventory?

How to find ending inventory using the average inventory cost method [ 3 Answers ]

The Boxwood Company Sells blankets for $60 each. Purchase 5 units 30$ Purchase 10 units 34$ Purchase 10 units 40$ Sale 3 units Sale 6 units Sale 3 units Assuming that the company uses the perpetual inventory system, determine the ending inventory for the month of May using the average...

How do you find average inventory using only ending inventory and COGS? [ 3 Answers ]

In searching the Internet on a method of how to do this, all examples include beginning inventory and purchases to determine average inventory. I know ending inventory for one year is beginning inventory for the next, but when you don't have information on purchases, how does one arrive at finding...

Determine the ending inventory under a perpetual inventory system [ 1 Answers ]

Hi ! I've honestly spent a long time trying to figure this out, but I keep getting the answer wrong and I'm not sure how I should go about this question. I'm not asking for you to just give me the answer, if you have time to give a little explanation that would be nice so I could understand what...

View more questions Search