Hi,
I have an excel spread sheet with a drop down function in Sheet1 cell A2.
In Sheet 2 along Row 1 I have titles of systems running across the page. Under each title there are a number of names beneath each.
The drop down in cell A2 in Sheet1 corresponds to the titles in Sheet 2.
Essentially what I would like is whatever I select in the dropdown in Sheet 1 the names beneath that specific title in Sheet 2 would show in Sheet 1 in Cell A3 downwards. However when the names appear in Sheet 1 I need them to be in a Paste Value format - basically I don't want formulas in the cells in Sheet 1. I believe the only way to do this is a Macro but I am unsure.
The formula I am currently using in cell A3 downwards is:
=INDEX(Sheet2!$B2:DJ2,MATCH($A$2,Sheet2!$B$1:$D$1))
However this of course is a formula and is not Paste Values which is what I need.
Any help would be greatly appreciated. Thank you in advance.
I have an excel spread sheet with a drop down function in Sheet1 cell A2.
In Sheet 2 along Row 1 I have titles of systems running across the page. Under each title there are a number of names beneath each.
The drop down in cell A2 in Sheet1 corresponds to the titles in Sheet 2.
Essentially what I would like is whatever I select in the dropdown in Sheet 1 the names beneath that specific title in Sheet 2 would show in Sheet 1 in Cell A3 downwards. However when the names appear in Sheet 1 I need them to be in a Paste Value format - basically I don't want formulas in the cells in Sheet 1. I believe the only way to do this is a Macro but I am unsure.
The formula I am currently using in cell A3 downwards is:
=INDEX(Sheet2!$B2:DJ2,MATCH($A$2,Sheet2!$B$1:$D$1))
However this of course is a formula and is not Paste Values which is what I need.
Any help would be greatly appreciated. Thank you in advance.