I don't have programming background, but as a novice, experiment with formulas on my own.
I have two separate live sheets;
On the 1st sheet (sheet A) tab F, when I write
Y into any cell in Column O, say
O6, I need the data in the next column(Q) same row (6):
P6, to be transferred (dynamically -thus assumed the formula as indirect- updated for each row) into sheetB column D. Since these are live separate sheets I know that I need to use
importrange but dont know how to write the formula.
=IMPORTRANGE("SheetA";indirect("F!P")& IF(P6:P:275, "Y"))
Update #1: Did some reading and research, and found out
query function might work better, thus have come up with the formulas below. However, while the first currently gives me
formula parse error, the second gives
=QUERY(IMPORTRANGE("SheetA","F!O:P"), “Select #(Col2) where Y N(Col1) contains ‘Y’ “) =QUERY(IMPORTRANGE("SheetA","F!O:P"), "Select * Where Col2=<>"")")
I need the data on Demo 1,
P7, to automatically be added to Demo 2,
D11. Moreover, if possible, I need this formula cover all the rows (+to be added) on Demo 1 sheet, while all, say 25 occurrences out of 350, are added under each on Demo 2, without moving the whole list from Demo 1.
My starting point was to tag the
Ys with an
if formula that created the number in
P7. That's why on Demo 1,
1010101010. However, if there is any other option/formula, all fine by me. Otherwise, manual calculation takes too much time.