Hello Guys,
I hope I could get some help!

I have an excel work-sheet, on the top-right corner of which there is a
field called "PURCHASE ORDER #" with puchase order # 10001

The file is saved with the same name as its purchase order #
(10001.xls).

IS THERE A WAY TO AUTOMATICALLY PUT IN NEXT-IN-ORDER PURCHASE ORDER #,
ON THE NEW .XLS SHEET AS SOON AS YOU OPEN IT i.e. if the old sheet you
saved had number 10001, could we make new .xls sheet that we open, have
10002 as default in the Purchase order field and so on.

Also, could we save the newly opened file at a location without hitting
"Save" or "Save-As", with that new number (10002.xls) ?

Thanks,
Your help and advise will be sincerely appreciated!


---
Message posted from http://www.ExcelForum.com/