Hi,

I am new to Excel and this forum.

I have recently been elevated to a position in my company and I would like to modernize how we keep track of a few things.

One is how we track outgoing and incoming invoices that our drivers use for billing. Right now we keep up with them in a ledger.

When we distribute invoices to a driver, we handwrite the 6 digit invoice number (10 invoices at a time), and put the drivers initials next to said invoices to show who has them.

When the completed invoices come back in they are highlighted in the ledger to show they have been processed. As a reference, if we can't locate an invoice for a given job, we go back into the ledger to see if it has returned. If not highlighted, then we know that the driver must still have said invoice.


I have tried in vain to replicate this on excel. I have figured out how get excel to reproduce the 6 digit numbers down a column, but just in one column. I would like for the numbers to be in columns a-c-e-g ect. The skipped columns, b-d-f-h ect. would be for drivers name or initials.

Also, is there a way to program a button for each invoice number(each cell) to hit to replicate the highlighting? I think red would be good without having to go and format each cell one at a time?

I see that having the date the invoice goes out is possible to put next to the invoice number cell.

This doesn't seem to be a tall order to be able to program, but my inexperience has me running into dead ends.

Anyone have any suggestions?


Thank you in advance for any replies.


Scott