Macro for shopping list

I am sorry i didnt give enough information this is all new to me.

I have uploaded a simple copy of what i want to achieve and hopefully you can get some idea as to what i want to do. Basically i want to get what is ordered in each department (tabs along the bottom) to the Total Supplies Tab so that i can fax just that page to the supplier.

I hope this make a little more sense.

Thanks

Thank you so much that is just what i needed.

I need to do a course so that i don't have to rely on your knowledge in future

Kind regards

Sharon

Jimmy just one thing, i have now adapted what you did for me on to the original spreadsheet that has more lines. But when i run the macro it repeats itself. I get the same information twice. Can you please let me know why it is doing this.

Thanks again Sharon

I haven't done too many adustment i don't think but i don't totally understand the whole macros thingy and that is why i am here writing to you i guess.

Can you have a look for me and let me know what it is i have done wrong

Thanks again for your time

Sharon

Thanks so much for your help in getting this to work. It is going to make the job a whole lot easier. I didnt really consider doing it in access but Tony is probably right it would be less likely to be corrupted. Problem being the people i want to use this just need something basic to play around with.

Just one question, i loaded it onto another computer and when they ran it the got a debugger error, what causes that to happen??

Thanks again for all your help, i am sure i will be back with more questions in the future as i try and streamline some of the jobs that are done around here.

Regards Sharon