![Avatar of Steve Eckerman](https://filedb.experts-exchange.com/files/public/2013/11/18/e12a1c01-d7a8-408d-8016-d4c1160d6fb0.png)
Steve Eckerman
asked on
Excel Data Adjustments
Attached is the Excel file that I need help with. I was wondering if anyone could make me a formula that could sort the data that is in Columns E through K, Rows 2 through 422. I need the formula to analyze Column D "Date Due" and then move the data that is in the columns/rows stated in the previous sentence. I need it to move the data into the right column (E-K) based on the dates that head those columns. For example, if the Date Due in cell D2 was less than the heading in Column E (7/12/13) then I need it to move the data in that row (found anywhere from Columns E-K) into Column E. However, if the Date Due in cell D2 was greater than the heading in Column E but less than the heading in Column F, I would need the data in that row (again found anywhere in E-K) moved under Column F. And so on and so forth..
I'm not sure if it is possible to make a formula like this but I thought I'd ask. If it's not possible please let me know.
Thanks in advance. =)
Sample-Book.xls
I'm not sure if it is possible to make a formula like this but I thought I'd ask. If it's not possible please let me know.
Thanks in advance. =)
Sample-Book.xls
![Avatar of Steve Eckerman](https://filedb.experts-exchange.com/files/public/2013/11/18/e12a1c01-d7a8-408d-8016-d4c1160d6fb0.png)
ASKER
Yes I need them to be placed under the headers based on column D dates. If adding 7 new columns is necessary then that is fine. I just need it to sort them based on column D. I attached two sheets. One is an example of how I want the data sorted and the other is the sheet I'm trying to put the formulas on. I want it so I can copy and paste data into it and it will sort it automatically. If you need to add 7 more columns to the right of column K then please do so.
Thank you for your help, it is much appreciated.
Example-book.xls
Project-Book.xls
Thank you for your help, it is much appreciated.
Example-book.xls
Project-Book.xls
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
![Avatar of NBVC](https://filedb.experts-exchange.com/files/public/2014/0/2/94906360-21fa-4d34-9ad8-682c4d4a3b7e.jpeg)
Here is the workbook back for your review.
Copy-of-Example-book.xls
Copy-of-Example-book.xls
![Avatar of Steve Eckerman](https://filedb.experts-exchange.com/files/public/2013/11/18/e12a1c01-d7a8-408d-8016-d4c1160d6fb0.png)
ASKER
Thanks, works great!
If so, then you would need to keep or move the current E:K columns for reference, then add 7 new columns that contain formulas.
is that what you mean?
Maybe a few example results would help to understand.