Forum Home
Press F1
 
Thread ID: 80010 2007-06-08 11:31:00 Consecutive Numbering Excel Invoice David57 (7859) Press F1
Post ID Timestamp Content User
557322 2007-06-09 23:56:00 Hi

Have a look at this, it should do the trick

ukww.net

JonB
JonB (1885)
557323 2007-06-10 03:12:00 Producing invoices with Excel might be ... like a dog walking on its hind legs. It is not done well; but you are surprised to find it done at all. Samuel Johnson was talking about women preaching, but that was a few hundred years ago, before there was Excel. Graham L (2)
557324 2007-06-10 11:31:00 Write a macro that combines the date and customer code ie 020107BMA striping the formating from date (2/1/07 beama), yes a little vba would be needed .
Andrew or Parry should be able to help do this they are the gurus in this area.

Thanks for the vote of confidence beama!

That link you provided to MrExcel should do the trick so there's no need to reinvent the process......

Cheers
Andrew
andrew93 (249)
1 2 3