Copy Conditional Selections and Paste in Empty Cells Specified

[smciesl2]

Hi! I have been working on a macro that looks at a table on another worksheet, and selects certain cells based on the criteria provided in the code. I would like for the information to then be pasted onto a new worksheet, however I cannot find a way to write the code that will start on row 92 and list it on down until the identified selections have been all listed. Anything online is using the END.(xlsup) funtion which puts it at the end of all the data on the worksheet (which again will not work as there is data that continues after the area I would like this information posted to). I tried a for loop, but then that just repeated the next value found in the orginial list several times... I am not sure what to try next :S thanks for the help in advance!

Below is the code:

Please Login or Register  to view this content.

[smciesl2]

any thoughts?

[smciesl2]

Ok I am getting closer just playing with it, but I still have an issue of repeated values. When the rCell value is pasted into wb2 it is repeating all the way from row 93 to 102. How can I stop it from duplicating? Here is my updated code:

Please Login or Register  to view this content.