I have 5 rows with 10 columns. Below this 5x10 grid, I populate a cell with a value that is listed in column 1 of the grid. "ABC" for example.
If "ABC" is row 3, column 1, I want to them get the values in row 3, columns 4, 5, 6. Those three values will go into cells just above or below the "ABC" cell that is below the grid.
The value where "ABC" is will change, as I get info from different rows, but will always correspond to a value in column 1 of the 5x10 grid. Any ideas on how to do this?