I am working on a bidding calculator and would like to be able to automatically increment a Name Range once I finalize the formulas once. For instance, there are 15 cells per item row with formulas used to calculate a price that look similar to this one:


I would like them to automatically increment the named range as I copy them down a row. Can this be setup? I know I can do it with GAS ... just making sure I am not missing something in the standard interface.


  • share a copy of your sheet pls with an example of the desired output – user0 May 17 at 21:53

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.