Auto Numbering Skipping Rows

**jkobz** · 11-01-2009, 12:42 PM

Hi-

I have attached a .xls that I got at a class and worked ok, but I noticed the date was not being copied to the next part in the correct format. I talked to the owner of the .xls and he couldn't figure it out so he sent me the unlocked version and told me I could just figure it out.

So in short, everything in the green cells is suppose to carry to the next page and the inventory # and box # are suppose to increase by one. Any help would be appreciated.

PS - I have it in 2003 or 2007

Thanks

**Leith Ross** · 11-01-2009, 12:52 PM

Hello jkobz,

Welcome to the Forum!

Since you havve bot Excel 2003 and 2007, you should post the Excel 2003 version too.

**JBeaucaire** · 11-01-2009, 06:40 PM

Simple enough to make simple =AN8 or =AN9 + 1 type formulas.

**jkobz** · 11-01-2009, 11:36 PM

Thank you, but does that mean I have to copy it to every cell going down?

**Leith Ross** · 11-01-2009, 11:48 PM

Hello jkobz,

Yes, you have to copy it down.

**JBeaucaire** · 11-01-2009, 11:50 PM

Your sample implied the green sections should reflect the top green section, and those two specific numeric cells should increment. In the sample sheet I attached, all that was already done for you. Just fill out the top green section.
=========

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].

(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)