Snowmonster
New Member
- Joined
- Aug 25, 2011
- Messages
- 43
Hi all...
I was just wondering if there was a way of searching a named range for a certain criteria, and adding new values into a mirrored range next to it. The columns will have dates (i.e. 2nd, 3rd, 4th, etc) at the top, and the populated cells will have the word holiday in them. In the mirrored cell, I would need it to read a value (1, 2 or 3), depending on the date... Possible?
Cheers (Formula or Macro)
Snowmonster
I was just wondering if there was a way of searching a named range for a certain criteria, and adding new values into a mirrored range next to it. The columns will have dates (i.e. 2nd, 3rd, 4th, etc) at the top, and the populated cells will have the word holiday in them. In the mirrored cell, I would need it to read a value (1, 2 or 3), depending on the date... Possible?
Cheers (Formula or Macro)
Snowmonster
