Home

Excel - transferring data

Peter Johnson
New Contributor
This is probably easily answered as a colleague in work assures me it's really done but I'm inexperienced with Excel.

I have 2 separate sheets in the same Excel workbook. The data is arranged in the exact same format on both sheets but the actual information is different. How do I copy the information from one sheet on to the end of the other?

Thank you

Peter J
2 Replies

Hi Peter,

 

If that's one time job when simple copy/paste. Select data in first sheet (in most cases stay on the top left cell of your range, press Ctrl and Shift, when arrow down, when arrow right till end of the range, release Ctrl and Shift), Ctrl+C, go to the end of the range in the second sheet (could work as Ctrl+End, Down, Home) and Ctrl+V. Works both in online and desktop versions.

 

If you do that from time to time and would like to automate - it depends.

Sergei,

That worked! Thank you very much, very much appreciated. You wouldn't believe the nonsense and hours I've expended on this without an outcome.

Thanks again.

Peter
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies