Inventory Unit of Measure Calculations VBA in EXCEL_Unsolved

[AGCSC1]

Hi Very Smart VBA gurus... Any additional thoughts on VBA Macro for:
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

A2 = Metal2
B2 = Sq. Ft. On-Hand
C2 = Sheets On-Hand
D2 = Packs On-Hand

where C2 = B2/8
where D2 = C2/8

A3 thru A99 would all also need to be independent conversion factors

Thank you very much for looking at it and offering help!!!

[arlu1201]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

You can mark your other thread as "Unsolved" by selecting "Thread Tools -> Mark as unsolved" and then bump it up. It will get visibility.

Thread Closed.