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
762
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!