Displaying summary data on a second sheet based on a IF or TRU test?

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?

Hello johnzimmerman,

Welcome to the Forum!

When requesting help, please be specific and provide examples or post a workbook. Solutions often depend on how the data is arranged. It will also get you a faster answer if person providing the solution doesn't have to recreate your data. Post an example of the data layout on both sheets or post a sample workbook for review.

Sincerely,
Leith Ross