Trying to simplify and automate workbook management for a client with 10 to 12 separate workbooks (some with many multiple worksheets, large number of formulas, some ref to other workbooks, etc), plus various people maintain and update a workbook, then share. Plan to combine all to one shared drive and setup security to access. Should really be created in Access I believe but client wants to use Excel. What is the best way to approach and simplify all these workbooks?
Solved by C. H. in 19 mins