I may be misunderstanding you, but rather than writing a macro, it'd probably be easier to just add a sort filter to the columns on your spreadsheet, then de-select blanks and/or $0.00. If you really want to, you could just record yourself a macro to do this sort with a button or keyboard shortcut. Just hit record macro, click the filter button on the column you want that has the blanks, de-select 'blanks,' (and/or $0.00), and hit stop recording. Assign a keyboard shortcut or create a button, your choice. It sounds like excel already has a built-in fix for your problem so I don't really see the point of writing code (that's just me though), you can quicken the process by recording a macro to shorten the process to 1 click with a little messing around