Assigning a Number

  • Thread starter Thread starter jujuwillis
  • Start date Start date
J

jujuwillis

Can Anyone help.

I have a template for a job card.
This template has a database attached to it.
I want to be able to increase the "jobno" by 1 when using template t
create a new job card.
The next job no should be taken from the database for the job card.
If the numbers are to be taken from another sheet/document that woul
be ok as the information onto the database is taken from the job card.

Can anyone help me
 
is the database a sheet or a real database?
what do you mean with "Template"?
 
Use formula like
=LARGE(A:A,1)+1
When creating job card assign result of formula to new
database entry in Column "A". Formula will automatically
increment by 1 ready for next entry.

Peter Scott
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find Specific Rows in Range and Create New Tab 18
User form to assign an autonumber to spreadsheet - Any Ideas pleas 6
Prompt for file name and paste contents of active sheet 6
Adevance filter using VBA not show the requested data 2
VB.NET Datasets 0
Using a macro to open an existing workbook 2
Excel Drag autofill only part of formula 3
I took the plunge. New GFX card 11

Back
Top