Good day to all. I am looking for some advice on data entry. The company I work for uses Excel 2003 to track purchase orders, repair orders, stock items, and parts being supplied by our customers. We call it our Master Passdown workbook. This book contains tabs for each month. Each month contains hundreds of lines of data for multiple customer projects we are working on. Right now my boss is inputting all information twice. We have to break the Master Passdown into individual workbooks for our customers in order to keep them in the loop about their project. I am trying to come up with a way to avoid the duplicate work. I know no one here likes the idea of a shared workbook and I am open to other suggestions, but the Master needs to be available for update by multiple users at the same time. We have two purchasing agents, a receiving clerk, a shipping clerk, myself and my boss that would all be using the file. I have created an excel file, with the help of several people on this forum, that is very close to what I want. Unfortunately, it won't allow multiple people to use the file at the same time because of a macro that is used on it. The macro is assigned to a button that anyone would use to enter a new line into the sheet. The reason I am doing it this way is because several of the columns have formulas in them and instead of having a bunch of semi-blank rows with the formulas pasted in them waiting on the next entry, I wanted to use a button that would automatically add the next line with the formulas in it. The macro works great. But, as soon as the workbook is shared the macro no longer works. I am able to make the macro turn off sharing add the line and then turn it back on, but that would constantly kick everyone out and cause mass confusion. I am trying to be as descriptive as I can about this, but I am sure if anyone has any ideas there will still be questions. Any ideas on what I can do?