Copy cell content from one sheet to another cell in a different sheet

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

Many things are possible, specially if you attach your file for us to test ideas, or in another words, help us to help you.

Hi,

Thank you for looking into this.

Please find the attached sample.

If the answer isn't what you want, try to make a better example.

Formula:

=TRANSPOSE(INDIRECT(E4&"!B3:D3"))

Hi everyone,

Thanks for all the help. It is greatly appreciated.

@AliGW it is working but I still have a lot to change to get the result.

@DJunqueira yours look great, but I can't get it to work and it gives me an error of either reference error or spill error. I wonder what I'm doing wrong.

Thank you.

Originally Posted by sickreto

@DJunqueira yours look great, but I can't get it to work and it gives me an error of either reference error or spill error. I wonder what I'm doing wrong.

For the help to work properly it is like a dance, you need to provide us with a good feedback, I also don't know why it is not working.

Thanks for your reply everyone.

@AliGW the formula is working very well except that I still need to change a lot sheet reference which I can only assume is the only way. I do copy pasting of the formula on each column and change the reference which is a lot less than my previous steps. Unlike what DJunqueira's approach to the formula which would be ideal as there is less changing of the reference by months.

@DJunqueiraI will keep on trying to find where and why there is an error. If needed, I will re-post.

I appreciate all your help. Thank you.