I have a workbook that contains the following columns - Ordered_Qty and Not_Ordered_Qty. I need to write some VBA that, if both Ordered_Qty and Not_Ordered_Qty" are >0, create a new record on the same worksheet and move the Not Ordered Qty into the new record in the same field, replacing the previous value in the original record with 0. I'm using Excel 2007.
I've only been able to find VBA samples for parsing out comma separated values in the same column.
The idea is that they don't want to see an ETA Date for something that hasn't even been ordered yet.
Hope my attachment worked - sample of what I need it to look like.
Thanks for any help or point in the right direction.
Toni
Bookmarks