Transferring from Sheet 1 to multiple other sheets conditionally

Closed
iamfreeman29 Posts 1 Registration date Sunday 16 November 2014 Status Member Last seen 16 November 2014 - 16 Nov 2014 à 13:45
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 16 Nov 2014 à 23:01
Hello,

I would like to create a workbook for an English school I am starting in Tanzania. Once registered, all students info will be entered into a master copy on sheet 1. Then, based on the level of the student, some or all of the info in that row will be transferred to sheet 2 for beginner, sheet 3 for Book 1, sheet 4 for Book 2 and so on through sheet 8 for our final level.

How do I do this? Thanks in advance for the help!


Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
16 Nov 2014 à 23:01
Looks like a macro would be needed for that