yogi_Setup Cells B8:E To Be Automaticlly Populated When A Sequentially Numbered Invoice Sheet Testnnnnn Is Added

Google Spreadsheet   Post  #2243

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Sep-19-2017

question by: Amanda Zamora

https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/wI1yIHdx6pQ;context-place=mydiscussions

Aging Report cells auto imports data from sheets

I am trying to create an Aging Report.

Example:

I am working on a new invoice "BEAM170003"

Can you help me get the data from the newly created sheet "BEAM170003" to automatically show up in cells A8:D8 in Sheet "AGING REPORT"? (photo attached)

I did a few things that worked to grab the data but I'd have to manually input the formula in the next row... no thanks!

I'm sure there is a faster automated way of doing this that would save me loads of time :)