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
Bookmarks