Hi Gurus,
I am trying to Join 2 tables together from 2 different sheets on Excel (but they are in the same workbook) - any idea how I can do this via VBA code?
I can do this on a basic SQL query which would look something like:
Select Columns A:F in Raw Data 2 sheet & Columns A:D in Matrix sheet
From Raw Data 2 sheet
Inner Join Matrix sheet
On Raw Data 2 ID (which is Column A) = Matrix ID (Column A)
For both sheets - A2 is column headers, and row 3 downwards are the data values for each column
How could I do this on Excel VBA where the data would be joined into a new tab called Consolidated Data? Any idea?
I am trying to Join 2 tables together from 2 different sheets on Excel (but they are in the same workbook) - any idea how I can do this via VBA code?
I can do this on a basic SQL query which would look something like:
Select Columns A:F in Raw Data 2 sheet & Columns A:D in Matrix sheet
From Raw Data 2 sheet
Inner Join Matrix sheet
On Raw Data 2 ID (which is Column A) = Matrix ID (Column A)
For both sheets - A2 is column headers, and row 3 downwards are the data values for each column
How could I do this on Excel VBA where the data would be joined into a new tab called Consolidated Data? Any idea?