Copy/Paste Values from Variable Range to Corresponding Variable Range

Hello. I'm new to this forum, though I have used it on many occasions to solve some of my VBA troubles (as I'm a VBA novice and have tried to learn from those far more sophisticated than me). For the problem at hand, however, I haven't been able to piece together a solution after mining many message boards. I've seen many similar problems, but nothing yet that satisfied all of the conditions of my problem.

The problem: I'm trying to write a macro that will copy values from a named range that meet a condition where the range is in a column containing many rows on the "Export Draws" tab (copy range), and paste those values to a named range on another worksheet where the range is in a column containing the same number of rows on the "Projections" tab (paste range). I need to do this up to 39 times, although my ideal solution will copy all "copy ranges" to the corresponding "paste ranges".

Additionally, if the copy condition is not met (also each named range [a one-cell trigger] on the Export Draws tab). The condition is met if trigger is = 0 (or if = 1, then next).

I've attached a worksheet to (hopefully) illustrate better what I'm talking about.

Though I know I need to set variables, and run a loop I am completely stumped where to begin, so haven't even begun to write any code.

Any help you all can provide will be enormously helpful - Thank you in advance.

Attachment 155431

Jbeaucaire - you are correct that the sample doesn't include named ranges (it's just a sample copy from the sheets that I'm working with, and didn't want to go through the naking process again). In any case, I am using named ranges so that - should I need to add rows, I wont have to revise the macro once written. This may be an inartful solution.

I'm curious if you have any suggestions to begin writing the code - since this is where I am sincerely stumped.

Thanks.

(1) What is the name & address of the named range?
(2) Under what conditions do you want to copy values?
(3) Where do you want these values copied?

Originally Posted by JBeaucaire

Unanswered from post #2:



What do you think?

Yes that sounds correct - named ranges aren't necessary and the references look correct too.

I am re-posting the sample worksheet given the questions about named ranges. Thanks everyone for looking at this.

Thank you Jbeaucaire. Truly wonderful solution! Thank you very much! I had been thinking of named ranges as the solution, but you proved not necessary. I tested in the sample and original workbooks, and so far it's working perfectly. Learned a lot as well. I'm still unclear about the syntax you used, but as I said - VBA novice.