Hi
I know there are various variations of this question that have already been asked however I still cannot find what I'm looking for!
I use a basic template for estimates. I would like to be able to use the next available number from a list on another workbook ( Master WB) to number the spreadsheet each time the template is used. I would then like to be able to populate the cells on the same row as the number (on Master WB) with various details from the new spreadsheet. such as; customer name, address, date and value of estimate etc. I'm thinking that his data could be updated on saving??
I have little or no experiance of macros or vba
Cheers
Mick
Bookmarks