Hello All,
I have a spreadsheet with almost 10,000 entries, and more are added daily. I'm currently using conditional formatting in columns A and B to check for duplicates and highlight them. The columns have separate sets of data and must be checked independently. I have data in columns A - K but only A and B need to be checked.
This spreadsheet is understandably very slow to respond to any input so my question is this: would using a macro to highlight these same duplicates help reduce the lag I'm experiencing, and if so, does anyone feel like helping a total VBA n00b with the macro?
I have a spreadsheet with almost 10,000 entries, and more are added daily. I'm currently using conditional formatting in columns A and B to check for duplicates and highlight them. The columns have separate sets of data and must be checked independently. I have data in columns A - K but only A and B need to be checked.
This spreadsheet is understandably very slow to respond to any input so my question is this: would using a macro to highlight these same duplicates help reduce the lag I'm experiencing, and if so, does anyone feel like helping a total VBA n00b with the macro?
