Hello,
I've been struggling with this for hours now.
I believe the solution is simple, but I can't figure it out.
The complete steps being taken are as follows...
Open external workbook
Manually select range (which varies often)
Press Ctrl+C or right click select Copy, to copy selected range...