Hi

I'm not sure if this possible, I have a Quote Template workbook that I use for quoting. The first worksheet is set up as a quote sheet. The remaining worksheets store data that the quote sheet looks up and populates cells in the quote sheet. While I am doing a quote I sometimes have to add new items to the worksheets which store the data. What I would like to happen is when I save the quote as a different workbook name can the worksheets with the lookup data be saved to the original Quote Template workbook so next time I open the Quote Template the additional data I entered in the previous quote is in the worksheets so I don't have to re enter it.

I hope this makes sense if not please ask questions

Thanks