All,
I have an Excel 2010 table named "Relationships" that contains columns A through AP with some columns having data validations and formulas. There is an ID column that identifies each row, a Person 1 set of columns, a set of relationship columns, a set of Person 2 columns, and a set of notes columns.
I need to break out the Person 1, Relationship/Notes, and Person 2 columns sets and situate them in three seperate worksheets that are dynamically updated from the main table. Each seperate worksheet will then have a CONCATENATE formula at the end of each row that is derived from the text in each column (I have the CONCATENATE down). I think this should be a combination of NAMED values combined with a HLOOKUP but for the life of me I can't get it to work. Help?
I have an Excel 2010 table named "Relationships" that contains columns A through AP with some columns having data validations and formulas. There is an ID column that identifies each row, a Person 1 set of columns, a set of relationship columns, a set of Person 2 columns, and a set of notes columns.
I need to break out the Person 1, Relationship/Notes, and Person 2 columns sets and situate them in three seperate worksheets that are dynamically updated from the main table. Each seperate worksheet will then have a CONCATENATE formula at the end of each row that is derived from the text in each column (I have the CONCATENATE down). I think this should be a combination of NAMED values combined with a HLOOKUP but for the life of me I can't get it to work. Help?