Your tutorial was great. I am trying to modify it for my situation but I just must be a challenged individual. In the first column I have 30 rows of text called test steps. Every row is a unique test requirement and unique descriptor. In the other columns I have 34 different pieces of equipment in the header that these tests will be run on. They are listed across the top of the spreadsheet as a header. Each test has expected actions in the corresponding cell rows of that column. One for each test step. Some are merely text such as N/A but some are drop down lists. I am trying to create a spreadsheet (template) that lists the test steps in the first column as I have now but I would like to pick the equipment type in the second and remaining columns from a drop down list of equipment types. I have the drop down under control. I would like to auto fill the the test step requirements in the cell rows of each column. I used Vlookup in each cell… wow… it did the trick but it only placed the text in the appropriate cells but not the drop downs. Drop downs had zeros. 0 as the result. I loved your method but can I do the same in this instance and bring over the drop down test requirement as well. Thanks in advance.
Your tutorial was great. I am trying to modify it for my situation but I just must be a challenged individual. In the first column I have 30 rows of text called test steps. Every row is a unique test requirement and unique descriptor. In the other columns I have 34 different pieces of equipment in the header that these tests will be run on. They are listed across the top of the spreadsheet as a header. Each test has expected actions in the corresponding cell rows of that column. One for each test step. Some are merely text such as N/A but some are drop down lists. I am trying to create a spreadsheet (template) that lists the test steps in the first column as I have now but I would like to pick the equipment type in the second and remaining columns from a drop down list of equipment types. I have the drop down under control. I would like to auto fill the the test step requirements in the cell rows of each column. I used Vlookup in each cell… wow… it did the trick but it only placed the text in the appropriate cells but not the drop downs. Drop downs had zeros. 0 as the result. I loved your method but can I do the same in this instance and bring over the drop down test requirement as well. Thanks in advance.