Copy row if value matches 'Sheet'!B1

**ngocpdn** · 03-17-2013, 07:27 AM

Hi guys,

Need some help with a side project i'm trying to do... THANK YOU for any assistance

I've seen similar question to this...and have been trying to make other codes work with what i want... either i suck or i'm leveraging from the wrong starting point.

Scenario:

Data is pasted in to "Master" Sheet.
Click "Run Report" button
VBA does its magic. but i cant seem to get any magic going

Sample1.xlsm
VBA is to...

In each sheet "B1" has a value,
value needs to be searched against "Master!A:A "
IF matches cut the row
Paste into next available row for that sheet (for each relevant sheet)
Once completed "Master!" should be blank & relevant data moved to each sheet...

Because i'm not great at explaining i have uploaded an example of my craziness.

Thanks in advance for any replies

**Sbarro79** · 03-17-2013, 12:36 PM

Hi
I created some simple macro (see attachment) and it does its magic, although I'm not sure, if this is what you expected.

**ngocpdn** · 03-21-2013, 04:51 AM

Sbarro79,

Thank you thank you thank you!
It is Exactly what I was hoping to do

The code you made was so simple and clean. When I look at what I was trying to do/edit... I feel like a moron.
This will make life so much easier.

**ngocpdn** · 03-21-2013, 11:54 PM

Hi Sbarro79...

When I change the code to search Master!B1:B instead of A:A it doesn't work..
Is it possible to make it search column B instead?

Other than that the coding does what I'm looking for.

Thanks again.