Hi, Could you please help to have a short macro to search the sharepoint list for a given ID, and lists selected fields and the URL of the sharepoint list item.
You can use ADO to pull data using VBA in Excel.
Or you could use an older set of SOAP services to pull data.
http://depressedpress.com/2014/04/05/accessing-sharepoint-lists-with-visual-basic-for-applications/
Both of these are starting points to get data and then in the VB you could add a filter based on a cell.Â