I have a requirement to create a Excel spreadsheet that will need to lookup cells and update cells in a remote master sheet. the sheet will be held locally on laptops and the master sheet is located on a server. (i will be adding further functionality later, ie emailing suppliers to order services etc)
i have done a basic layout and some formulas but i do not know how to link and update the master sheet.
Also is it better (easier for me) to use a vlookup for the information i require from the master sheet or would some VB code be quicker?
The is a unique referance (Site_ID)