Hello, sorry not very good at all of this But i would like to create a spreadsheet which when comments are added to cells they also show as values of cells on another sheet.
So for example a booking sheet, rather than adding names to the cell they would be added to the comments, and second sheet they would be added as values. Sheet1:A1 value is "booked", insert comment "Dave Smith" > Sheet 2:A1 value is "Dave Smith" Hope this makes sense to someone, really need a starting point as I am a beginner at Google Scripts Thanks -- This email and any attachments to it may be confidential and are intended solely for the use of the individual to whom it is addressed. Any views or opinions expressed are solely those of the author and do not necessarily represent those of ISIS Training & Recruitment Ltd t/a e-QAS Training. If you are not the intended recipient of this email, you must neither take any action based upon its contents, nor copy or show it to anyone. Please contact the sender if you believe you have received this email in error.
