+ Reply to Thread
Results 1 to 6 of 6

Numbering a Cell

  1. #1
    Andy JL
    Guest

    Numbering a Cell

    Hi,
    I have created a Invoice in Excel from my Office 2000, and saved it as an
    Excel template, I have a invoice number in Cell E14 which is 16 at this time,
    I want this number to be automaticaly increased by 1 each time I open the
    Template. Is this possible? If it is some very basic simple to follow
    instructions on how to do it would be most helpful>
    Many thanks
    Andy JL


  2. #2
    Sandy
    Guest

    Re: Numbering a Cell

    Try this in the workbook object

    Private Sub Workbook_Open()
    Sheet1.Range("E14").Value = Sheet1.Range("E14").Value + 1
    End Sub

    Sandy

    "Andy JL" <[email protected]> wrote in message
    news:[email protected]...
    > Hi,
    > I have created a Invoice in Excel from my Office 2000, and saved it as an
    > Excel template, I have a invoice number in Cell E14 which is 16 at this
    > time,
    > I want this number to be automaticaly increased by 1 each time I open the
    > Template. Is this possible? If it is some very basic simple to follow
    > instructions on how to do it would be most helpful>
    > Many thanks
    > Andy JL
    >




  3. #3
    Peo Sjoblom
    Guest

    Re: Numbering a Cell

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


    --

    Regards,

    Peo Sjoblom


    "Andy JL" <[email protected]> wrote in message
    news:[email protected]...
    > Hi,
    > I have created a Invoice in Excel from my Office 2000, and saved it as an
    > Excel template, I have a invoice number in Cell E14 which is 16 at this

    time,
    > I want this number to be automaticaly increased by 1 each time I open the
    > Template. Is this possible? If it is some very basic simple to follow
    > instructions on how to do it would be most helpful>
    > Many thanks
    > Andy JL
    >




  4. #4
    Andy JL
    Guest

    Re: Numbering a Cell

    Sandy,

    Thank you very much that work great. Very easy when you know how..

    Andy JL

    "Sandy" wrote:

    > Try this in the workbook object
    >
    > Private Sub Workbook_Open()
    > Sheet1.Range("E14").Value = Sheet1.Range("E14").Value + 1
    > End Sub
    >
    > Sandy
    >
    > "Andy JL" <[email protected]> wrote in message
    > news:[email protected]...
    > > Hi,
    > > I have created a Invoice in Excel from my Office 2000, and saved it as an
    > > Excel template, I have a invoice number in Cell E14 which is 16 at this
    > > time,
    > > I want this number to be automaticaly increased by 1 each time I open the
    > > Template. Is this possible? If it is some very basic simple to follow
    > > instructions on how to do it would be most helpful>
    > > Many thanks
    > > Andy JL
    > >

    >
    >
    >


  5. #5
    Andy JL
    Guest

    Re: Numbering a Cell

    Sandy -
    Is there any way that I can link the invoice No. in E14 so that the workbook
    No. reads "invoice (with the same number & same date as in E16)

    Thanks again for your previous quick response
    Andy JL

    "Sandy" wrote:

    > Try this in the workbook object
    >
    > Private Sub Workbook_Open()
    > Sheet1.Range("E14").Value = Sheet1.Range("E14").Value + 1
    > End Sub
    >
    > Sandy
    >
    > "Andy JL" <[email protected]> wrote in message
    > news:[email protected]...
    > > Hi,
    > > I have created a Invoice in Excel from my Office 2000, and saved it as an
    > > Excel template, I have a invoice number in Cell E14 which is 16 at this
    > > time,
    > > I want this number to be automaticaly increased by 1 each time I open the
    > > Template. Is this possible? If it is some very basic simple to follow
    > > instructions on how to do it would be most helpful>
    > > Many thanks
    > > Andy JL
    > >

    >
    >
    >


  6. #6
    Sandy
    Guest

    Re: Numbering a Cell

    Hi AndyJL

    Don't know what you have in cell E16 but if i'm guessing right then I think
    you mean something like "Invoice No 16 - Sat, Nov 19, 2005" in a cell. In
    which case type
    ="Invoice No "&E14& " - "&TEXT(E16,"ddd, mmm d, yyyy") in whichever cell
    you fancy. E14 being your invoice no and E16 being the date(?). Adjust to
    suit.
    Sandy

    "Andy JL" <[email protected]> wrote in message
    news:[email protected]...
    > Sandy -
    > Is there any way that I can link the invoice No. in E14 so that the
    > workbook
    > No. reads "invoice (with the same number & same date as in E16)
    >
    > Thanks again for your previous quick response
    > Andy JL
    >
    > "Sandy" wrote:
    >
    >> Try this in the workbook object
    >>
    >> Private Sub Workbook_Open()
    >> Sheet1.Range("E14").Value = Sheet1.Range("E14").Value + 1
    >> End Sub
    >>
    >> Sandy
    >>
    >> "Andy JL" <[email protected]> wrote in message
    >> news:[email protected]...
    >> > Hi,
    >> > I have created a Invoice in Excel from my Office 2000, and saved it as
    >> > an
    >> > Excel template, I have a invoice number in Cell E14 which is 16 at this
    >> > time,
    >> > I want this number to be automaticaly increased by 1 each time I open
    >> > the
    >> > Template. Is this possible? If it is some very basic simple to follow
    >> > instructions on how to do it would be most helpful>
    >> > Many thanks
    >> > Andy JL
    >> >

    >>
    >>
    >>




+ 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