Cut and paste overwrite

**drbig** · 09-15-2012, 02:26 PM

Quick outline

Data in cells A1 and B1
A2 B2

and on

also have data in E1 and F1
E2 and F2
and on

If I am copying the data from E1 and F1 and pasting it into A3 and B3 but there is data present what I wanted to do was move the data from A3 and B3 that I am about to overwrite to E1 and F1 as in the location that I am copying that data from

any thoughts or pointers

Tim

**BB1972** · 09-15-2012, 02:56 PM

drbig,

If you need to save the data in the location you are about to write to (ie column A), I would suggest you copy and paste it to some blank cells, before copy/pasting from column E to column A, then copy/paste the data you moved from column A into column E. If it's a big spreadhseet, you could always insert some new columns near column E to hold your data, then delete these columns when finished.

**drbig** · 09-15-2012, 03:03 PM

thanks for the suggestion

**drbig** · 09-15-2012, 03:14 PM

or not allow you over write the data if it's not null

**drbig** · 09-16-2012, 05:16 AM

In the end used some VBA code to swap the cells and assigned it to a ctrl key

**Cutter** · 09-16-2012, 07:20 AM

@ drbig

Welcome to the forum.

Based on your last post it seems that you solved your problem but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.