Excel VB scripts RRS feed

  • Question

  • Hi,

    I am new to VB Script, and want to do some excel exercise.

    Here is a scenario:

    I have 2 excel file,

    Excel1 (source) has column A (id), B (name), C (date), D(capacity) say, I want to apply a filter on column B and column D based on some value.

    Now Col A has some ids based on the filter Applied.

    In Excel2 (Destination), has Col A (ids).

    Now I like to highlight Col A in Excel2 based on the filter value of Col A (ids) in Excel1.

    Anyone can help me with ideas how I can proceed on this?

    Tuesday, April 22, 2014 12:47 PM