If Cell = "Yes" Paste entire column as values

[mindgutter]

Hi Guys,

Trying to write something that will paste an entire column as values if the value in row 5 equals Yes.

This is what I'm running with but so far no luck I've got it to copy and paste the entire column regardless of what value is in F5 and I've also got it to simply copy the active cell.

Please Login or Register  to view this content.

If possible I'd like to be able to loop it through F5 to AU5

Thanks for the help

[benishiryo]

hi mindgutter, welcome to the forum. if you are putting VBA codes, please use this

Please Login or Register  to view this content.

[mindgutter]

Thanks updated my original post to etiquette of forum

Please Login or Register  to view this content.

If I leave in

Please Login or Register  to view this content.

It simply ignores the second part and does not paste the values I checked this in the console it was jumping from

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

and back again.


If i remove

Please Login or Register  to view this content.

then it will cycle through each column and paste as values.

[mindgutter]

I changed the "Yes" to "1" and changed all my Yes values to 1 on the spreadsheet and it works.