Basically at work i'm doing countless databases for call logs etc and i want to cut down repetative input with either conditional formatting or a macro (whatever is easier)
so what I want is IF column G contains the words "CB 24/06/11" for example to copy the date "24/06/11" into the Callback date column H and I want to do this for the entire column respectively.
sorry if this sound a bit confusing... Haven't used excel in years and have got the hang of using conditional formatting to highlight rows with relevant colours dependant on the data inputted again saving time, so this would be of great help.
here is a rough demo to give you an idea I hope this will help.
cheers.
oh and to note these are freely available sources off yell.com etc etc so don't flame me for data protection I have included these as a brief example...


LinkBack URL
About LinkBacks
Reply With Quote

