I need a macro that lists entries from all worksheets in the workbook based on whether a value >0 exists in column H; then writes that value along with two other values from the same row as the row with a value in Column H.
Macro will be run separately from a tab named 'Summary" on each of several workbooks. With the Summary tab active in each workbook and because the summary collects values based on a date entry, the previous summary the macro has created will be erased each time the macro is run before the macro re-posts a new summary to the same starting cell on the Summary tab.
An Excel 2010 spreadsheet with more explanation is attached.
Thanks in advance for your help.