Formatting Data from one sheet to another to appear in acsending date order

Hello wonderful excel helpers!

I am stumped on how to get information from one sheet "Status Report" in which the Order Date is located in Column I to transfer to another sheet "Status by Date". I need all of the information in each column A4:14 all the way down to A41:I41 and I need them to be sorted by Order Date. I have a feeling I need to come up with some sort of Macro but am not completely sure.
I have attached the document.

I appreciate any assistance!

Thank you kindly!

Hello Jendew,

The Macro below has been added to your workbook (the attached workbook). The macro is run by clicking the button on Status Report worksheet.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

Leith,

I cannot thank you enough for your assistance! You are a savior! This site is amazing and I cannot tell you enough how much I appreciate your help!!! THANK YOU!

Hello again,

Just a quick question.. I have tried to change the formula myself to start the data in the macro at row 3 instead of 1 but with no luck... go figure! Which line needs to change to make this possible?

Hello Jendew,

There are 2 variables that change the starting rows.StartRow controls the starting row for the Status Report and CurrentRow controls the starting row for Status by Date.

To change the values you will need to do the following...
1. Open your workbook
2. Use the keys Alt+F11 to open the Visual Basic Editor
3. Use the keys CTRL+R to position the cursor in the Project Explorer window.
4. Press the Down Arrow Key until you highlight Modules
5. If the Modules Key is not open then press the Right Arrow Key to open it
6. Press the Down Arrow Key to select Module1
7. Press Enter to display the macro
8. Make your changes and save the changes with CTRL+S

Sincerely,
Leith Ross

Hello Jendew,

Email me a copy of the workbook to look at. I'll fix any problems I can, and post back with the corrected workbook. My email is [email protected]

Sincerely,
Leith Ross

Hello Everyone,

Here is the updated macro as promised..

Please Login or Register  to view this content.

Sincerely,
Leith Ross