convert from structureB to structure A

[VBAidot]

Hi ,
There are two structure, structure A & structure B. If convert structureB to structureA, need to know how many items lack from B to A.
if there is model lack, look for the substitute column for a substitution in storage or the same model in storage.
if have the model but the quantity is not enough, look in the storage if there is enough quantity.
If can’t find what need in storage, then when list the conversion list of structure, mark in the “From” column “need to buy” . others, if from the storage, then mark storage, from structure B then mark structureB
thks!

[Tiger20]

Comment
A lot of people have looked but appear to have not been able to decipher what you are after.
Re "If convert structureB to structureA" is it - If compare structureB to structureA?
Where the lists have multiple "Model" of same number, does that indicate the quantity held? If so can't you have one x Model number and a quantity column.
Your "Storage" sheet doesn't have any quantities.
Please include some sample results of what you hope to be achieved to allow people to better recognize what you need.

[VBAidot]

Hi Tiger20,
thks for the reminder.
if convert structureB to structureA is sort of compare structureB to structureA.
for the same model that structureA & structureB have but dun have same quantity, need to find @ storage or if storage dun have then need to buy.
because for each item there is a SN(serial number), so for every item listed, they may have the same model#.
it seems, to convert, firstly need to summary the list of structureA & structureB to count the quantity of same model#
then compare
I include the sample results in the attachement.
thks