Automatically transfering data from one worksheet to another

[Closed]
Report
Posts
1
Registration date
Tuesday November 12, 2013
Status
Member
Last seen
November 12, 2013
-
Posts
2809
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 23, 2021
-
On excel is there any way you can get rows to move over automatically if their status changes?? So for example on a spreadsheet if you had a list of various different status, if the status was to changed can it automatically moved to a differnet tab? I think this might be something to do with coding?
I have the spreadsheet I can send if this makes it eaiser?!
Any help would be appreciated!

1 reply

Posts
2809
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 23, 2021
484
Hi Hannah,

Yes there is a way and yes that way is using a code.

Do send your spreadsheet using a site like www.speedyshare.com or ge.tt.

Please make sure it is clear what STATUS needs to go WHERE.

Best regards,
Trowa
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month