Originally Posted by MarvinP
Now I understand the problem. You have a great idea to produce a standardized worksheet for making bids or invoices, etc. You decided you needed VBA to create this and recorded a macro from the template sheet. You're looking for the next step to clean up your VBA code so it is useful. This is a great idea and many companies have this ability. The problem is that you need to varaiableize your macro code to fit your template.
Specifically, when you add a Material and follow the Macro, it inserts a row and then shifts all rows down. When this happens it messes up the rest of the macros for adding other things.
This is the first time I have ever suggested this, but IMHO you will need to hire a VBA programmer to work through your recorded code and make your process work.
The other alternative it to learn enough VBA to do it yourself. You are looking at a few day job for a good programmer or a few weeks to develope, test, redesign, and get a final product.
Perhaps another of the Forum Gurus has a similar application that they have put together and can give you as an example.
Thanks for the recommendation. Unfortunately, it is a rather small business and we cannot afford to do such a thing. I was just hoping to brush up a few of the worksheets given knowledge I have with excel (albeit limited). I was able to figure out my inital problem with copying the new template with the button (and eliminating the additional buttons).
I do see what you were talking about with my macros to add a line. Someone in another thread showed me a pretty helpful macro to do what I was trying to do in a different manner. If you are interested, the code is as follows:
Thanks again for the help.