The copy of the other sheet

Dani · 11/12/18

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å · 11/12/18

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 · 11/12/18

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å · 11/13/18

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 · 11/13/18

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å · 11/14/18

Hi Dani,

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

Best,

Andrée

Dani · 11/14/18

Hello，

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

Andrée Starå · 11/16/18

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

Best,

Andrée

The copy of the other sheet

Comments

Categories