Split sheet, view multiple files, but no split between two seperate sheets?

[got_excel:]]

Hi All,
Excel has a split worksheet feature which makes for copy and paste functionality between to sections of the sheet.
It also has a View-arrange windows feature which makes for copy and paste functionality between two separate Excel file (arranged side by side) on the screen.

But as far as I know there is no similar feature which makes for copy and paste between two sheets in the same Excel file.

The ability to split the screen and display two sheets in the same Excel file - for the purpose of copy paste between them - doesn't seem to be a current feature in Excel.

Am I missing something?
And if this feature doesn't exist - what would is the best recommendation for a work-around?

Sincere thanks.

[Keebellah]

Hi, Not that I know of.
The only way I can imagine that you could achive something similar is full screen userform with two listviews one for each sheet
Google Excel and Listview. One link https://10tec.com/articles/excel-vba...-examples.aspx
But there are more

A Youtube explanation https://www.youtube.com/watch?v=bbhD41JSgZI

[MarvinP]

Hey Got..

Isn't this just a "View Side by Side"?

https://www.extendoffice.com/documen...s-at-once.html

[Keebellah]

That's a good one, but then you have to open as many new windows as there are sheets,
To automate it you would have to create a VBA routine to do that,
Great tip Marvin