Numbering based on user input

[Jack276]

Hi all, I'm new to programming for excel and have had some trouble figuring out where to start.

What I am trying to do is have invoice numbers fill themselves in based on the user inputting the first invoice number.

I have a table with store numbers listed vertically, then blank cells for invoice numbers, then 6 columns of items that each store can order. If the store has all 6 items blank I'd like to skip to the next row (or store) and continue until all 26 stores have been processed.

I may have not explained it clearly but I have attached a sample worksheet showing the table to better explain.

This is the code I have so far (not complete and doesn't work) and it gives me error Runtime Error '424': Object Required . I'm hoping someone can help me out with it or at least point me in the right direction of what I'm doing wrong.

Please Login or Register  to view this content.

[patel45]

you can change so

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

[Jack276]

Thanks Patel, that helped me actually get rid of my errors and understand what I was doing wrong.

I have completed my desired code and it does exactly what I want error free.

Here is the code I came up with. Perhaps there's a more efficient way to accomplish this?

Please Login or Register  to view this content.