Hi All,
In a worksheet I created for work, I have 20 columns, and 5,000 rows on sheet2 which I have renamed "Open Order". A few key columns are Account name which is in the B column, Order number which is in the D column, Item number which is in G column, and quantity which is in the K column. The rest are not of importance for this question. Throughout the day, we receive an email that has a list of changes in it. Unfortunately the email is just written, and is not done in any organized formation. Below I will include an example of these changes. What I would like to do is paste these changes into Sheet3, which has been renamed "Changes", and if any orders have this item on it, have them listed. I wold like it to include the Account name, Order number, Item number and quantity from "Open Order". I have no idea where to even start with this. Any info that could get me started would help a lot. Even just a confirmation that this is possible would help.
Example of the changes...
Nx1 alloc all the orders
Hc221gbw is nla its rgb
Ww204w is wn
Ww43d cancel the orders
Sp1k move all and allocate the orders
END EXAMPLE
Thank you
Bookmarks