Greetings!
An Excel question. I have data in cells in a column that are the product of a calculation using data from cells in other columns in the same worksheet. I want to copy the selected cells from the column to a series of cells in one row on the same worksheet. I want the cells that are copied to the row to be linked to the cells in the column so that a change in the value of a cell in the column is automatically changed in the corresponding cell in the row.
I have tried to use the Copy and Transpose function but it doesn't seem to work in the situation where the cell value is a product of a calculation. Is there a way I can do this without doing a Copy and Link one cell at a time? I have attached a sample spreadsheet to illustrate the question.
I am using MS 365 Family on a Windows 10 PC. As a note, my level of Excel expertise is modest!
Thanks for any help.
