Fiddler1993
New Member
- Joined
- Nov 5, 2024
- Messages
- 1
- Office Version
- 2010
- Platform
- Windows
I am trying to create a macro where I can open the main workbook which will have the macros in it. I then want to be able to go and select two separate workbooks and import the data in the work books from a button click and compare all the data in Colum A only, and finding the matching data. I then would like to see it save the matching data separate from the workbooks. I don't want to have this file specific but where I can pick and chose what files I want to compare. I would also later on like to figure out how to clean up the information in Colum A by deleting unwanted special words. Any help or guidance or even a point in the right direction would be great. I will be utilizing .CSV files when I am doing this. I uploaded an example of two files that I will be utilizing. I changed some of the data as it is sentive data.