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

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.**
Here is the workbook back for your review.

Copy-of-Example-book.xls

Copy-of-Example-book.xls

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.