VBA functions to automate pricelist

[nosferer]

Hello All

Perhaps you can help me. I have created a pricelist for a company that sells camping supplies. What I need to do with the pricelist programatically, however, are.
1)Insert a drop down box that will hyperlink to each category
2)Create a button to insert whatever selected codes there are into a "Quote" worksheet.
3)Email the "Quote worksheet.
4)Update the pricelist automatically from a CSV file.

1) I have achieved this using by inserting a control and linking to a list on a hidden sheet, which then checks to find the headers. Problem is I can't force the "Header" to display at the top of the page. Is this possible.

2) I have created a button and it works BUT it simply pastes the data into my quote sheet. The problem here is that if the user "pastes" more than amount of rows I have allowed in my sheet, the information gets pasted over areas outside of the quote and as such are not added to the quote, it ends up being quite messy. I need to rather insert the information, but this will then not take into account the vlookup and sum formulas that I have in the cells adjacent to the "Stock Code" cells. From the confused explanation I can only guess that everyone will be almost as confused as I am!

3) I have achieved this by copying the "Quote" into Book1 and attaching this to an email, but it only works sometimes and then someimes does not...go figure.

4) This one I don't even know where to start!


Any help would be greatly appreciated, even if it is an offer for a job at a McDonalds where I never have to see another excel spreadsheet!


Nosfere

[Leith Ross]

Hello Nosferer,

I would need to see your workbook before I could help you with these problems. If you e-mail the workbook to me, I'll gladly look it over and help you get this working. my e-mail is LeithRoss@aol.com.

Sincerely,
Leith Ross