Copy only columns that have certain values

[offpiste1]

Hi,

I am completely new at this, but I have searched and attempted things for days and can't figure out how to get something to do all of the things I want. I have a worksheet with values that change weekly (sample, attached). The number of rows and columns may change as well. However, columns A, B, and C will always have date, name and location data and therefore must be preserved. Aside from the headers, the values in the columns from D onward will include only the numbers 0, 1, 2, or 3.

I need to copy the columns to Sheet2 and then delete all of the columns from D onward that do not have a 2 or a 3 in them. In other words, I need to always keep columns A, B, and C, and also keep any column (and all of its data) if a 2 and/or 3 shows up anywhere in the column.

I imagine there is even a quicker way to cherry pick the first three columns, as well as any other columns that have a 2 or 3 in them, and then paste them to the second worksheet. However, either approach will meet the need well enough.

Thanks in advance.

[AB33]

Try the attached.

[offpiste1]

Wow, that is a fast acting tool. It works well, and I cannot thank you enough. I honestly wish I could decode it, so I could tweak it, but I only sort of understand all of the statements.

In any case, when I run it, it is almost perfect - it has only a couple of issues for my needs.

1. I can't figure out why, but the column headings are not carried over to Sheet2. They are there in the sample you sent back, but if I add new columns and headers to Sheet1, the new headers don't come over.

2. Any columns that don't have a 2 and/or 3 in them are included as empty columns in Sheet2. I need to eliminate them altogether on Sheet2 as I'm going to use Sheet2 as the source for other worksheets, pivot tables, and some charts. I could use an example that I found online that will do something garish like total the values in a column and if it is less than 1, it will cut the whole column and move everything left, but it's not a very "elegant" solution and certainly would not match what you've got going!

[AB33]

Amended code: