![]() Surely Excel has an easier way to do this? ![]() Therefore, I have to delete and re-import every morning, losing all of my formatting. Right now I'm relying on import external data, but that doesn't update. I'd like for these sheets to automatically update if/when changes are made to the master - but keep my formatting intact. I've made a workbook with 7 different sheets, each tab named after one of the network databases. I've tried doing the share workbook, but it's not working. I rarely have to edit, so if I'm first then I'll invariably be asked to exit so others can update them. The first person to open a file will get edit mode, the others will only get read-only mode. Any changes that need to be made are made. These are contact databases for clients, insurance companies, our agents, etc. There are 7 files on the network that everyone updates. I thought I was intermediate, even advanced, until I started coming here! Unfortunately, I'm basically an Excel Dummy. ![]() I've searched through the forums here, and some of the answers come close, others assume I know the prerequisite's.
0 Comments
Leave a Reply. |