This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hi!
For examples the below table in in sheet 1
| colours | number | accepted |
|---|---|---|
| blue | 3 | y |
| green | 7 | n |
table in sheet 2
| colours | number | remarks | accepted |
|---|---|---|---|
| blue | 3 | y | |
| green | 7 | n |
so columns "colours" "number" "accepted" are linked in both sheets so any changes to sheet 1 will change sheet 2. so this is my question if I sort sheet 1 I want my remarks to sort with the particular rows. is there a way to link column "remaks" and "colours" in sheet 2 , so that it is a cascade effect. So if I sort table in sheet 1 then sheet 2 changes along with my remarks column .
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
I agree with Andreas, there is no way I know of to make that kind of link?
.
On the other hand, why do you have the separate "sheet 2" with identical information, with only the 'remarks' column added? Why not just add the remarks column to "sheet 1", even if it is mostly blank?
That is not possible.
Furthermore if you use simple formulas to "link" into the other sheet, the data get mixed up. Please read this article:
Formula - How to pull data from another sheet without getting mixed up - Microsoft Community
Andreas.