Hello Good afternoon I have a simple request but I really dont know how to solve it
I Have to extract the Url Adress of a Cell in a table and repeat this Formula when I copy an paste the table, but the range of the Url need to change automaticly as the tab need to be ciped for all the sheet
example
C2 is the range
the Url will be extract in d37
folow the formula in D37
=(ArrayFormula(if(len(D37),"URL"&row(C2),)))
when i copy the Tab
the range ( C) need to be change automaticly in L or the Cell where there is the name of the recipe
how can I do?
I will appreciate all your help
in attavhed the file , the sheet name where ther formula need to be done is Basic Recipe master
Bookmarks