Hi,

I am trying to copy a content of a cell located from one sheet to another sheet.

And the only way I know is to enter the = sign on each cell then go to another sheet on the specific cell I need the data to show then hit enter, which is time consuming as I have a number of cells to reference. Dragging the cell down will only copy all the cells and the series of rows which I still need to change the number of rows to achieve it and again it is very manual.

I wonder if there is a way where I can reference a range of cells coming from column and show it in a row?

Please see attached image of what I was trying to achieve.

Jan is located from Jan Sheet, Feb is located on February Sheet and Summary is located on Summary sheet.

I hope it makes sense.

Thank you in advance.

data in cells.png