INCLUDING A RANDOM NUMBER GENERATOR FIELD

G

Guest

I have created a PO form in Excel and I need to have a field generate a 6
digit random number on the form so it has a unique PO# each time.
 
G

Guest

Random is bad because yo will need to track which values have already been
used. Why not start with 100000 and just increment each time
 
G

Guest

Increment would be fine, but how do I set it up? I want it to either print
the incremental number (incrementing up each time I print), or change each
time I open it.
 

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

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
How do I create a purchase order log in Excel? 1
IF function results to include both text and cell value 2
Counting Occurence of identical order numbers 3
Unique Random Number Generator 1
How to insert macro results on a separate spreadsheet in row order 1
SUMIF or SUMPRODUCT or ?? 2
ENCREMENTAL FORMS 2

Top