I am a showcaller, that’s, throughout stay occasions I inform technicians when to play movies or music or to vary lights and so on.
I take advantage of a Google Sheet for my operating order and every line accommodates the varied cues – actions that technicians should take, like ‘play Video 1’ – separated into columns for the completely different departments: Lights, Sound, Video and so forth.
I need to collect the cues for various departments as textual content in a Notice in a single cell. I can then edit the textual content to write down my standbys – the warnings of upcoming cues – and browse them from the Notice through the occasion.
So I’m attempting to make a macro to take the contents of the cells in a relative vary and paste them collectively as textual content in a Notice in a single cell.
I’ve tried recording a macro and utilizing cut-and-paste to pick a spread and put it right into a Notice on the lively cell. Nonetheless this solely positioned the contents of the clipboard into the Notice as textual content – it did not do the cut-and-paste as a part of the recorded actions within the macro.
I am glad to do the work to write down it – can anybody assist me, please, with the proper approach to have the macro copy and paste from a relative vary. Thanks.