Forum Discussion
Overseeing multiple commercial locations with Excel
Hello All! I need some Excel help!! I work with a company who has recently expanded exponentially, and I am now in charge or organizing on the back end, about ten different locations. I want a pl...
What would be the best way to do this? Put a header for each column with the address, owner info, contacts info, and the info for each location along each row - all in one tab? and run reports from there? Or in different tabs?
First, use structured tables Overview of Excel tables (microsoft.com), not ranges.
If for the locations you have some additional info to use in reports, better to use location ID (it could be unique name of the location, index, whatever) in main table and add another table with info for locations (using same ID). For reporting you may build relationship between above tables using location ID or combine them together in data model, depends on which tools to use and which kind of reports are required.