Re:

by John_Spencer - 11/14/12 7:29 AM

In Reply to: Re: excel by Kees_B Moderator

yes, the list should be availble per department to avoid the need for transactional databases and such. It can be very simple: Per department, they can just open the "sandwich list" next to an open email and copy/paste their order. The orderlist will be on 1 computer, so everybody takes a minute to order and then goes back to their space. Send mail to secretary. Done. I was this far before I started the topic.
But I was thinking about turning the items on the list into hyperlinks (or something), which autmatically, copy the item to an email/notepad/word-doc when clicked. But I will learn about macro's if that would give better results according to you guys.