If Condition Macro Code

[lakshmipathi123]

Hi Experts,

I have query regarding If condition macro. Will you please prepare and get me the macro code

Here is an example

1. Find and Copy
Condition 1
If 20310-0000 is available
Copy all data related to 20310-0000 and paste into Sheet2
Else
Msg box No data
Condition 2
If 20320-0000 is available
Copy all data related to 20320-0000 and paste into Sheet3
Else
Msg box No data
And so on….

2. Find and Delete

Condition 1
If 20310-0000 is available
Delete all data related to 20310-0000
Else
Msg box No data
Condition 2
If 20320-0000 is available
Delete all data related to 20320-0000
Else
Msg box No data
And so on….

Thank you,
Lakshmipathi Y

 

[Andrew Poulsom]

Continued here:

http://www.mrexcel.com/forum/excel-questions/665370-find-copy.html