Data Question

[Brian]

I have a tab on my worsheet that has the following informatio

a
Order # Order Statu
123 Not yet starte
456 Not yet starte
873 Starte
831 Complet

Basically, every 2 hours the column with order # will refresh, mix up the order #'s (since they are tied to the auto-matic update of info) and will change the order of the order #'s, add some new ones, delete old ones and my order status column will stay the same (since I manually entered those in). So the new data could look like thi

b
Order # Order Statu
873 Not yet starte
123 Illega
456 Started
001 Complet

So there is the problem, while the order #'s are moving up/down, getting deleted and added my order status column (with comments) stays the same and does not follow the order #'s as they move around (above order # 456 in a) was not yet started and in this new grouping b) order #456 is started) How do I make sure the order status comments follows the exact order is my question? Is there a function or simple macro I can use to make sure that whatever comment is tied in with the order # will always follow that order #

Hopefully this makes sense and any help is appreciated

Thanks
Brian

 

[RagDyer]

What are you doing to "mix up" the order numbers?
Formulas? ... Code? ... What?
And why can't the "mixer-upper" (whatever that is) include the next column
also?

Need more info, especially since you included "delete" in the possibilities!
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

I have a tab on my worsheet that has the following information

a)
Order # Order Status
123 Not yet started
456 Not yet started
873 Started
831 Complete

Basically, every 2 hours the column with order # will refresh, mix up the
order #'s (since they are tied to the auto-matic update of info) and will
change the order of the order #'s, add some new ones, delete old ones and my
order status column will stay the same (since I manually entered those in).
So the new data could look like this

b)
Order # Order Status
873 Not yet started
123 Illegal
456 Started
001 Complete

So there is the problem, while the order #'s are moving up/down, getting
deleted and added my order status column (with comments) stays the same and
does not follow the order #'s as they move around (above order # 456 in a)
was not yet started and in this new grouping b) order #456 is started) How
do I make sure the order status comments follows the exact order is my
question? Is there a function or simple macro I can use to make sure that
whatever comment is tied in with the order # will always follow that order
#?

Hopefully this makes sense and any help is appreciated.

Thanks,
Brian