+ Reply to Thread
Results 1 to 1 of 1

Track spreadsheets created from a excel template.

  1. #1
    Registered User
    Join Date
    03-31-2011
    Location
    Swindon, England
    MS-Off Ver
    Excel 2016
    Posts
    31

    Track spreadsheets created from a excel template.

    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
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1