Chronological sorting

[isa]

This is an example of what is being worked on:

(There are 500+ more lines like the ones below, in groups of approximately 17 lines per page of information.)

* C.B.A. Bank - 2nd reference to branch near Mike's store. (21/03/1956)
* Berwick exams results. (06/06/1877)
* Berwick exams (09/05/1877)
* Steps taken for erection of Berwick. (11/07/1874)
* Berwick tenders for work at home. (11/07/1877)
* W. was a storekeeper at Berwick. (25/07/1881)
* Berwick Brass. (27/06/1877)
* Commercial erected for son. (27/06/1878)

I need to do the folowing to it:
(not necessarily in the following order)

- Insert into Excel
- Remove brackets
- Sort chronologically
- Copy back into program I am using again, in same chronological order.

The desired outcome is to be able to throw into Excel all the lines and press a button, (possibly the Sort Ascending one) and have a chronological list of all entries.

... Or something as close to this as possible ...

I hope this made sense

Thanking you in advance.

[jasoncw]

This was slightly more complicated since your dates span prior to 1900. I'm sure there is probably an easier way to do this, but here is what I came up with.

1. Create a command button on the worksheet.
2. Right-click on the button and select View Code.
3. Copy the following code to your CommandButton1_Click procedure:

Please Login or Register  to view this content.

Hopefully that works for you.

Jason

[isa]

This was slightly more complicated since your dates span prior to 1900. I'm sure there is probably an easier way to do this, but here is what I came up with.

1. Create a command button on the worksheet.
2. Right-click on the button and select View Code.
3. Copy the following code to your CommandButton1_Click procedure:

Please Login or Register  to view this content.

Hopefully that works for you.

Jason

Thank you very much Jason for your help

I will be trying this formula first thing tomorrow. 1/4 to 5 here in Australia, knock off time

Stay tuned

Again, thank you very much mate

[isa]

1. Create a command button on the worksheet.

Errmmm ...

(Geez I feel blonde today! )

[jasoncw]

LOL!

1. View > Toolbars > Control Toolbox. This will show the toolbar with the command button on it (as well as other objects).

2. Click on the Command Button tool button, then draw a rectangle directly on the sheet. This will insert the command button. You can change the text on the button if you wish, as well.

[isa]

Thank you for that Jason,

I managed to do that without frying the computer...

And nooowww...

2. Right-click on the button and select View Code.

All I get when I do that is:

When I right click on "border" of the button (The red part)

When I right click on "body" of the button (The red part)

No 'View Code' to select

Geez I'm embarrassed

[jasoncw]

What happens when you double-click on the button? Sorry, I only have Excel 97 on the computer I am on right now, so I can't see exactly what you are seeing.

[isa]

What happens when you double-click on the button?

Single, or double left click result as:

Office Assistant says:

Mind you, when I hover over the button, the pointing arrow becomes the pointing finger. If that made sense

Sorry, I only have Excel 97 on the computer I am on right now, so I can't see exactly what you are seeing.

PS: I am using MS Office 2000.
PPS: Can you see the images that I am posting the links of?

[jasoncw]

Hi, Isa.

Yes, I can see your screen shots. Did you use the button all the way on the top of your screen (based on looking at your screen shots) to insert the button? It appears as though you inserted a drawing object, rather than a command button.

If you inserted a command button, as soon as you insert it, the formula bar should state something like "=EMBED("Forms.CommandButton.1","")". See my attached screen shot.

[isa]

THANK YOU SOOOOOOOOOOOOOOOO MUCH MATE!!!

It works!

And may you be helped when in strife as well Mate!

Thank you VERY MUCH!

[jasoncw]

Glad I could help you out.