The copy of the other sheet

Dani

Hello.

I have two sheet, some column's headline is the same.Are there a method? when I type one sheet and the sames content of the other sheet will appear automatically.thanks again.

Andrée Starå

Hi Dani,

Yes, you can do it with cell-linking but if it will work for you depends on your specific needs and use case.

How many rows and columns of information do you want this to work for?

Have a fantastic week!

I hope this helps you!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Dani

Hello，

I have 5 columns need to link from another sheet. If the first cell of the row on the second sheet is the same with the first sheet, meanwhile the column name is the same. The other cells have the same headline column will link the contents from the first sheet. 

If I should use the formula and what formula I can use? thanks!

Andrée Starå

It sounds to me that you could use cell linking for this. Do you have something that you can share, like screenshots or the sheets you are using today so I can get a better understanding?

Best,

Andrée

Dani

Hello，

I have a sample, please see the attachment. If the "Supplier Name CN" "荣成市蓝海海洋生物科技有限公司"is the same both in the first sheet and second sheet, the other same headline's contents will link from the first sheet to the second sheet.I do not how to make it. 

Hope I have clarify the issue. thanks

Andrée Starå

Hi Dani,

I can't see any attachment. Can you add it again?

Best,

Andrée

Dani

Hello，

Sorry，I upload the attachment again ,maybe internet reason.

Andrée Starå

Do you want all the data from one row to show in the other sheet if it's the same supplier?

Best,

Andrée