Re: Wanting to link inputed data to a paragraph on a different sheet

Tech-Archive recommends: Speed Up your PC by fixing your registry


Gary Brown Wrote:
> Assuming your data in rows 8 to 52 is in columns A and B, put the
> following formula in column c on rows 8 to 52:-
>
> =IF(AND(ISBLANK(A8),ISBLANK(B8)),"",TEXT(B8,"$##")&" "&A8&"; ")
>
> Then in the cell where you want the description:-
>
> $10 Because I said so; $16 Who is asking;
>
> enter the following:-
>
> =TRIM(C8&C9&C10&C11&C12&C13&C14&C15&C16&C17&C18...........&C52)


WOW I'm impressed, works like a dream!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Thank you so much!!


--
caliskier
------------------------------------------------------------------------
caliskier's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=25887
View this thread: http://www.excelforum.com/showthread.php?threadid=502534

.

Quantcast