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

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?

Without special settings, you will be redirected to the item view page. Maybe you could make use of SharePointBoost workflow (http://www.sharepointboost.com/workflows.html) to finish order while clicking on any item in this list.