Match header information

[Venkatesh s]

Hi All,

I have 2 workbooks having header information in both the workbooks, now i want to compare both header information across 2 workbooks.....the main thing here is I need to check both the header information are matching or not in 2 workbooks.

I think it is better to have macro 2 check the header information from both the workbooks. Please help me. Thank you in Advance.

Regards,
Venkatesh.

[kbkumar]

Hi Venkatesh,

Welcome to the forum. Try the below code:

Please Login or Register  to view this content.

Does that work for you?

[Venkatesh s]

hi kumar,

Thank you for your reply, but i have a problem while running the macro.

I have added your code into my excel vba under 'this workbook' and I have saved this with macro enabled. And after that I have opened my attachments workbook1 and workbook2 and also my workbook macro. I have run the macro but I am seeing '400' error. please help me where is the problem.

Regards,
Venkatesh.

[kbkumar]

Use the code in either "Sheet1" or "This workbook" setion of workbook1.xlsx.

Then open the workbook2.xlsx and run the macro from workbook1.xlsx....hope that works

Am at work so wont be able to upload the file I had worked upon until later today.

[Venkatesh s]

thanks kumar it's working perfectly.

Please let me know how to learn macros and if possible please provide me the material link or any documents, so that I can learn it.

Regards,
Venkatesh.

[kbkumar]

Glad it worked Venkatesh. If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

Re links to VBA materials, see below:

http://www.excel-vba.com/excel-vba-contents.htm

http://www.excelforum.com/excel-prog...materials.html

Hope you find them useful...

[Venkatesh s]

hi kumar, I have a problem with running the macro, even though the header information is same in both the excel files. I am getting the error has 'Run-time error '9':Subscript out of range'.Please look into this once and find the attached excel files. thanks.

Regards,
Venkatesh.

[Venkatesh s]

Hi All,

Can anyone please look into the above question know. Thanks.

Regards,
Venkatesh.

[kbkumar]

Hi Venkatesh,

You need to change the workbook name in the code when you try this in other workbooks. See the highlighted line in the code below:

Please Login or Register  to view this content.

Hope this helps...

[Venkatesh s]

hi kumar, thanks it's working now, I have one more question, for the above code always we need to change the current file name to run this header macro, instead of giving file name is there any possibility to run macro without giving file name.

like for example if I open two excel files it should automatically match the header information in both the excel file by running the macro instead of always changing the file name.

Please let me know if there any possibility to do so. Thanks once again for looking into this.

Regards,
Venkatesh.

[kbkumar]

Though complex, I think that could be achieved by creating an Add-In in Excel so that you can have the options to select 2 workbooks and ask the macro to compare the headings in both of them instead of making the file names constant...