Prev: Copy and insert multipel rows after each row of data
Next: Coloring cells
From: The Project Master on 3 Jun 2010 18:55
I am creating a purchase requisition form in Excel and when users open
the spreadsheet I want the requisition # incremented by 1 so we have
unique requisition #'s each time a requisition form is completed.

Is there a way to accomplish this in Excel? Thanks for your assistance.
From: Gord Dibben on 3 Jun 2010 19:29
This workbook will be a true Template(*.xlt)?

For sequencing numbers see John McGimpsey's site.

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


Gord Dibben MS Excel MVP

On Thu, 3 Jun 2010 15:55:46 -0700, The Project Master
<TheProjectMaster(a)discussions.microsoft.com> wrote:

>I am creating a purchase requisition form in Excel and when users open
>the spreadsheet I want the requisition # incremented by 1 so we have
>unique requisition #'s each time a requisition form is completed.
>
>Is there a way to accomplish this in Excel? Thanks for your assistance.

From: Don Guillett on 3 Jun 2010 19:34
It may be better to put in a before_print macro

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett(a)gmail.com
"The Project Master" <TheProjectMaster(a)discussions.microsoft.com> wrote in
message news:19FB615A-33BB-4FD9-8516-57AFF242B620(a)microsoft.com...
>I am creating a purchase requisition form in Excel and when users open
> the spreadsheet I want the requisition # incremented by 1 so we have
> unique requisition #'s each time a requisition form is completed.
>
> Is there a way to accomplish this in Excel? Thanks for your assistance.

 | 
Pages: 1
Prev: Copy and insert multipel rows after each row of data
Next: Coloring cells