Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   Inventory list (https://www.askmehelpdesk.com/showthread.php?t=565699)

  • Mar 27, 2011, 09:27 AM
    Laurieclm
    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
  • Mar 28, 2011, 08:58 AM
    JBeaucaire

    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?
  • Apr 13, 2011, 10:17 PM
    plhapb
    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.

  • All times are GMT -7. The time now is 06:49 PM.