Hi All, I have a macro in a rostering worksheet which copies overtime details in a range of data,("E8:H22") to another area of a worksheet ("Q100"), then adds the date from ("C6"), deletes blank rows and copies cells with data and inserts it at ("P8:T8"), this works fine if there is content in the cells however if there is nothing to insert it deletes previous content. The way I am doing this is probably taking the long way around, ideally I would like to be able to copy the details directly under ("P8:T8") with date, but I would be happy to know how to have the macro stop copying to ("P8:T8") if there is no content and move on. Thanks in advance, Ed
Please Login or Register to view this content.
Bookmarks