Conditional Copy and Conditional Paste

A

agog12

Board Regular
Joined
Jan 23, 2018
Messages
104
Kindly see the attachments

And one more thing my data is big so in sheet 2 there r 4 Pasted parts so what i want is don't paste the data in sheet2 and paste that data in sheet4 (1st part)separately in sheet5( 2nd part)separately in sheet6 (3rd part) seperately and in sheet 7 (4th part)seperately

Link to download the sample file
https://www.ozgrid.com/forum/forum/.../1198481-copy-and-paste-data-as-per-condition


​​​​​
 

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.
You must log in or register to reply here.

Similar threads

B
  • Question
Paste results of Filter Function in place, or in separate sheet
Replies
0
Views
113
bertible
B
P
  • Solved
Have copied data paste below occupied cell in Column A (offset)
Replies
5
Views
179
smozgur
smozgur
V
  • Question
Restrict Cut-Copy-Paste in the specific range of cells having data validation in a particular Sheet of a workbook
Replies
0
Views
552
Vishal Gupta
V
S
  • Question
Program Button to Find, Copy, Paste to New Sheet based on Value in column
Replies
0
Views
155
samss919
S
N
  • Question
Any way to keep the highlights from conditional formatting when you copy paste in value?
Replies
1
Views
921
Joe4
Joe4

Forum statistics

Threads
1,214,998
Messages
6,122,639
Members
449,093
Latest member
Ahmad123098

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