Excel query to retrive the most recent record - Microsoft Community

have excel workbook several sheets. 1 sheet (clienttbl) set parent table , other sheets (each on separate tab) set child tables, i.e addresstbl, employtbl, etc... reason due nature of our contact clients, address change 1 contact next or change employer 1 contact next. within child tables, date , time information entered automatically upon entry of record. need create query create 1 current record each client , take advantage of pre-recorded date/time field report record each table recent. how go doing this? have put sample tables below

clienttbl

id	lastname	firstname  1	doe		john  

addresstbl

id	address			date  1	15 n. somewhere ave	11/1/2017  1	756 noplace ave		11/27/2017  

employtbl

id	employer	date  1	brown company	10/20/2017  1	orange group	11/21/2017  

desired query results:

id	lastname	firstname	address		date		employer	date  1	doe		john		756 noplace ave	11/27/2017	orange group	11/21/2017  

any can provide appreciated! thank you!!!

hi,

microsoft query works connector between excel file data source. if want data updated, need match string registry of database connected to. when string matches, can refresh see if there updates made source.

you can visit link: use microsoft query retrieve external data know how create query data using built-in wizard of excel.

let know if need more help.

Office / Excel / Other/unknown / Office 2016