|You have said 2 very different things:|
re: "Yes, it is a simple, consistent, one-to-one copy like you showed above."
I showed an example of specific cells being copied to specific cells.
Calculator!B5 --> Quote!B14
Calculator!C5 --> Quote!C14
re: "The code should then put the data into the next available blank row on the Quote sheet range."
That is not the same thing as specific cells being copied to specific cells. Let's try an different example:
Let's say there is data in Calculator!B5 and the "next available blank row" on the Quote sheet is Row 20. It sounds like Calculator!B5 would be copied to Quote!B20. Now Row 20 is no longer blank, so where would Calculator!C5 be copied to? Quote!B21? Do you see my confusion?
It is still not clear, at least not to me, what is being copied to where. Keep in mind that we cannot see your workbook from where we are sitting, so you need to be very specific with your requirements.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.