Sorry about the bad explination, Looking to have A1 scan down col. B for
text. Once it finds texts copy that text to A1, then have A2 scan down col.
B for text, etc. etc. Overall goal is to make a detailed invoice summary
sheet that will scan each invoice page for the line items without having to
look at each invoice page by page. I really appreciate the help and dont
know if this is possible, but have struggled with it for 3 days.

"tim m" wrote:

I had a bit of a tough time knowing exactly what you want from the info you
gave. (As in what do you want to put in A1 if B1 is not text.)

Give this a try in anycase and see if it is what you want. Put this formula
in A1 and then copy it down for as many rows of B as you have. IF the B cell
is test it will display that text in A, if not it just sticks a blank in A.

=IF(ISTEXT(B1),B1,"")

"CLibby" wrote:

Trying to figure out an equation -- I need cell A1 to fill-in by data from
column B, if B1 has text fill in A1, if B1 doesnt have text, move to cell B2,
etc. etc,,,,but if B1 has text and fills in A1, need A2 to replicate A1
procedure starting with B2, etc,etc. If someone can help me out or let me
know if it is even possible I would appreciate it.