Copying data onto another sheet, but omitting blanks.

[anarchyflag]

My spreadsheet is designed to track whether our freelancers have accepted work. I want to track which work they have turned down. Each row represents a work offer, and I want to have a column which tracks which freelancers have turned it down. Is there a way to mirror this data on a separate sheet which will remove blanks (as not all work offers will necessarily be declined), so that I can then perform a VLOOKUP on the work offer code and have a sheet which tracks these declines where I can record why they turned it down?

So for example, say Column N is “Offered to and declined”, and of 10 work offers, 3 are declined. I want to enter the names of the people who declined the work offer into Column N, and have a separate sheet where I can view the Work offer code and the name of the person who declined it, without having the blanks from the work offers which were accepted with no declines. I can then have a column which explains why they turned it down, and track the reasons why people turn down the work offers.

I don't know if what I'm trying to do is even possible, but I'm having real trouble working out how to do this. Any help is appreciated, so thank you in advance.

 

[MARK858]

Use Autofilter to filter for non-blanks, select the whole range then Ctrl-G, special, visible cells, ok then copy and paste.

 

[anarchyflag]

Sorry, I don't think I was clear enough - I don't want to copy and paste it every time. I want it so that when I enter a decline on my main spreadsheet, the data automatically enters on the separate sheet that so-and-so declined this work. So I want to mirror the contents of Column N onto another worksheet and have it automatically filter out the blanks. Does that make sense?

 

[MARK858]

So if it is a copy when you enter Decline where does the ommitting/filtering out the blanks come into it?