Looking for help or guidance on a potential Macro project

Fiddler1993

New Member
Joined
Nov 5, 2024
Messages
1
Office Version
  1. 2010
Platform
  1. 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.
 

Attachments

  • test 1.PNG
    test 1.PNG
    11.7 KB · Views: 2
  • test 2.PNG
    test 2.PNG
    9.1 KB · Views: 2

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

Forum statistics

Threads
1,223,532
Messages
6,172,878
Members
452,486
Latest member
standw01

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top