I've created a spreadsheet for my cruise inventory thought it would help keep track as a new travel agent first time really using excel in depth. I have two sheets, Active Groups and Sheet1 bother headers are the same. In Active Group i have headers A9-T9 and the data range is A9-T400. In Sheet 1 the header starts A1:T1. In bothe sheets E (Named: Book By Date) is conditionally formatted to =TODAY() is there a way to transfer the data of that row when the date is TODAY? So when the date expires copy to sheet1 and delete from Active Groups.