how to use relative cell reference in a template

I have a template of a packing list I created. I open the template, fill in some weights and do a save as, creating a new unique file. Is there a formula or method that can be used to write the weights to another workbook as well. I am trying to remove the step of manually entering a series of numbers at the end of every month. I know how to put a formula in the template to do this, but how do I get the new file to skip to the next lower cell in the other workbook's column?

1 answer