Copy row if value matches 'Sheet'!B1

[ngocpdn]

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:

1. Data is pasted in to "Master" Sheet.
2. Click "Run Report" button
3. 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]

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]

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]

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.