Excel Guru needed

[Shiraz1961]

Need Help!
I want to capture in one spreadsheet(invoice) all those values greater
than 0 in another worksheet. I need this automated a little such that
it looks through the entire column, row by row and then lists the
heading and value of those greater than 0.

Thanks

 

[Tom Ogilvy]

Look at Data=>filter=>Autofilter. In that column, in the dropdown, select
custom and select the greater than criteria.

Select the range, then do edit=>Copy (only the visible rows will be copied)

Paste into your workbook.

If you want code, turn on the macro recorder.