Hello,
I dont even know if this is possible or if its too complicated, but I have a document with 4 sheets, Data(kinda like raw data), sheet1, sheet2, sheet3.
My idea is to have 3 columns(A,B,C) that I can mark the rows with X, then that row(for example C4) being copied to the corresponding sheet(sheet3) so the data file remains intact. Then my idea is that if that row becomes active, I move the X from C4, to B4 and the row moves to sheet2(completely out of sheet3)
Basically, I want to mirror different rows from the data sheet to other sheets. If this were to work, if I made a comment in sheet 3, would the comment move with the row if it were to move to sheet 2?
Hopefully someone could help me!
(included a example)
https://imgur.com/a/LNtn9s1
I dont even know if this is possible or if its too complicated, but I have a document with 4 sheets, Data(kinda like raw data), sheet1, sheet2, sheet3.
My idea is to have 3 columns(A,B,C) that I can mark the rows with X, then that row(for example C4) being copied to the corresponding sheet(sheet3) so the data file remains intact. Then my idea is that if that row becomes active, I move the X from C4, to B4 and the row moves to sheet2(completely out of sheet3)
Basically, I want to mirror different rows from the data sheet to other sheets. If this were to work, if I made a comment in sheet 3, would the comment move with the row if it were to move to sheet 2?
Hopefully someone could help me!
(included a example)
https://imgur.com/a/LNtn9s1