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.