Automatically transfering data from one worksheet to another

Closed
hannahjg6666 Posts 1 Registration date Tuesday November 12, 2013 Status Member Last seen November 12, 2013 - Nov 12, 2013 at 05:31 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Nov 12, 2013 at 11:56 AM
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 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Nov 12, 2013 at 11:56 AM
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