G
Guest
Here is the data I hav
Order# Order Start Time Why Didn't Order Star
345 11:00 AM Parts not availabl
112 01:00 PM
913 05:33 AM
841 18:42 PM Order cancelle
Basically the information above (Tab1) refreshes every two hours (by refresh, we ping a database and it pulls udated information (it updates Order#, Order Start time but not Why didn't order start because that is manually entered) into Tab1
The problem is as this data refreshes every 2 hours new order #'s come and go and the whole order (row placement) of order #'s gets mixed up. While the Order Start Time follows the Order # (info from database) my Why Didn't Order Start column stays the same (since I manually enter that data in).
What can I do, simple macro or v-lookup that can match the Order # with the Why Didn't Order Start column?
Order# Order Start Time Why Didn't Order Star
345 11:00 AM Parts not availabl
112 01:00 PM
913 05:33 AM
841 18:42 PM Order cancelle
Basically the information above (Tab1) refreshes every two hours (by refresh, we ping a database and it pulls udated information (it updates Order#, Order Start time but not Why didn't order start because that is manually entered) into Tab1
The problem is as this data refreshes every 2 hours new order #'s come and go and the whole order (row placement) of order #'s gets mixed up. While the Order Start Time follows the Order # (info from database) my Why Didn't Order Start column stays the same (since I manually enter that data in).
What can I do, simple macro or v-lookup that can match the Order # with the Why Didn't Order Start column?