How to import Excel related BOM-list content into a excel sheet in Excel-VBA?

How to implement a spreadsheet to do something more dynamic and recyclable for more user to use? By allowing the user to browse and import 2 excel related BOM-list files from the computer local drive into sheet 2/3 before i run the above code to find the differences?

Eg: Something like having two CommandButton's which can import all the excel BOM-list data information into sheet 2/3 without making any changes to the original? Be开发者_开发技巧fore running any comparison test and a reset button for removeing all the content in sheet 2/3?

Sorry for my poor command of English and explanation if its not clear to you. Thanks for your time/help in advance. :)

i still don't understand what you are looking for.

As far as i can read in your code, you are missing the workbook manipulation part.

You need to open the workbook you want to copy from with the open method as described here.

Then, you can manipulate the workbook and its content as you have done in your code and as described in this tutorial .