How can I get macro to recognize every time a number changes

Hi,

The code below copies data and places it on it's own sheet. It works great. My problem is I want it take the data and place it on it's own sheet every time the number changes. Example: Right now the below code will take the data for PO # 101012752 and place it on it's own sheet. I want to change the code so it will recognize every time the PO # changes and place it on it's own sheet without me having to go in and manually change the PO # in the code each time. Any thoughts?

Thank you so much in advance for your help.

Eddie.

Please Login or Register  to view this content.

I'm sorry. I posted this in two places. If you want please remove this one and leave the one I have in the VBA/macro forum.

Eddie.