MACRO/CODE

[Beginner613]

HI ALL,

Can somebody please help me. I have 2 excel spreadsheets. I want to create a form which will have a button. By clicking on this button it will take 1st excel sheet and put it in one table, 2nd spreadsheet in another table. And finaly third table would show me records that are similar in both tables. Is it possible to do with one click of the button? Macro? Any code..
Thank you guys in advance,

B

 

[SkipVought]

Hi B,

What is the purpose of the tables? We already have 2 sheets (Tables) and can do the comparison.


The rows that join in an inner join are identical. Do the query on sheet 3.




Skip,

_[red][/red]

 

[Beginner613]

how?
What should me the code?

 

[SkipVought]

Do you know how to joint two tables in a QBE grid? No code writing required

Skip,

_[red][/red]

 

[SkipVought]

Do you know how to joint two tables in a QBE grid? No code writing required.

Use Data/EGet External Data/New Database Query...

Excel Files -- YOUR WORKBOOK. The tables are your SHEETS.

Skip,

_[red][/red]