EEK. You want a macro to put what could be randomized information from the Availability sheet into a Daily sheet, then you are going to manually add data to the Daily sheets? You see how out-of-sync that will get with even the smallest "update"?