Tech Support Guy banner

Macro for shopping list

2768 Views 15 Replies 3 Participants Last post by  OBP
Hi i want to create a macro for a shopping list. I have a main list by which i place orders from, but i don't order everything on this list. I want to be able to take the items i have ordered and put them in another worksheet so i can then fax just the items i have order off to the supplier. I have no idea how to do this. Can someone please help me.

Thanks
Status
Not open for further replies.
1 - 3 of 16 Posts
Jimmy, would this be under better control if it was in Access?
My concern was that Excel is so easy to "play with" and therefore Macros are very susceptible to being wrecked by inadvertent changes.
Jimmy, it might be Reference Library settings, that is a favourite one when changing computers.
Sharon, "just play around with" sounds a problem where Excel is concerned, especially if they start adding rows, columns, sheets etc. Hard coded Macros have to be very very versatile to deal with that kind of thing.
1 - 3 of 16 Posts
Status
Not open for further replies.
Top