Excel 2003 VBA Help

S

spike250

Joined
Sep 6, 2008
Messages
8
Reaction score
0
Hi All,

I have a list of items that get ordered regularly on one sheet. What I am trying to do is in one column have the user enter yes if they want to order that item again and on clicking a button it will transfer all rows with the answer as Yes into a custom template on another sheet where upon checking the user would click another button to e-mail the filled in template.

Any help with the above would be most gratefully appreciated.

Regards

Spike
confused.gif
confused.gif
confused.gif
 
You really don't need a Macro on the first part of your question. Just a formula in the cells where you want to transfer your "yes" responses. As far as the second part of your question, have you tried anything yet, or is this still in the "thought" phase?
 
Back
Top