Hello,
I need to know if there is a way to have excel identify a cell that has been highlighted on one tab and have it pull the number from the cell to the left of the highlighted cell onto a separate summary tab. The highlighting is done mostly by conditional formatting so it will always change. I am thinking this may need to be done in VBA but I have never done anything in it before and am not sure where to begin.
Any help is greatly appreciated.
