Question about Chandoo example macro: Consolidate data from different excel files (VBA)

[Scottie]

Hi ,

See this revised file. The header labels will have to be in row 1.

Narayan

I have an extended question. I realize this code will find only one column of "Supplier" whereas there are situations where the condition "Supplier" happens in more than one column. I tried to change the code but I failed. Sorry to bother you.

 

[NARAYANK991]

Hi ,

See the attached file.

Narayan

 

[Scottie]

Hi ,

See the attached file.

Narayan

It works perfectly. To train myself to be better in VBA, I tried to alter this program to make it read by rows.However, I failed. I tried error checking but still I cant find the error. May I ask for your help to help me see where my error is? Thank You very much.

Regards,
Scottie

 

[NARAYANK991]

Hi ,

See the attached file ; make the necessary changes in the code before running it.

Narayan