Combined CSV files

S

SantoMillennial

New Member
Joined
Feb 1, 2024
Messages
1
Office Version
  1. 365
Platform
  1. Windows
This might be very easy for one of you but I can't anymore, I am not that expert in Visual Basic. I'm trying to make a new file that asks with a button for two files. Both have vehicle information, one in column A and the other one has same information in column B (as the images show). The new file should contain a button that asks for the first File (the one that has only one column) and the file 2 (the other one), then should compare both columns and remove duplicates and create a new csv file with only the unique vehicle information.

Can someone please help me. Thank you so much.
 

Attachments

  • Capture1.JPG
    Capture1.JPG
    69 KB · Views: 12
  • Capture2.JPG
    Capture2.JPG
    36.4 KB · Views: 12

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.
You must log in or register to reply here.

Similar threads

S
  • Question Question
Merge two table from different csv files
2 3
Replies
24
Views
668
Soly_90
S
P
  • Solved
VBA to insert filename in a new column for all files in a folder
Replies
2
Views
131
psion2600
P
D
  • Locked
  • Question Question
VBA to copy only matching data from 2 csv workbooks into the "Master Workbook"
Replies
1
Views
338
RoryA
RoryA
D
  • Solved
VBA to copy only matching data from 2 csv workbooks into the "MasterCSV"
2
Replies
18
Views
949
Peter_SSs
Peter_SSs
B
  • Solved
VBA to read 1 line at a time from 2 CSVs and write them sequentially to the active workbook
Replies
8
Views
485
BakerSteve
B

Forum statistics

Threads
1,224,814
Messages
6,181,121
Members
453,021
Latest member
Justyna P

Share this page

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