Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I currently have an excel sheet that is used to record daily a bunch of parameters. Currently, I have a folder for each year, containing a folder for each month, inside of which I have an excel file with sheets corresponding to each day of that month.

What I am looking to do is to compress all of this into one excel file, mainly to make it easier to create formulas comparing days across different months.

Would it be possible to have a single excel sheet with a drop down menu, where you could select the date, with the rest of the cells in the sheets values being conditionally dependant on the date selected. i.e. blank if the date is in the future and there is no data, or containing the appropriate data from that day?

share|improve this question
2  
You seem to be looking for more of a database solution then a spreadsheet. Can you share a sample of your data? –  dav Oct 28 '12 at 21:00
    
It seems just a filter would suit, though if not maybe a pivot table? I agree that all the data in a single sheet looks sensible (provided not thousands of rows per day). –  pnuts Oct 30 '12 at 3:03
add comment

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.