I know I've asked a ton of questions in this forum, but you guys have a ton of knowledge and I've learned a lot from you. Here is another one.
I have created an automatic quotation system for a small business client of mine. I have it nearly completed, yet there is one area where I believe I am going to have some problems. I want to know if it's possible to do this with VBA or not.
Essentially, I have created a number of different userforms that ask the user for certain input requirments, such as contact names etc....at the end of the userforms they will be able to see a quote generated based off all of the user input. I have even created a feature that will save all the data into an excel spreadsheet, where they will be able to recall the quote on a userform when the unique identifier is entered, in this case the quote number.
My one problem, is that the recalled information will need to be modified from time to time, and I'm not sure how I can go about making this happen in excel. Access is probably a better tool to use, but my knowledge in access in minimal at best.
So my question is, if I have a worksheet with a number of different orders numbers and associated field...can I recall the quote, then overwrite the information that already exists in the stored quote worksheet. I think I can, I just haven't found any information in either the books I've read or this forum.
Any ideas or help would be greatly appreciated.
Michael
I have created an automatic quotation system for a small business client of mine. I have it nearly completed, yet there is one area where I believe I am going to have some problems. I want to know if it's possible to do this with VBA or not.
Essentially, I have created a number of different userforms that ask the user for certain input requirments, such as contact names etc....at the end of the userforms they will be able to see a quote generated based off all of the user input. I have even created a feature that will save all the data into an excel spreadsheet, where they will be able to recall the quote on a userform when the unique identifier is entered, in this case the quote number.
My one problem, is that the recalled information will need to be modified from time to time, and I'm not sure how I can go about making this happen in excel. Access is probably a better tool to use, but my knowledge in access in minimal at best.
So my question is, if I have a worksheet with a number of different orders numbers and associated field...can I recall the quote, then overwrite the information that already exists in the stored quote worksheet. I think I can, I just haven't found any information in either the books I've read or this forum.
Any ideas or help would be greatly appreciated.
Michael
