Is there any way to make a dated entry insert itself in the worksheet in the
correct order without doing a sort operation, or inserting a new row?
would be a big help for my reservations workbook
thanks
D

You could try the worksheet change event:

Private Sub Worksheet_Change(ByVal Target As Range)
<<Sort Code
End Sub

This should re-sort your selection everytime the worksheet changes.

Hope this helps

Sunil Jayakumar



"Dave" wrote in message
...
Is there any way to make a dated entry insert itself in the worksheet in
the correct order without doing a sort operation, or inserting a new row?
would be a big help for my reservations workbook
thanks
D



www.ayyoo.com/poker.html

I will try...thanks...

"Sunil Jayakumar" <sunil.jayakumar[at]gmail.com wrote in message
...
You could try the worksheet change event:

Private Sub Worksheet_Change(ByVal Target As Range)
<<Sort Code
End Sub

This should re-sort your selection everytime the worksheet changes.

Hope this helps

Sunil Jayakumar



"Dave" wrote in message
...
Is there any way to make a dated entry insert itself in the worksheet in
the correct order without doing a sort operation, or inserting a new row?
would be a big help for my reservations workbook
thanks
D



www.ayyoo.com/poker.html

could you instruct me where/how to place that code?


"Dave" wrote in message
...
I will try...thanks...

"Sunil Jayakumar" <sunil.jayakumar[at]gmail.com wrote in message
...
You could try the worksheet change event:

Private Sub Worksheet_Change(ByVal Target As Range)
<<Sort Code
End Sub

This should re-sort your selection everytime the worksheet changes.

Hope this helps

Sunil Jayakumar



"Dave" wrote in message
...
Is there any way to make a dated entry insert itself in the worksheet in
the correct order without doing a sort operation, or inserting a new
row?
would be a big help for my reservations workbook
thanks
D



www.ayyoo.com/poker.html

Hi Dave,

That code would need to be placed in the relevant worksheet - not in a
separate module.

Also, I think you would probably need to paste in all that data, as it would
trigger on the first entry - so as soon as you'd inserted the data,
basically.

Do try this, and let me knowif it works.

Sunil Jayakumar

"Dave" wrote in message
...
could you instruct me where/how to place that code?


"Dave" wrote in message
...
I will try...thanks...

"Sunil Jayakumar" <sunil.jayakumar[at]gmail.com wrote in message
...
You could try the worksheet change event:

Private Sub Worksheet_Change(ByVal Target As Range)
<<Sort Code
End Sub

This should re-sort your selection everytime the worksheet changes.

Hope this helps

Sunil Jayakumar



"Dave" wrote in message
...
Is there any way to make a dated entry insert itself in the worksheet
in the correct order without doing a sort operation, or inserting a new
row?
would be a big help for my reservations workbook
thanks
D



www.ayyoo.com/poker.html

thankyou
I pasted exactly what you posted into the worksheet ( right click sheet tab,
viewcode, )
but when I enter any data I get "compile error / syntax error "
i am not sure I am doing the right thing :(



"Sunil Jayakumar" <sunil.jayakumar[at]gmail.com wrote in message
...

Hi Dave,

That code would need to be placed in the relevant worksheet - not in a
separate module.

Also, I think you would probably need to paste in all that data, as it
would trigger on the first entry - so as soon as you'd inserted the data,
basically.

Do try this, and let me knowif it works.

Sunil Jayakumar

"Dave" wrote in message
...
could you instruct me where/how to place that code?


"Dave" wrote in message
...
I will try...thanks...

"Sunil Jayakumar" <sunil.jayakumar[at]gmail.com wrote in message
...
You could try the worksheet change event:

Private Sub Worksheet_Change(ByVal Target As Range)
<<Sort Code
End Sub

This should re-sort your selection everytime the worksheet changes.

Hope this helps

Sunil Jayakumar



"Dave" wrote in message
...
Is there any way to make a dated entry insert itself in the worksheet
in the correct order without doing a sort operation, or inserting a
new row?
would be a big help for my reservations workbook
thanks
D



www.ayyoo.com/poker.html