+ Reply to Thread
Results 1 to 3 of 3

Moving data around in a spreadsheet

  1. #1
    Registered User
    Join Date
    10-25-2016
    Location
    Aiken, SC
    MS-Off Ver
    2016
    Posts
    2

    Moving data around in a spreadsheet

    I am a teacher. I have to schedule students to go to a different class every 3 days. Here is what I have: 1 column of a list of students from Class A. One column for a list of students from Class B. One column for a class of students from Class C. A and B classes can have 25 student. Class C can only have 17. I need to move students from classes A and B to Class C approximately every three days. I move the students from class C into classes A and B. How can I do this automatically without having to copy and paste every three days? I would appreciate any help..comments...

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Moving data around in a spreadsheet

    I would create 5 columns.
    A - list of ALL students
    B - drop list for each student where you select A, B or C (you can name these classes anything you want)
    C - List of class A
    D - List of class B
    E - List of Class C

    I would use the dropdown to move students.
    I would use formulas in the class columns to list the students for you.

    I've created a quick version I think will work for you. Drop the names into column I, change the class names in B3:D3, then use the drop downs in column J to make the assignments. Whenever you assign more students than allows in the MAX row, the class name will turn red til you fix it.
    Attached Files Attached Files
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  3. #3
    Registered User
    Join Date
    10-25-2016
    Location
    Aiken, SC
    MS-Off Ver
    2016
    Posts
    2

    Thumbs up Re: Moving data around in a spreadsheet

    Thank you! That helped a lot!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Moving data from one spreadsheet to another
    By Metrazal in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-18-2014, 12:23 PM
  2. Getting data moving from one spreadsheet to another
    By John Mitchel in forum Excel General
    Replies: 1
    Last Post: 03-20-2012, 12:34 PM
  3. Moving data from one spreadsheet to another one.
    By mroldguy in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-20-2011, 03:27 PM
  4. Moving data from 1 spreadsheet to another one.
    By mroldguy in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-18-2011, 03:45 PM
  5. Replies: 1
    Last Post: 03-18-2006, 10:25 AM
  6. [SOLVED] Matching and Moving Data From One Spreadsheet to Another?
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-18-2006, 10:25 AM
  7. [SOLVED] Moving data to another spreadsheet...
    By Guylaine_X in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-31-2005, 02:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1