Hi,

I use the following VBA code:
Please Login or Register  to view this content.
This is done because I want it to look 5 columns to the left. But with recent developments it is possible that changes will be made and the location the area could be uncertain.

To reiterate, I want it to find the column with a heading of "Notes" and then copy whatever values those cells have into column W.