get rid of all the colour fill and borders - explore the use of 'structured tables' they dynamically expand - negates the need to keep altering range sizes in your code - place your entire data on one sheet and extract to a template when you want to view individual months - create a UserForm to input your data including facility for updating/deleting - also place you entire range of products on an inventory sheet to select from.