Merged cells via linked formulas

Hi everybody,

It is my first time doing this and I'm not sure I'm at the right address or if it is even possible but let's try

So I have 2 documents and I need data from 1 document in the other one. In the retrieving excel I have merged cells and when I link that document to the document where I want the data, I only get the first cell with the info.

To explain a little bit better, in document A I have A1:C1 a merged cell, with the formula =if(A<>"";A;"") I link the document A to the other document B but in document B, only in A1 the data appears, I would like to have the data in A1:C1, like in document A. I hope it is a bit clear because it seems like I can't add any pictures to clarify a bit more...

Is there a way to create this? Even if it is not with merged cells?

Thank you in advance,
Aline

Hi JohnTople,

You are right,I had indeed =if(A1<>"";A1;"") as a formula and not =if(A<>"";A;"").

I've added a document that hopefully explains what I want to do.

thank you,
Aline

Hi Torachan,

Is there another way of working that you can propose to me?
Without merged cells but with the same outcome and where C3:D3 would be as I need?

Thanks

Because normally I have more documents to retrieve data from and in Company B, there is as well data. I wanted to make an easy representation.
The data of company can change, so that is why I can't just make a copy or I need to make a copy every week.

If not necessary, I won't use merged cells but I don't know any other way

Yes, if it possible to have that, it would be ideal. Would it be possible to show me how to do that via VBA ?

thank you in advance