04-22-2007, 03:44 PM
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
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