Monthly Inventory

[jdude]

Hello All

I am creating an inventory sheet for a restaurant. I am having an issue figuring out how to add inventory items and have them automatically remain (copy over) to the following months. Example: If I add "Mark West Pinot Noir" in June I would like it to show in July, August, and so on until the end of the year. Any help would be greatly appreciated. This is my first post to ANY forum so please forgive me if I am in the wrong place.

Thanks Again
Jdude

 

[Smitty]

What line does it fall apart on, and what's the error message?