Hi,

I work as a purchasing assitant and after using excel for many years just discovered macros can make my life so much easier when:

1)placing purchase orders i.e. inputting date, changing order number, entering quantity, emailing it to relevant suppliers, changing company name etc

2) using macros I can predict when I will be out of stock as the figure in a cell will be highlighted in red so I can view all red type cells or minus figures only

However as I do not know any thing about them I wondered if you guys can help:

1) whats the best and simplest ways to learn basic macros that can help me with the above 2 tasks?

2) does anyone already use macros and have the vb text I need to add to the module? If that at all makes sense?

Rest assured this weekend I am on a mission to learn how to use macros so that life can be made so much easier....

I am aiming to add a button on the actual worksheet or would you recommend I add a shortcut to the tool bar?

Any help would be most appreciated with additional ideas

Thanks in advance, thank you very much