Sorting Data to Different Sheets

G

Guest

I am working with another teacher on developing a spreadsheet that takes
names off one sheet and posts them to other sheets based on their grade
level.

We want to have a list of names in Column A on sheet 1, and grade level on
Column B of sheet one.

We want them to be sorted to different sheets in Column A. Say Sheet 2 has
all 9th Graders, Sheet 3 has all 10 graders.

We have looked a lookup functions, but can't seem to find the right one.
Is this more of a VB script question? What are some answers?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy data to different sheets 6
Need Simple List...Multiple Columns and Multiple Worksheets 6
Filtering failed moving on...HELP 2
Automatic Sumning of Same Cell from Different Sheets 3
SUMIF, 3D FORMULA, EXCEL FORMULA HELP 1
How to I sum different data from different sheets 3
Vlookup in multiple sheets 2
Enter data from same cell in different sheets into a new sheet 2

Top