If Cell Contains

[timbo1957]

Hi,

Is it possible to for osmeone to supply me with a mmacro that will do the following?

1.Run down Column B starting at B4
2.Identify the cells in column B which have the words New Customer Ref in them
3.Put the words New Customer Ref in Column H on the same row

i.e. if B57 has the words TAS New Customer Ref TAS put the words New Customer Ref in H57 then continue on down.

There could be all sorts of variations on what is before and after the words New Customer Ref so I can't use left or right because the length of what is in front and after the words New Customer Ref varies.

Many thanks

[patel45]

Please Login or Register  to view this content.