Actively updating file from a shared file and have manually inputed data synchronised.

Hi Excel People,

I have created shared excel file entitled “Quote Register”. This keeps track of all the jobs that need to be priced and provide information on the jobs i.e. quote status, client, contract, value, etc. What I would like to generate is a new file (a jobs list) linked to the quote register. In the quote register file the A-column shows the quote status (Not Quoted, Quote Pending, Quote Approved and Not Approved). When the quote status is “Quote Approved” I would like the jobs list to be update, to reflect this. I need to manulally add information to the new job i.e. Sub Contractor, Estimated Time, etc. I have tried to do this without VBA and haven’t had success. The issue I am having is that I could have update a job by changing A200 to Quote Approved and tomorrow need to change A100 to Quote Approved. I need the manually imputed information on the “Jobs List” file to be on the (synchroised) same row as the information added from the “Quote Register”. I know this is a bit longwinded I hope it makes sense and hope it can be done. Any help is really appreciated.

Kindest Regards,
Del