jcmathis821
New Member
- Joined
- Apr 26, 2017
- Messages
- 1
Hello! - My co-worker and I are stumped and could use a little help in solving our issue regarding mirroring a portion of a table to be poured into another sheet.
Example:
Sheet 1 contains the following columns which will need to be identical for many other sheets in the future. For now, I need to mirror 2 columns on Sheet 1 to Sheet 2.
Column 1: Community | Column 2: Apartment Style
Very basically, consider Sheet 1 as the database where the Apartment Styles and Communities are stored. The communities are fluid and there will be additions to both the communities and the apartment styles. Hence the reason why I need to mirror sheets to maintain consistent information between sheets.
Sheet 2 is a specific product type that needs to be installed into these Community/Apartment Styles. The only information shared between these sheets (for now) is Column 1 & Column 2.
But wait.... there's more....
Sheet 1 & 2 should really be sort-able. A table feature is entirely necessary. This is my roadblock..
Example:
Sheet 1 contains the following columns which will need to be identical for many other sheets in the future. For now, I need to mirror 2 columns on Sheet 1 to Sheet 2.
Column 1: Community | Column 2: Apartment Style
Very basically, consider Sheet 1 as the database where the Apartment Styles and Communities are stored. The communities are fluid and there will be additions to both the communities and the apartment styles. Hence the reason why I need to mirror sheets to maintain consistent information between sheets.
Sheet 2 is a specific product type that needs to be installed into these Community/Apartment Styles. The only information shared between these sheets (for now) is Column 1 & Column 2.
But wait.... there's more....
Sheet 1 & 2 should really be sort-able. A table feature is entirely necessary. This is my roadblock..
