Hi all
Someone has asked me if this is possible. To set up a auto incrementing job number for a cell , so that everytime you open up the workbook the number increases by one, but they also want that cell to be linked to a fair few other worksheets so they all have the same unique job number when they are opened up. Its like a auto invoice number but instead of one sheet the number has to be linked to 5+ workbooks, and i havent got a clue .
Thanks
Bookmarks