sequencing numbers
I am trying to put in macro for my invoices that will sequence the next
number every time I open my invoice file that is saved in excel. Can someone help me with the programming I am having no luck. Thanks |
sequencing numbers
see JC McGimpsey's site
http://www.mcgimpsey.com/excel/udfs/sequentialnums.html -- Regards, Tom Ogilvy "barb" wrote: I am trying to put in macro for my invoices that will sequence the next number every time I open my invoice file that is saved in excel. Can someone help me with the programming I am having no luck. Thanks |
sequencing numbers
For the range of invoice values use get the maximum value to get the highest
number and then add to that. As the list grows you need to set the range that represents all of you invoices. Use a dynamic range to do that., -- Regards, Nigel "barb" wrote in message ... I am trying to put in macro for my invoices that will sequence the next number every time I open my invoice file that is saved in excel. Can someone help me with the programming I am having no luck. Thanks |
sequencing numbers
I was at this site but it doesn;t seem to work for me when I try it on my
invoice. I downloaded a template invoice would that make a difference why I can't add the macro? "Tom Ogilvy" wrote: see JC McGimpsey's site http://www.mcgimpsey.com/excel/udfs/sequentialnums.html -- Regards, Tom Ogilvy "barb" wrote: I am trying to put in macro for my invoices that will sequence the next number every time I open my invoice file that is saved in excel. Can someone help me with the programming I am having no luck. Thanks |
sequencing numbers
I can't really say since I know nothing about your template.
-- Regards, Tom Ogilvy "barb" wrote: I was at this site but it doesn;t seem to work for me when I try it on my invoice. I downloaded a template invoice would that make a difference why I can't add the macro? "Tom Ogilvy" wrote: see JC McGimpsey's site http://www.mcgimpsey.com/excel/udfs/sequentialnums.html -- Regards, Tom Ogilvy "barb" wrote: I am trying to put in macro for my invoices that will sequence the next number every time I open my invoice file that is saved in excel. Can someone help me with the programming I am having no luck. Thanks |
sequencing numbers
Post the URL to your Invoice Template
Gord Dibben MS Excel MVP On Mon, 7 Jul 2008 10:59:03 -0700, barb wrote: I was at this site but it doesn;t seem to work for me when I try it on my invoice. I downloaded a template invoice would that make a difference why I can't add the macro? "Tom Ogilvy" wrote: see JC McGimpsey's site http://www.mcgimpsey.com/excel/udfs/sequentialnums.html -- Regards, Tom Ogilvy "barb" wrote: I am trying to put in macro for my invoices that will sequence the next number every time I open my invoice file that is saved in excel. Can someone help me with the programming I am having no luck. Thanks |
All times are GMT +1. The time now is 02:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com