SharePoint List

I've one Purchase List1 with few columns. In this List1 I've column name "Part No (Text type)" & "Balance Qty" (Updating through SharePoint Designer using workflow). Whenever the Order Qty will receive user will enter the Qty in column "Received Qty" and the Qty will update/ add in "Balance Qty" column to the particular Part No by workflow.

Now here I want to create List2 where user can out the qty as per avilable "Balance Qty" from particular "Part No". Also whenever the Qty will out from List 2, the Qty should deduct from List1 "Balance Qty" column.

So from List1 we can see the "Balance Qty" for every part no and List2 we can check the OUt Qty status with Date.

Can you please advice if this is possible by SharePoint List / Designer Workflow.