hello, i am a newbie and have a question. i've only ever used excel for budgetting, but now find i need in my 'revised' role, that i need to use excel to 'track' data that is 'repeated' in a bi-annual - a whole new world for me!
my question is, can excel 'track' or 'find' like data in a cell (in two different spreadsheets) and also highlight them for me. if so, how do i do this?
many thanks in advance for anyone's help,
sallyz.