1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Excell function

Discussion in 'Business Applications' started by Brianw, Sep 30, 2008.

Thread Status:
Not open for further replies.
Advertisement
  1. Brianw

    Brianw Thread Starter

    Joined:
    Aug 9, 2004
    Messages:
    35
    Hi to all,
    Can you please tell me how i can do a number counter in excell. i have 1 book= 3 sheets and i want 1 counter between the 3 sheets. i produce certificates with serial numbers and have three different types to produce but the serial numbers must follow on. Is it possible please!! i am not so good with macros
     
  2. MRdNk

    MRdNk

    Joined:
    Apr 7, 2007
    Messages:
    439
    It's very possible.

    How many records do you have?
    Can you post your excel sheet with dummy data? - It'll help a lot.
     
  3. Brianw

    Brianw Thread Starter

    Joined:
    Aug 9, 2004
    Messages:
    35
    Heres the dummy data.hopes this works
     

    Attached Files:

  4. edhicks

    edhicks

    Joined:
    Jun 30, 2008
    Messages:
    248
    Here is a quick answer. Others will improve it, Enjoy
     

    Attached Files:

  5. MRdNk

    MRdNk

    Joined:
    Apr 7, 2007
    Messages:
    439
    Well it does what it says on the tin. Good work edhicks.

    Brianw, is this what you want? If you want more, then post what you expect the resulting data to be.

    Questions
    1. How many records are you likely to be dealing with?
    2. Why do you use 3 separate sheets, when all your fields are the same? If you want something that separates them, use another field, which represents the difference between them, like a groupID.
    3. Expected output. Serial Numbers? On one sheet? For each record on each sheet? Both?
     
  6. Brianw

    Brianw Thread Starter

    Joined:
    Aug 9, 2004
    Messages:
    35
    Answer to question 1. Possible up to 2000

    Answer to question 2. I like them on 3 seperate sheets, because it keeps the categories apart.

    Answer to question 3. I would like one continuous serial number to cover all three sheets, if this is not possible then I will consider putting all the data on one sheet.

    Thanx so far, appriciated
     
  7. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/754860

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice