I have two goggle sheets on the same document. I need to transfer specific ranges from one sheet to another one, on specific ranges inside that sheet. I would like to add a time stamp once there new edit is done.
Sheet names : Input: Bryan Output: Responses
Ranges for input Q12:Q17 Q19:Q23 Q25:Q26 Q28 Q30:Q31 Q33 Q35:Q37 Q39:Q41 Q43:Q59 Q63
These ranges would need to be pasted starting on column E and then moving thru the columns e,f,g so on the same row. Column A would need a timestamp. I need to be able to choose what ranges the information input to
Thank You
CodePudding user response：
timestamp upon cell edit:
=LAMBDA(x; x)(IFERROR(B1/0) NOW())
timestamp upon range edit:
=LAMBDA(x; x)(IFERROR(B1:B10/0) NOW())