If cells match then freeze (copy paste values) in each column in the workbook.

Hi,

I've inherited a macro that will prompt the user for a column letter; and then for each sheet in the workbook it will 'Freeze' (Copy/Paste xlValues) the chosen column.
Note: Not to copy the values from first sheet paste to each subsequent sheet, but to freeze the column in each sheet of the workbook according to the chosen column letter.

Please Login or Register  to view this content.

I'd like to make this process a little more automated.

In my worksheets each column header displays a date of the month. I also have todays date ("=TODAY()") in cell B2.

What would be nice would be if the macro could copy and paste the values in a column if the headers match the value in B2.
Hope this makes sense :S I don't know if this can be achieved with VBA but if anyone can offer a suggestion it'd be much appreciated.

Thanks.

Try:

Please Login or Register  to view this content.