Hi there. Using Excel 2007 and Windows 7.
I've made an inventory workbook that has some conditional formatting so that when my quanitity gets equal to or lower than 25% of what I want to keep on hand, that cell turns red. Also, when the quanitity cell changes, my VBA script goes through the first sheet and any row it finds meets the criteria of my conditional formatting =(E2<=(0.25*I2)) it copies it to the SUMMARY page.
What I am wanting is a for the quanitity cell on my SUMMARY page to be a hyperlink to that row on that sheet. Also, I do not know how to change my existing VBA to go through all sheets and update the summary sheet.