Hello,
I appreciate you taking the time to look at my problem. Ineed some help in a couple of areas.
I have about 6 workbooks, all with 20-70+ worksheets withinthem all correlating to different areas we work in.
They are all laid out the same with column E detailingdifferent lamp types we use eg. 70w SON, 35w SOX, 19w LED etc etc, there are about20 lamp types I have on my list currently. I will need to be able to keepupdating everything to add in new lamp (or delete) as the changes happen.
I have a totals page of this so we can keep track of howmany lamps we have in each area however things change, people change lamps allthe time without telling us and people update the spreadsheets without checkingif it is a new lamp type, not currently listed.
This is work I have adopted from someone else, so I am notsure if there is anything that has been already added that is not listed.
I know I can use conditional formatting for it to highlightcells that contain the lamps (therefor letting me see non-highlighted for me toknow they need adding to the totals page) however, I would have to do this foreach sheet, there are a lot, it would take a very long time. Is there a VBA wayaround this please that I can run on the sheet, and then be able to take it offagain so all cells clear of their colour when I have run the check?
Also, is there a way I can add a warning in, so if anythingthat is added into column E in future, that is not apart of the list, it comesup with a warning to add this in. I know I can do this through data validation,but I cannot get it to apply to the whole workbook causing the same problemwith conditional formatting.
Many thanks.
I appreciate you taking the time to look at my problem. Ineed some help in a couple of areas.
I have about 6 workbooks, all with 20-70+ worksheets withinthem all correlating to different areas we work in.
They are all laid out the same with column E detailingdifferent lamp types we use eg. 70w SON, 35w SOX, 19w LED etc etc, there are about20 lamp types I have on my list currently. I will need to be able to keepupdating everything to add in new lamp (or delete) as the changes happen.
I have a totals page of this so we can keep track of howmany lamps we have in each area however things change, people change lamps allthe time without telling us and people update the spreadsheets without checkingif it is a new lamp type, not currently listed.
This is work I have adopted from someone else, so I am notsure if there is anything that has been already added that is not listed.
I know I can use conditional formatting for it to highlightcells that contain the lamps (therefor letting me see non-highlighted for me toknow they need adding to the totals page) however, I would have to do this foreach sheet, there are a lot, it would take a very long time. Is there a VBA wayaround this please that I can run on the sheet, and then be able to take it offagain so all cells clear of their colour when I have run the check?
Also, is there a way I can add a warning in, so if anythingthat is added into column E in future, that is not apart of the list, it comesup with a warning to add this in. I know I can do this through data validation,but I cannot get it to apply to the whole workbook causing the same problemwith conditional formatting.
Many thanks.