Thank you for your patience, am learning these new classes, so learning curve is a bit steep. I will read and try your link. All i want to do is, on the one worksheet the last row, the second work sheet data should go on the next. I only found out about this class today so please bare with me. thanks again.