can you help me
i'm trying to create a macro that will loop through all the data in a user
specified column/row and return on a new sheet all non-blank data from that
selected colum or row with the relevant row/column headers as appear on
original sheet.

I'm a bit new to this sorry!