ExcelBanter - how do i design a template with one to many relationship in excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how do i design a template with one to many relationship in excel (https://www.excelbanter.com/excel-discussion-misc-queries/121606-how-do-i-design-template-one-many-relationship-excel.html)

Ram

how do i design a template with one to many relationship in excel

Hi,
I have a requirment to design a excel template with one to many relationship
in an hierarhical format.
Ex: An ID can have many attributes, which can again have childs and can grow
as the year progresses

I dont want to use 2 different worksheets. Can any body suggest me?

All times are GMT +1. The time now is 05:25 AM.