Hey,
So - I've been an Excel user for years (Working only with functions) and a web programmer for years (Working with PHP and MySQL) and have been recently given the title of "The guy who needs to learn VBA to keep his job". I'm getting the hang of it but got stuck and am hoping this (Seemingly awesome) community can help out.
I've been tasked with creating an excel project (My boss calls them programs) that can run a bunch of comparisons across multiple CSV files. Most of the comparisons (Is this cell the same as this one?) are a snap. Each csv (Which we're having users copy/paste onto Sheet2 and Sheet3) has upwards of 20k rows - but are united via a single column with a "uid" row. Edit: I've uploaded a sample dataset. Data is in Sheet2 and Sheet3, manually curated output is in the 'Output' sheet.
What I'm looking to do is pull specific data from the rows - but ONLY where UID matches. Sorting by UID then assuming row numbers line up won't work -as some of the CSVs contain more rows than others (I've included this variable in my sample).
Essentially, I need a "Dump values of Sheet2, Columns B, C, D and Sheet3 columns A, B, D to Sheet4 when the values of the data in Sheet3, Column A and Sheet2, Column C match.
Any help would be greatly appreciated.