I have an excel document with multiple worksheets. The excel doc represents one "region" and each worksheet within it contains data (revenue, tenants, etc.) on a different "property" within that "region". For each worksheet that represents a property, there is a also a table that is based off of the property information with information on the % revenue, % area, etc for that property.
What I want to be able to do is take each of these tables from the different worksheets and combine them into one large table that represents the entire region.
I have attached a sample document with more text going into further detail.
Bottom line, I want to know if there is a way to combine separate tables (that take information from a set of data) and combine those tables into one large table.
Any help is greatly appreciated
Bookmarks