Find and Replace Macro

[Tybalt]

Hello,

I have created a table which finds potential Split errors - but I want to create a macro which will then correct them.

The macro should be able to locate the split by the reference number and then past the "Actual Split" on the "Comisson Statement" page.

I have attached an example which I think helps make it very clear.

thanks!

[jtp]

Hi,

Is this what your looking for? Hope it helps

[Tybalt]

Your awesome! That was EXACTLY what I was looking for!!!!

thanks so much!