Looking for help or guidance on a potential Macro project

[Fiddler1993]

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.

 

[Rijnsent]

Hi Fiddler, welcome to the forum.
A starting point: Excel VBA Programming - a free course for complete beginners -> see lesson 1.3, the macro recorder (do check out the other lessons too).
Next, do some of the steps you'd like to do manually and see what code gets recorded.
After that, edit the code and try to run it... When you do, do check this mini debugging manual: Debugging in Excel VBA . Basically: Run the code with F8, so you can step through it step by step instead of running it all at once (F5/the play button).
The macro recorder is a simple first step, but that code needs quite some editing. You could ask CoPilot/ChatGPT or this forum for help if you get stuck.