Needing to Transfer the results of an IF statement to another Tab & ignore blank cells.

[SLOWBRAH]

I've got a work book (2010 btw) with several tabs.

On tab 5 is an inventory list with "Stock Number and Nomenclature" merged in row A7-Q7 and down to row A23-Q23.

Beside each Item there are “Required Quantities (EA)" in Colum U7-U23. After an inventory is executed, The values are placed in Colum V7-V23 (INV).



Stock Number Nomenclature EA Inv
34419-43450 Mission Modu 1 “X”


After inventorying.... I need a formula that "compares the required quantities (EA) to the actual inventoried values (X)".


IF the actual inventoried quantities are equal to or greater than "Required Quantities" - Display Nothing in tab 6

IF the actual inventoried quantities are LESS than the "Required Quantities" - Display “Stock Number and Nomenclature" in tab 6 for a shortage list, ignoring the "blank cells".

[Richard Buttrey]

Hi and welcome to the forum.

I think you'll need to upload the workbook, or at least a representative cut down version.

Manually add the results you expect to see, tell us which are the result cells and explain how you have calculated them.

[SLOWBRAH]

Equipment Pickup Check List (Help Version).xlsx

I hope I did this correctly.

It is fairly straight forward. The highlighted items are "Short" post inventory. Therefore they need to be listed in order on the "Shortage" tab. The quantity that is missing needs to be totalled in the shortage tab, represented by the blue area in the "Shortage Tab".


Also.... my tab 6 sheet opens at the bottom? How do I get it to open at the top?



THANKS!!!

[SLOWBRAH]

Help me out! I've been staring at this for quite sometime. Thank you!!