Hi,

I am new to this...so please be gentle I have learnt how to share my workbook locally. I need to do this as two other people need to enter data on the database at the same time, so I need to merge the data into the master excel workbook at the end of each day. However I have gone through the steps but when the copied version of the workbook is opened up all the drop down lists I have created have disappeared! I need the info as drop downs so that the data is accurate. The data validation on the master is done via the data on a different sheet within the workbook - I dont know if that makes a difference? The copied versions have these other sheets too as the whole workbook was copied and saved not just a worksheet. I would be very grateful for any help with this.
Thank you