I have 2 lists of parts for the same job, one list is for one section of the
job the other is for another section, which helps determind parts allocation
during manufacture/assembly. However, i need to order the parts using the
same list (or a list derived from the original). The two lists are on the
same sheet i.e. (heading) Section 1 in cell A1 followed by section 1 parts
from A2 to A10 (for example), then (heading) Section 2 in cell A11 followed
by section 2 parts from A12 onwards. If a parts in section 1 is also in
section 2 i would like the part in section 1 to disappear and the quantity of
the part i section 1 to be added to the quantity of the part in section 2. So
if there were 5 off part 1's in section 1 and 6 off parts 1's in section 2,
then the final list would state 11 off part 1's. I guess i need excel to
check if a part in section 1 is in section 2, if not then leave it, if so
delete the part but add the number of parts to the quantity of the part it
matches in the other section. It seams quite simple but i'm a bit stuck, any
help would be much appreciated.