I have a data range b37:dt47 which consists of information relevant to
11 different items. For now let's call the items a:k. I would like to be
able to populate an item's row of data/formulas based on inputting the
corresponding letter of the item in a cell. If I want the information for
item "b", currently I need to copy the entire row (38) and paste it in a
different location (let's say row 250). I would like to simply type "b" in a
cell in row 250 and for the data/formulas relevant to "b" to populate across
the new location. (cells b250:dt250)
I believe I could accomplish this with "If" statements in each cell
(after a few weeks of entering formulas) but I'm sure there must be a better
way.
Additionally, I can only hope that part of this formula could be used
to populate similar data from a drop-down selection in a seperate worksheet
in the same workbook.
Any assistance would be greatly appreciated.