Need help with Macro to run on activated sheet

[sjsfiji]

Hi All,

I have a workbook with multiple sheets that have similar data on similar fields. I recorded the macro on sheet 1 "ref", but does not run on any other sheets. How can I change it so that it runs on ANY sheet that's active.

thanks,

sjsfiji

---------------------

Please Login or Register  to view this content.

[rylo]

Hi

Try this

Please Login or Register  to view this content.

Can you please remember to wrap your code in future posts. Highlight your code, then press the # icon and this will perform the wrap.

rylo