Hi all,

I relatively understand the basics of linking cells between two different worksheets. I previously asked about a macro to do this, but I'm looking for the least complicated options for my clients.

Please see attached TestExcelHelp.xlsm--I need rows with non-zero values in column H to be linked with their Inventory numbers (column B) in a new worksheet. Column H's formula is
Formula: copy to clipboard 
=MAX(0,COLUMN F - COLUMN G)
. They are fine with the requirement of having both worksheets open at the same time. I just need the second (destination) worksheet to only show the item numbers (Column B) and associated non-zero values (Column H). Rows with zero values in Column H (and the associated Inventory Numbers, Column B) should not be copied to the destination worksheet.

Thank you in advance!

Julie