VBA macro for matching and copying cells

[bizzarofen]

Hi,

I am trying to create a little bit complicated VBA macro, which will match and update data based on a few logical conditions across two workbooks

Ideally the macro will match the worksheets names from file Months with values in column A in workbook Summary.

In case the value in cell C24 of Months is Y the string "Pass" will be populated to an appropriate column in row 13 of Summary workbook based on current month (J2).
In case the value in cell C24 of Months is N the string "Fail" will be populated to an appropriate column in row 13 of Summary workbook based on current month (J2).

I'd appreciate some help. Thanks.

[Arkadi]

Will both workbooks be open at the time, or does the code need to open the "other" (presumably Months) workbook? Is the code supposed to be in the Summary workbook?

[bizzarofen]

Hi Arkadi, I suppose it'd be more convenient if the code opens the Months workbook. And ideally the code will be placed in Summary workbook.

[Arkadi]

Ok, here is code for the Summary workbook.... you will just need to adjust the path for the Months file:

Please Login or Register  to view this content.

[bizzarofen]

Thank you so much Arkadi, that's just brilliant.