Ordering system for sandwiches etc..

Make "Some web-based program" running on the intranet.

Thanks for your reply, but I'm no programmer, or I would not be posting my question here.

Basically I would like to know if it's possible to make the items on a list clickable, and copy them in 1 new file.
I can make a Read/Only document, so they can copy/paste it into another file, but it would be nice to have something better.

Thanks, JS

Maybe not web-programming, but macro's in Excel for example.

Kees

Appreciate your effort, but I'm in need of a bit more advice then just: do this or do that, especially when you dont seem to know the solution yourself. I'm no IT-guy, so I dont know enough about macro's to make one for this purpose.

Work with the tools you know and use the features you know.

Excel is a nice way to present lists and let people (the department secretary?) fill in something.
Copy paste is a nice way to copy separate lists to one overall-list (by the company secretary?).

Kees

on your intranet, showing a list of available goodies.

One column per department.

Insert number of items per line

Secretary consolidates list at a certain time, calls it in. Then removes all the numbers from the department columns, ready for the next day.

P

This is more or less what I thought.

But several departments editing the same spreadsheet at the same time doesn't work well in Excel. So my thoughts were to give each department it's own spreadsheet (filling 1 column), mail it to the central secretary, who then copy/pastes that one column in the right column in her own spreadsheet, to fill the whole 'matrix'.
That's where a macro would be useful. And, having a macro that copies the column to that central spreadsheet, there isn't even a need to mail that file, because each department can just press the 'Order' button in its own spreadsheet.
But as long as macro programming is out of the question they will keep mailing, I'm afraid.

Kees

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.