Ask Experts Questions for FREE Help !
Ask
    looney2740's Avatar
    looney2740 Posts: 1, Reputation: 1
    New Member
    		  
    #1

    Feb 9, 2009, 12:56 PM
    Comparing data in multipe spreadsheets
    Our school is tracking student data in excel on multiple worksheets. Is there a way to do a sort and get all the data on one student for these multiple worksheets?
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #2

    Feb 9, 2009, 06:36 PM

    Lots of ways.

    What are the layouts of the external docs?
    What's the common piece of info? Student ID?
    What's the proposed layout of this compilation sheet?

    Can you upload samples so we're not just tossing ideas into the air.
    kurtwz's Avatar
    kurtwz Posts: 16, Reputation: 1
    New Member
    		  
    #3

    Mar 7, 2009, 02:30 PM
    Hello, if you simply want to combine or sum data from multiple locations, one thing you could do is use the "Combine..." feature in Excel. That's under Data > "Combine...". It essentially refers to the data sources you point it to and gives an output in a new location.
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
    		  
    #4

    Mar 7, 2009, 04:59 PM

    May be time for you to upgrade your tracking system to a real database.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Data entry or data processing from home. [ 1 Answers ]

Hello from Florida, My name is Don and I am looking for a free data entry from home website that I can find. It is not easy to find! Please help!

Inventory Spreadsheets copying data [ 4 Answers ]

Ok I work as a Chef and need some help with inventory sheets, I don't know a lot about excel so ANY ideas would help. What I'm trying to do is update our inventory sheets so that I can enter pricing info on one page and it matches throughout the entire workbook I.e. a Apple costs this much .29...

Copying spreadsheets onto a floppy [ 5 Answers ]

Hi, I'm trying to copy some excel spreadsheets onto a floppy disk. It keeps telling me to format the disk even though the disks I bought are formatted already. I go into the file I want and hit copy and it just comes up with must format disk, so I try that and then it comes up disk cannot be...

View more questions Search