Selectively copying/pasting (or simply transferring information)

A

abcon

New Member
Joined
Jul 21, 2015
Messages
1
So, how to selectively transfer information from one sheet to another -


So copy all the the "N/A"s from Sheet 1 and selectively paste them in the same position into Sheet 2, so that it looks like Sheet 3.


Notice that the information from Sheet 2 is kept in Sheet 3, unless the condition of "N/A" is met in that particular location.





Sheet 1
Sheet1_zpss1xfefkp.png


Sheet 2
Sheet2_zpspbshtvc8.png


Sheet 3
Sheet3_zpsj3mrrpbe.png
 

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number
You must log in or register to reply here.

Similar threads

S
  • Question Question
Copying a table to new worksheet after it has been sorted from a previous worksheet
3 4 5
Replies
48
Views
1K
Logit
Logit
S
  • Solved
Selecting Cells for cut, copy, paste using using variables
Replies
4
Views
79
Steve001
S
D
  • Question Question
VBA Search a range for a value, then copy and paste data only from source to defined cells.
Replies
0
Views
353
Davion615
D
B
  • Question Question
vba to copy selected cells and some cells adjacent to next blank row in different workbook
Replies
4
Views
200
Peter_SSs
Peter_SSs
T
  • Solved
VBA Assistance With Copying & Pasting
Replies
6
Views
281
Tommy1115
T

Forum statistics

Threads
1,226,694
Messages
6,192,473
Members
453,726
Latest member
JoeH57

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top