Excel help? Need to consolidate data from multiple sheets + date sort.
 

We have multiple sheets with tasks. Each line on a sheet represents a task. Each department has its own sheet. Columns for all departments are the same.

Need to pull data from the multiple department sheets onto one master sheet, then sort that one by date.

One issue is that some of the tasks have date ranges instead of just due dates.

Can it be done without hiring a programmer? :)

2016 (04) April 1 – August 1

I would use a script written in R to read in all of the data, manipulate, then output a csv.

Can you pick a date from the range so you can at least normalize the data across all of the sheets?

I think one of our interns has worked it out with pivot tables. It's almost there.

I'd set it up in a proper relational db. use 2 date columns when you do, start date and end date. for single date events, they contain same data

A friend of mine wrote this, perhaps it can help
https://youtu.be/CSU0PONiz6w

pivot table

Copy paste, then text to column so they all line up.