Find and Replace values from multiple lookup values

Hi Guys,

Having a lot of trouble with what must be a simple macro of two parts:

Part 1:

I am trying to look up values in multiple worksheets from a list of lookup values in the last sheet in the workbook (titled "exclusives" in column B2:B250). Once it finds these exact values in all other worksheets (excluding the "exclusive" sheet) they all should be replaced by the value "Brand".
____________________

Part 2:

After this macro I then need a second macro which will look up all new "Brand" values in the whole work book and then replace the preceding eight cells (columns C - J) to the right of "Brand" valued cells with "" (i.e. clear contents).

If anyone has any ideas how I can get this to work I would be very very grateful. I am having great problems with this.

Many Thanks,

Greg

This routine will search through all sheets in the workbook (except "exclusives") and replace all instances of findMe and with "Brand". Looping through the your lookup values on "exclusives" will should take care of number 1.
Regarding number two. It would be easier to clear those cells at the same time as writing "Brand". It would take special juggling to be able to distinguish a new "Brand" from an old one. I'm wondering if you need two macros. Are you planning on doing anything between running number 1 and number 1. Combining them would be by far easier.
Also clearing the "Preceeding cells to the right" is odd phrasing. You want columns C-I of the same row cleared. Is that correct?

Please Login or Register  to view this content.