Forum Discussion
Need to create Master Spreadsheet w/ Directory Referenced.
Currently, at work, we use several spreadsheets to compile similar data. We are opening a new office, so I'd like to start fresh with a workbook that would have a master sheet and then department-spe...
Hello,
Based on the attached workbook, I discovered that the Workbook Design isn't the "Excel way" of designing a workbook...
You dont really need columns up to AD... You only need about 10 or less columns with all data filled properly... Then, you can have the Master sheet where you can PivotTables or functions to achieve what you desire to achieve
Based on the attached workbook, I discovered that the Workbook Design isn't the "Excel way" of designing a workbook...
You dont really need columns up to AD... You only need about 10 or less columns with all data filled properly... Then, you can have the Master sheet where you can PivotTables or functions to achieve what you desire to achieve