I have written the below code and it all works bar one bit! The range on the form is I10:R12, and when I put this in, rather than a single cell, it does not like merged cellls. (At present I have just left this in the code as I10). When I run it, this stops as it doesnt like transferring the data from cell C8:d8 on the checks sheet, to the I10:R12 cell on the form page. Due to other information on both pages, I cannot change either cell size.
Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member. I also recommend using indentation to show the structure. --6StringJazzer
Bookmarks