VBA Copy Paste Value From Certain Word

[luke1438]

I want to copy paste value to sheet 2 (a different sheet then where this table sits) everything in columns “R” through “U” from the word “Income” in Column “T” down to where there is a 0 (Zero) in Column “T”. Any suggestions would be helpful. My VBA experience is using the macro recorder and I cannot figure out how to use that because this data is always changing.

Thanks
Luke

 

[Peter_SSs]

Code is below with some minor tweaks:

I have changed the 'Mark as solution' to post 5. The option Explicit in that post was not a mistake and the poster was not to know that you would put the code in an existing module that already had such a statement. Also, although the code works for you without 'Public', it would also work with Public so again that was not a mistake in post 5. Essentially, post 5 provided the solution requested.