I. Hola Compañero, aunque no soy usuario de Excel, quisiera facilitarle la información que vi sobre esta posibilidad (o aproximaciones), por si pudiese serle de alguna utilidad mientras le atiende una persona conocedora de primera mano.
Le ruego me disculpe todas las molestias y el tipo de respuesta, ánimo.
https://www.quora.com/How-do-you-copy-a-formula-in-Excel-but-keep-one-cell-constant
https://www-ablebits-com.translate.goog/office-addins-blog/copy-formula-excel/?_x_tr_sl=en&_x_tr_tl=es&_x_tr_hl=es&_x_tr_pto=sc
https://www.reddit.com/r/excel/comments/b10f4d/copypaste_ranges_of_exact_formulas_without/
https://www.excelforum.com/excel-formulas-and-functions/621601-copying-same-formula-with-only-one-cell-change.html
https://superuser-com.translate.goog/questions/1820023/cut-and-paste-function-changes-formulas-in-spreadsheet?_x_tr_sl=en&_x_tr_tl=es&_x_tr_hl=es&_x_tr_pto=sc
https://www-excelcampus-com.translate.goog/functions/fill-down-blank-cells/?_x_tr_sl=en&_x_tr_tl=es&_x_tr_hl=es&_x_tr_pto=sc
https://www.reddit.com/r/excel/comments/x2u7j4/how_to_copy_rows_to_the_next_sheet_if_a_condition/?tl=es-es
https://www.youtube.com/watch?v=UaZ7pDHtR8A
https://www.youtube.com/watch?v=1iC5cSeInvY
https://superuser.com/questions/1203944/how-to-copy-multiple-relative-formulas-exactly-as-they-are
https://www-datawrapper-de.translate.goog/blog/split-and-extract-text-in-Excel-and-Google-Sheets?_x_tr_sl=en&_x_tr_tl=es&_x_tr_hl=es&_x_tr_pto=sc
https://www.mrexcel.com/board/threads/vba-causing-formula-in-able-to-not-copy-down-to-new-rows.1234220/
https://www.youtube.com/watch?v=PVhuI4pJ6es
https://www.youtube.com/watch?v=PVhuI4pJ6es
https://www.youtube.com/watch?v=zWhGVZ-R-6g
https://www-datawrapper-de.translate.goog/blog/split-and-extract-text-in-Excel-and-Google-Sheets?_x_tr_sl=en&_x_tr_tl=es&_x_tr_hl=es&_x_tr_pto=sc