OK, I'll try to keep this tight.

Basically I have a 2 worksheet spreadsheet. One page is Public and the other is a Private page full of returned product information from our company and updated 2-3 times a day.

I'd like a way to enter a column on the private sheet where the Public page can run a test. If the test is positive ("1") the Public sheet will pull selected information from that row to display on the public sheet. If the test is negative ("0") the Public sheet will ignor that whole row.

I've found this:

try =if(isblank(cell to be copied)," ",(cell to be copied))

However, this won't work because of a couple reasons. 1 is that the formula above will end up leaving blank rows in my public spread sheet and the other is that I don't want to display the test column information but rather other columns of information in that tested row.

Any thoughts?