I have a matrix A1:AY51. B1:AY1 has headings. A2:A51 has headings.
I'm trying to see if there's a way to have a drop down for all the cells in the matrix dependent on the respective row and column header.
For example: Cell B3 could be selected as either B1 or A3, Cell C4 could be either C1 or A4, etc.
I have done some research, but haven't come across any formula or VBA that would facilitate this.
Thank you in advance for any assistance.
I'm trying to see if there's a way to have a drop down for all the cells in the matrix dependent on the respective row and column header.
For example: Cell B3 could be selected as either B1 or A3, Cell C4 could be either C1 or A4, etc.
I have done some research, but haven't come across any formula or VBA that would facilitate this.
Thank you in advance for any assistance.