I have a combo box that looks up a list with 29 objects through data validation. The combo box is filled from a sheet called 'Species list' with a range A2:A30. The combo box is located on a sheet called Step 2 in cell C5.
I would like the user to be able to select a specific object from that list and automatically copy whats in the cells on a sheet called 'dscombo'!C11:C20:G19 and paste the values from those cells into a sheet called 'Step 2'!C11:C20:G19.
The key point that I should make is that the range of cells to be copied and pasted will vary depending on what object is selected from my combo box.
In the range described above that I want copied and pasted, the user would have selected the first object from the list in my combo box.