vba macro to copy paste various various and return the result in a table

Yes it can be done. Please provide an example file as per the yellow banner above so we can assist you further

I just added the example workbook. I put the first few answers in column T to check to make sure it is right.

So the idea is:

1) Take S2 value, paste in last cell in column C
2) Copy last cell in column I to T2
3) Take S3 value, paste in last cell in column C (overwriting S2 value)
4) Paste new last cell in column I to T3.

I do not want to make the length of column C any longer. I just want to replace it with each new value, find the corresponding result in column I, and copy the answer to column T.

Here you go :

Please Login or Register  to view this content.

Thanks! It looks mostly good! Is there any way to have it stop at the last cell in S column? It keeps going past it on mine and I assume it just is pasting "0" over and over again as it goes past the last value in S

The code is stopping at the last 'active cell' in column S. Select all the cells below your last S value and delete those cells. The system is probably seeing these cells as 'alive with data, although blank'

I guess I still do not understand why this works. You are explicitly picking the last cell in column C, but I need to just find what the last cell is and pick that. This would not be useful across many workbooks with varying column lengths. Is there any way to generalize it so it just finds the last active cell in column C?

Please Login or Register  to view this content.

If that takes care of your original question, please select*Thread Tools*from the menu link above and mark this thread as SOLVED.

Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.