Transferring from Sheet 1 to multiple other sheets conditionally

[Closed]
Report
Posts
1
Registration date
Sunday November 16, 2014
Status
Member
Last seen
November 16, 2014
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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!


1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Looks like a macro would be needed for that
1
Thank you

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

CCM 2942 users have said thank you to us this month