Hope you can help
I am putting together a report for my month end meeting and it covers three sets of costs I have negotiated with three potential candidates to handle our freight
The data is OK but on the third sheet Id like to put together a simple SWOT analysis sheet based on the three candidates
What Id like to do is to have a drop down list (in D2) to select the desired Candidate and ‘pull’ the relevant data into each corresponding square. For example, in column V, I have Strengths against each candidate. When I select candidate 1, for example, Id like to extract the information from cells V4 to V10, into the Strengths section of the SWOT Model and display this in D5 to D16?
Ive tried methods of indexing and merging to try and get the block of data for each section to appear when the candidate is selected but to no avail.
I have attached the sheet (the sheet in question is titled SWOT) and I have placed the text in RED what Id like to see in the sections when the corresponding candidate is selected (ive used Candidate 1 for this purpose)
Any suggestions would be very welcome