I am trying to set up a field in Excel that will change my invoice # everytime i open it..so i wont repeat #s?

Question

Can I use a macro? And how? it is driving me crazy there has to be a way to do it!

Answer 1

Not without a database. Everytime you open a file in Excell it will open as it was when you closed it...that is the auto-save function at work for you.

You can increment the number after opening the file...but then you would be doing it by hand which is what you are trying to avoid. Excell doesn't have internal database features so you need to have a database to work with.

The suggestion of having microsoft office is good, you need access which is microsofts easy to use database.

OR if you have someone who can do a little programming, you could use MySQL database.

Answer 2

Hmmm it should be possible to hack a script that does this. But you have to save each invoice with a new name, but that can probably acompliched with a macro as well.

I am not tat much into visual basic but basicly the formula would be (this is PHP-code sorry).

$a = get the value from the cell with the last invoice numer;
$a += 1;
$invoiceno=$a;
echo $invoiceno;

Answer 3

I'm assuming your Excel file has a header like:

Inv.# Item Description Charge Paid

In A2 enter the first invoice number
in A3 enter the formula =SUM(A2+1)
in A4 enter the formula =SUM(A3+1)

select A3 and A4
put the cursor at the bottom right until you see a +
Drag it down as far as you want the formula

Answer 4

bypass to My computing gadget>equipment>Folder concepts>document sorts.Then see even if an icon in that record is called XLS close to the bottom of the folder concepts window you'll see sumthin saying replace click on it a sparkling window opens browse via the record an click on excel click on ok. lower back click on ok. there is yet another approach, good click on the kept excel document then click on open with and choose excel. it extremely works.

Answer 5

Well normally this is done with a database. As you add a new order, a new record is created that does not repeat. Have you tried www.microsoft.com/office?