I use Google Sheets as our main tool to dispatch construction trucks and communicate with our scale clerks the "who and what they will be picking up". I have researched for days on numerous sites about copying & pasting but my problem is the FROM and TO have the same data range (B8:B38) BUT...... the sheets names are rarely the same OR it will be the same sheet name but from a different file (files saved by calendar date).
Ideally a script that would blindly copy selected information from one active sheet [data range B8:B38 if required to make script work] (assume different file name) to another active sheet data range [B8:B38] (assume different file name).
Being realistic two individual scripts that I could assign "buttons" to mimic the keyboard shortcuts CNTRL + C & CNTRL + SHIFT + V are my best option. My clerks are all older and technology isn't their strong suit, but if they could click a button to copy and jump to a different sheet and click a button to paste they could easily handle the task.
I have tried macros too, but no luck working around the sheet names and/or filenames for my scripting ability.