Originally Posted by WiredGuy

Hmmm, I should add that this should be done by formula rather than copy/paste and using filters. This is a task that would need to be repeated on a daily basis so I'd rather just pull the data from CSV and try to automate this as much as possible. I'm hoping to not have to copy/paste columns and do manual filters. I was more or less hoping I could just drop a formula or macro to do the job.
WG