Problem with pasting information

[GmanJP]

Hello, I am attaching a spreadsheet to try to explain my problem.

I'm trying to copy data from one sheet to another, neither CTRL+C / CTRL+V is working, nor is putting an = in one sheet and selecting cells in the other sheet.

The problem is clearly in the fact that one has 1 line and the other 4 lines, that is, there is an overlap and it ignores information.

Appreciate any help!

TEST.xlsx

[AliGW]

There is no 2020 version of Excel - which version do you have?

WHY, OH WHY have you merged rows on that first sheet instead of just draging the rows to be deeper? Get rid of merged cells for starters.

[GmanJP]

My Excel version is Professional Plus 2019.

I will not increase the cell size as this cell will bring important information later, and the entire worksheet is interconnected through formulas. As you can see in the spreadsheet that I leave attached at the moment.

test2.xlsx

[AliGW]

Administrative Note:

Members will tailor the solutions they offer to the version of Office (Excel, NOT Windows) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your version is for Mac, please also state this.

The three most recent versions of Excel are Excel 2019, Excel 2021 and MS365 - if you are using MS365, please give this name along with the release number in your profile (e.g. MS365 Version 2211). This is in the About Excel section further down the Account page.

Thanks.

[AliGW]

I will not increase the cell size as this cell will bring important information later, ...

And I will not work with unnecesarily merged cells - sorry.

[GmanJP]

OK, I appreciate your attempt.

[GmanJP]

Can someone solve it? Appreciate it

[GmanJP]

Waiting for a solution

[AliGW]

The thread has had 112 views since the day before yesterday, and you have no further suggestions. Reasons for this could be:

1. Other forum members feel the same way as I do about merged cells, which cause all sorts of problems, as you are finding out.
2. There is no solution to offer you.

[GmanJP]

ok, thankss

[AliGW]

I see you have given me a reputation comment of “Useless”. Are you going to give negative reputation to all those who failed to engage with you at all? At least I did. I shan’t do so in future, however.