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

In less successive cases, you might need to influence a cell to reference "blended" by going before either the segment or the line an incentive with a dollar sign to "bolt" either the section or the line To change the form of cell reference.