VBA to copy certain columns based on a cell value

[JED76]

Hi

I am new to VBA and wondered if anyone can assist?

I have a table with various columns. I would like a button to check for the presence of "YES" in say column S and if it's there, copy the contents of certain columns to another sheet within the workbook. The destination does not require all columns. Also, I wouldn't want it to duplicate if some rows had already been copied. For example, if the user added "YES" to a few more rows and they hit the button again, I would only want the new rows / certain columns copying over.

Many thanks!

 

[mumps]

It would be easier to help if you could use the XL2BB add-in (icon in the menu) to attach a screenshot (not a picture) of your sheet. Alternately, you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary).