Hello all,

I have been searching and reading threads here for two days, trying to find solution that I could modify. I am very rusty at vb, been years since I have had to incorporate it.

I have a workbook, two sheets (All, AIM). I would like to copy entire column from 'All' worksheet to 'AIM' worksheet if cell value in in C2, D2, E2, etc is text value AIM. The cell value will always be in Row 2, Column letter will obviously increment alphabetically as I enter the future raw data in next open column in 'All' worksheet weekly.

If 'All' worksheet C2 says AIM, copy entire Column C, paste in next blank Column in 'AIM' worksheet....same for D2, E2, etc.

Thank you so much for any input!