Macro/Function to search another workbook then update to it appropriately

[Snowboyd]

Hi there

I have reach the stage where I am simply stuck in resolving a problem. I have a workbook 'main spreadsheet' that is updated consistently, mainly by the same person, with details of enquiries that have been received in and who they have been allocated to.

When a sale comes in I want a number of other users to be able to query 'main spreadsheet' to see if the sale has resulted from an enquiry and, if so, update what type of sale (or sales) have been made to the 'main spreadsheet'.

The problem is that I do not want to use a shared workbook and risk corruption. One potential solution I have considered is in two stages:

Stage 1: a function/macro in a new workbook ('lookup enquiries') that first searches for a clients name in 'main spreadsheet', and returns the possible matches to check, including a unique reference number

Stage 2: a second function/macro in 'lookup enquiries' that enables the user to enter the unique reference number, the number of sales for each product type (i.e. a number for column Product 1, Product 2, Product 3 etc) and update this information to 'main spreadsheet'.

Many thanks in advance