is there a way i can get excel to automatically copy a cell (when it becomes highlighted due to a conditional format) to a separate worksheet?
is there a way i can get excel to automatically copy a cell (when it becomes highlighted due to a conditional format) to a separate worksheet?
Marc,
I reckon you should be looking under programming for this, for a macro which starts when a cell equals a certain value.
Try this one for starters: http://www.excelforum.com/showthread...ght=activecell
Cheers,
Chris.
Big Chris
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks