I am trying to pull data from a 108 sheet workbook where the last row varies on each worksheet.
I need to pull the data from the next-to-last line from column F (which I want to paste text only). and then numerical data from J:Q columns in the same row (which I want to paste as values), to the Worksheet("ByPrompt") in the same workbook.

I have my For .. Next loop up and working, but I'm struggling with pulling the data.

Can anyone provide a routine or help?