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
 
V

VbDustmop

Joined
Jan 30, 2010
Messages
2
Reaction score
0
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA to automatically cut, paste entire row based on date input and delete row 0
For Each Next; Multiple Arrays; VBA; Excel User Form; 1
display message box in excel(2003) using VBA word(2003) 0
Dynamic Range - VBA control of embedded Excel in powerpoint 0
VBA: How can I use a string variable as autofilter criteria? 4
Excel print button 0
Excel 2007 erases VBA code from Excel 2003 5
VBA to select font/colour not working 1

Top