hi im new to this but i need some help please with excel stock sheets i have to do for work. these sheets are meant to follow on weekly and closing stocks should automatically go into the following weeks opening stock but they dont. also when i add new stock they dont follow onto next week either so i am manually copying and pasting every week. i dont know much about excel and know nothing about formulas but this is now getting ridiculous for me as management dont really care enough or dont know how to do anything to make my life easier .. please please can anyone help me?