sorry for asking the question again, but i didn't quite understand the first
post. i use a template for quotes to customers. a macro was created to
save this file everytime as a new file where the quote number (generated
through another macro) and date (these are 2 cells in the file) is used as
the file name. what i need to do is to pick data from 11 cells in every new
file (which are range totals in the worksheet) and duplicate these cells'
values in a 3rd book (i.e. book1 = template, book2 = newly saved file, book3
= the file where the totals are kept).

can this be done? if possible how?
thank you