The destinations still aren't clear - if I'm copying f10 to J16 and f20:j20 to sheet 5 (for example), what cells do they land in? I took a guess, and just arrayed your information across the row. Try the procedure below out and see if it works. You'll need to put your headings for sheets 5 and 6 in Row 1 and you'll need to tweak the formats on sheets 5 and 6 to your liking, but it should cleanly transfer your data across the rows. I tried to leave the structure of the VBA pretty clear so that you could make modifications as necessary. Let me know how it goes.
Bookmarks