Aug
04

How to update excel data according another data source?

Have you met this issue? You download your data from web or export the data from another data source. Then import them to excel. But you want to update the data in excel later. Is there a way to make this happen? VBA must be used. Suppose column A is a unique ID of the… Continue reading »

Aug
04

How to diff two columns in excel.

Some time want to diff two columns in excel. How to make this happen? Following VBA code can help you to do this. It will diff column A and B, Column B will be reordered in column c. ‘sub must below pulic, otherwise error happen. Sub ColumnDiff() Application.ScreenUpdating = False ‘Set cc = Selection ActiveSheet.Range(“C:C”).Select… Continue reading »