hi, i have five tables in an excel all are text fields. two tables are results of the first five tables. i mapped all the tables by use of lines. there are so many mappings. so i'm confusing. is there any formatting to highlight the table coumns if i click on the resultant table cell. for example:
i have a TABLE A, which is having 2columns and 10 rows. similarly i have TABLE B, C and D. i have a TABLE E. all the cells are TEXT fields. no formulas. the cells in TABLE E is based on the cells in A or B or C. when i click an cell in TABLE E, i have to highlight the cell in TABLE A or B or any dependent table cell.
hope you understand. this is like database table columns. like database mapping. is it possible to do in excel. we can do it for formulas. can we do for text. is it possible. please suggestions. thanks in advance. [email protected]
i have a TABLE A, which is having 2columns and 10 rows. similarly i have TABLE B, C and D. i have a TABLE E. all the cells are TEXT fields. no formulas. the cells in TABLE E is based on the cells in A or B or C. when i click an cell in TABLE E, i have to highlight the cell in TABLE A or B or any dependent table cell.
hope you understand. this is like database table columns. like database mapping. is it possible to do in excel. we can do it for formulas. can we do for text. is it possible. please suggestions. thanks in advance. [email protected]