auto sort dates

  1. B

    Sort 2 database separately by date and adding space in between dates that are different

    Hi, Is there a way to automatically sort 2 database's by date and add space in between dates that are different? ABCDE1Office...
  2. Chris_010101

    VBA Help Auto-Sort upon workbook Open

    Hello This is my sheet (unfortunately can't install XL2BB on my work machine): Sheet is called "outstanding" and is 16 columns wide. I already have VB code in here which moves the row to another sheet based on the status from a drop-down list in column O. When the workbook is opened (or...
  3. D

    Sorting excel sheets in numerical order based on the date in the batch number

    Hello. This is something I am struggling with. I have a large number of sheets in an excel spreadsheet that aren’t in date order. They are titled with batch numbers I.e “AB 100921A” or “AB 010616A” etc. Is there a way to automatically put the sheets in order by the date within the batch...
  4. D

    Auto Sorting Macro

    I am using the following macro to auto sort entire rows by dates entered into column "N". The first row in the data that needs to be sorted is "4". I will need this to auto sort any rows that are added into worksheet and dates entered. It was working fine but it just started not auto sorting...
  5. C

    Auto-Sorting After New Input On Different Worksheet

    I realized that my original post was unclear, but could not find an "Edit" button for my previous post. Mods, can you delete the original thread? It has no comments. Thanks! First, I apologize for another auto-sort thread. I read through several of the various examples, and still wasn't...
  6. C

    Auto-Sorting Based on New Input

    I have daisy-chained three spreadsheets together: Data Entry / Data Sorting / Data Crunching In Data Entry someone enters date, time, and event information In Data Sorting the event is assigned a number and then sorted, Descending, by date and then time. In Data Crunching, all sorts of fun...
  7. J

    Auto Sort based on cell color

    I have a spreadsheet that has 4 colors on it that need to be sorted automatically separated by two blank cell. the Colors are done using a conditional format. What i need it to look like is below. there will be muiltiple lines, and i would like it to move when the cell color changes based on...
  8. B

    Auto Sort Help!

    Hi everyone, <o:p></o:p> I need help with and auto sort problem I am running into. I am not real familiar with macros and code on excel so this is posing a bit of a problem for me. What I need to do is sort a list of employees by the last date they worked so that the employee who worked last is...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top