• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

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

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.
 
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
 

Attachments

  • tryout.xlsm
    15.2 KB · Views: 2
Hi ,

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

Narayan
 

Attachments

  • tryout.xlsm
    16.9 KB · Views: 18
Back
Top