Hi all!
I've never really been any good with VBA and I'm looking for help with what I think is quite a simple problem. I have 2 sheets named 'Special Orders' and 'Allocation'. In special orders I have all of the orders that have ever been done and this is nearing 3000 lines. To simplify reading this I've created another sheet called 'Allocation' where it only shows orders that haven't been collected so this is only 100 lines long, I've pulled this using this Filter function:
=IF(ISBLANK(FILTER('Special Orders'!B1:K9998,('Special Orders'!C1:C9998=B2)+('Special Orders'!C1:C9998=B3),"")),"",FILTER('Special Orders'!B1:K9998,('Special Orders'!C1:C9998=B2)+('Special Orders'!C1:C9998=B3),""))
I've attached an example of the sheets below. What I'd like to do is use VBA to select any any data in 'Allocation' Column M, cut the cell, Match the ID in 'Allocation' with 'Special Orders' to find the row and finally paste the cut data into that row in Column L of 'Special Orders'.
I've never really been any good with VBA and I'm looking for help with what I think is quite a simple problem. I have 2 sheets named 'Special Orders' and 'Allocation'. In special orders I have all of the orders that have ever been done and this is nearing 3000 lines. To simplify reading this I've created another sheet called 'Allocation' where it only shows orders that haven't been collected so this is only 100 lines long, I've pulled this using this Filter function:
=IF(ISBLANK(FILTER('Special Orders'!B1:K9998,('Special Orders'!C1:C9998=B2)+('Special Orders'!C1:C9998=B3),"")),"",FILTER('Special Orders'!B1:K9998,('Special Orders'!C1:C9998=B2)+('Special Orders'!C1:C9998=B3),""))
I've attached an example of the sheets below. What I'd like to do is use VBA to select any any data in 'Allocation' Column M, cut the cell, Match the ID in 'Allocation' with 'Special Orders' to find the row and finally paste the cut data into that row in Column L of 'Special Orders'.