Dear Gurus,
First of all, I would like to say thank you for viewing my thread. I've covered some basics of MS excel, please do not mock me on why do I need this feature I'm about to ask, it is a requirement, please tell me if it is not possible >.<
Attached is a sample excel file, where you can see sheets named "Masterlist","s1","s2" & "s3". You can see at every sheet, the fields are the same which is "Id", "Name" & "Action".
Every row of data, the "Action" column would be most crucial for me. I do know that we can filter the column "Action" to see a list of names with selected "Action", but again, this is a requirement.
Here my question goes; is it possible, to automatically copy the whole row of data, to another sheet, when the "Action" drop down is changed?
i.e. when the user select Masterlist, the whole row of data is copy to Masterlist, and gets deleted at the current sheet?
From masterlist, if the user selects "Go to S1", the row from Masterlist gets copied at S1, and deleted at masterlist?
Thanks & regards.
First of all, I would like to say thank you for viewing my thread. I've covered some basics of MS excel, please do not mock me on why do I need this feature I'm about to ask, it is a requirement, please tell me if it is not possible >.<
Attached is a sample excel file, where you can see sheets named "Masterlist","s1","s2" & "s3". You can see at every sheet, the fields are the same which is "Id", "Name" & "Action".
Every row of data, the "Action" column would be most crucial for me. I do know that we can filter the column "Action" to see a list of names with selected "Action", but again, this is a requirement.
Here my question goes; is it possible, to automatically copy the whole row of data, to another sheet, when the "Action" drop down is changed?
i.e. when the user select Masterlist, the whole row of data is copy to Masterlist, and gets deleted at the current sheet?
From masterlist, if the user selects "Go to S1", the row from Masterlist gets copied at S1, and deleted at masterlist?
Thanks & regards.