Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Auto update quote number

Hi, I have an quote template that each time I open it, I get an new quote
number. For example the first time I open it the number is TS0001 the next
quote I do I would like it to be TS0002.

Can anyone help.

Cheers
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,501
Default Auto update quote number

Hi,

This site covers the subject.

http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

Mike

"Timma00" wrote:

Hi, I have an quote template that each time I open it, I get an new quote
number. For example the first time I open it the number is TS0001 the next
quote I do I would like it to be TS0002.

Can anyone help.

Cheers

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automatic Quote Number Creator Nitza Excel Worksheet Functions 4 January 21st 07 06:41 AM
Sometimes formuli in workbook don't auto update with auto-recal on PE2 Excel Worksheet Functions 1 October 12th 06 03:49 PM
Convertig Number to Text - equivelent to single quote Nathan Excel Worksheet Functions 1 September 8th 06 04:33 PM
excel links update not working in auto, calculations in auto Mikey Boy Excel Worksheet Functions 0 December 7th 04 11:53 PM
single quote 10-digit number that has leading zeroes & then conca. lorelei739 Excel Worksheet Functions 1 November 5th 04 12:02 AM


All times are GMT +1. The time now is 09:55 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"