Thanks, basically I have a summary sheet which I want to display data of
"current in progress works". On the other worksheet I have the a column that
tells me which company is in progress (100 companies) so what I want to do is;

on worksheet 2 read colum O3 if there is a 1 (meaning in progress) then take
the company name A3 and display it in summary sheet cell B5, the O and A rows
always are the same so if O33 has a 1 A33 is always the company that relates
to that cell, I have seperate IF statements for each row at this point.

Now not all 100 companies will be "in progress" so to avoid a bunch of void
cells under each other I want to put all result in B5 (summary sheet) under
each other so its a clean flowing list

Does that make sense?

Thanks for your help in advance
Neall


--
Neall


"Pete_UK" wrote:

A formula can only affect the cell that it is in - you can't "push"
data to another cell. Perhaps if you could give us some more detail of
what you want to do, we might be able to help you further.

Pete

On Jun 22, 2:28 pm, Neall wrote:
I am creating a bunch of if statements but want the results to return to
cells on a different worksheet

Thanks in advance
--
Neall