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

[punter]

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 helpe.

Eddie.


'Copies data onto its own sheet.

Please Login or Register  to view this content.

[boylejob]

Eddie,

In the VBA Editor you can go to the Sheet where the change will occur. Using the Worksheet_Change you would have it look at the address of the cell where the change occur. In your case you would reference the cell containing the PO #. If that cell changes, call the code for moving the information

Would look something like the code below where "$A$1" would be the cell where the PO # is located

Please Login or Register  to view this content.

You would then set this line of your code to be a cell reference instead of a manual entry.

Please Login or Register  to view this content.

Does this help any?

[punter]

Yes it did help. Thank you very much. I'm sorry I forgot to reply quicker than this.

Eddie.

[boylejob]

Eddie,

Glad it helped!