Could use some help with Excel calculating Unit of Measure forwards and backwards for inventory purposes. For example;

A1 = Metal1
B1 = Sq. Ft. On-Hand
C1 = Sheets On-Hand
D1 = Packs On-Hand

where C1 = B1/10
where D1 = C1/10

Want to allow user three count and enter possibilities:
If user enters On-Hand data in B1, VBA calculates C1 & D1
If user counts sheets & then enters On-Hand data in C1, VBA calculates B1 & D1
If user counts packs & then enters On-Hand data in D1, VBA calculates B1 & C1