SilentRomance
New Member
- Joined
- Aug 4, 2021
- Messages
- 46
- Office Version
- 2016
- 2010
- Platform
- Windows
Hello guys,
I am trying to link two sheet of different workbook (ex. A and B) which is, if I insert new row from the source (A) and it will update in the other work book (B).
This is what I tried.
In workbook A, this is the data.
and in workbook B I used the special paste - (Paste link) to link. But when I insert new row in Workbook A the workbook B did not update.
(workbook A)
workbook B (this is the output)
there is no Color 1.5 added.
Is there any other solution or formula t be used?
......Sorry for the messy message, I hope you understand what I want to say.
I am trying to link two sheet of different workbook (ex. A and B) which is, if I insert new row from the source (A) and it will update in the other work book (B).
This is what I tried.
In workbook A, this is the data.
Cool 1 |
Cool 2 |
Cool 3 |
and in workbook B I used the special paste - (Paste link) to link. But when I insert new row in Workbook A the workbook B did not update.
(workbook A)
Color 1 |
Color 1.5 |
Color 2 |
Color 3 |
workbook B (this is the output)
Color 1 |
Color 2 |
Color 3 |
Is there any other solution or formula t be used?
......Sorry for the messy message, I hope you understand what I want to say.