ahhh you caught me on the grammar....

1. I meant copy, keep data on master sheet
2. "AllData"
3. Yes they already exist, I used a macro to create them
4. Yes I would love a macro to do this all at once, its already a
macro-enabled workbook as i used the aforementioned macro to create the
sheets.
5. Shouldn't need to but ok
6. No need as this is a one time process

Thanks!
James
"JBeaucaire" wrote:

Do you really mean "Bare" with you, or "bear" with you...hehe.

1) When you say "move all the math data to the math sheet" do you mean move
or did you mean copy? Are basically eliminating the master sheet or duping
the data on the subject sheets?

2) What's the name of the master sheet?

3) Do all the subject sheets exist already?

4) Are you OK with a macro that does this for you "all at once"?

5) If macro is OK, when it runs, do you want it to check and make sure the
needed sheets already exist and create them if needed?

6) Do you want the macro to ADD to the data on those existing sheets or
create a whole fresh new report each time it is run?

jerry
AT
devstudios
DOT
com

--
"Actually, I *am* a rocket scientist." -- JB
(www.MadRocketScientist.com)

Your feedback is appreciated, click YES if this post helped you.


"James Merrill" wrote:

Bare with me here as I try to explain this because it is somewhat confusing,
I will try to simplify as much as possible. I have a workbook with multiple
sheets. The first sheet (AllData) contains all my data. I have 3 columns of
data: Subject, Student, and Grade. Looks like this:

SUBJECT STUDENT GRADE
math john doe A
science jane doe B
english james C

There are three subsequent sheets named according to the subject: "math",
"science", "english" I want to move all the "math" data onto the math sheet,
science data onto science sheet, and engnlish data onto english sheet.

This is a simplified version, as my real example has 140 different
"subjects" and about 40,000 rows, so doing it manually is a bit out of the
question. Let me know if any of that didnt make sense or if i can further
clarify.

Thanks,
James