Transferring from Sheet 1 to multiple other sheets conditionally

Closed
iamfreeman29 Posts 1 Registration date Sunday November 16, 2014 Status Member Last seen November 16, 2014 - Nov 16, 2014 at 01:45 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Nov 16, 2014 at 11:01 PM
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 January 28, 2010 Status Contributor Last seen May 5, 2022 766
Nov 16, 2014 at 11:01 PM
Looks like a macro would be needed for that
1