| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Wanting to link inputed data to a paragraph on a different sheet
We are making a spreadsheet that we are going to give to another department to fill out. They will fill in an amount and an explanation. We need this data to link into one cell in paragraph form if possible. For example they will enter in column D the explanation, and in E the amount like below: Because I said so $10 Who is asking $16 I want it to show in the other paragraph cell: $10 Because I said so; $16 Who is asking; The row numbers are 8-52 and the difficult thing is that some rows will be skipped meaning they might enter data in row 8 and 9, and then skip to 33 and 34 then skip again to 45. I have tried using & and in formulas to combine and space things out, but two problems, no $ show up with the numbers in the paragraph and with the skips we end up with several spaces where it looks like this $10 Because I said so; $16 Who is asking; Can anyone help here -- caliskier ------------------------------------------------------------------------ caliskier's Profile: http://www.excelforum.com/member.php...o&userid=25887 View this thread: http://www.excelforum.com/showthread...hreadid=502534 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Wanting to link inputed data to a paragraph on a different sheet
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) -- Gary Brown ------------------------------------------------------------------------ Gary Brown's Profile: http://www.excelforum.com/member.php...o&userid=17084 View this thread: http://www.excelforum.com/showthread...hreadid=502534 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Wanting to link inputed data to a paragraph on a different sheet
Assume cell numbers:
A B 1 | Because I said so $10 2 | Who is asking $16 Formula =B1 & " " & A1 & ";" & " " & B2 & " " & A2 & ";" The " " puts the spaces in your sentance. "caliskier" wrote: We are making a spreadsheet that we are going to give to another department to fill out. They will fill in an amount and an explanation. We need this data to link into one cell in paragraph form if possible. For example they will enter in column D the explanation, and in E the amount like below: Because I said so $10 Who is asking $16 I want it to show in the other paragraph cell: $10 Because I said so; $16 Who is asking; The row numbers are 8-52 and the difficult thing is that some rows will be skipped meaning they might enter data in row 8 and 9, and then skip to 33 and 34 then skip again to 45. I have tried using & and in formulas to combine and space things out, but two problems, no $ show up with the numbers in the paragraph and with the skips we end up with several spaces where it looks like this $10 Because I said so; $16 Who is asking; Can anyone help here -- caliskier ------------------------------------------------------------------------ caliskier's Profile: http://www.excelforum.com/member.php...o&userid=25887 View this thread: http://www.excelforum.com/showthread...hreadid=502534 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Wanting to link inputed data to a paragraph on a different sheet
I just saw that you have tried that.
I not quite sure about the spaces, but adding the $ can be used through the & function. ="$" & B1. "caliskier" wrote: We are making a spreadsheet that we are going to give to another department to fill out. They will fill in an amount and an explanation. We need this data to link into one cell in paragraph form if possible. For example they will enter in column D the explanation, and in E the amount like below: Because I said so $10 Who is asking $16 I want it to show in the other paragraph cell: $10 Because I said so; $16 Who is asking; The row numbers are 8-52 and the difficult thing is that some rows will be skipped meaning they might enter data in row 8 and 9, and then skip to 33 and 34 then skip again to 45. I have tried using & and in formulas to combine and space things out, but two problems, no $ show up with the numbers in the paragraph and with the skips we end up with several spaces where it looks like this $10 Because I said so; $16 Who is asking; Can anyone help here -- caliskier ------------------------------------------------------------------------ caliskier's Profile: http://www.excelforum.com/member.php...o&userid=25887 View this thread: http://www.excelforum.com/showthread...hreadid=502534 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Wanting to link inputed data to a paragraph on a different sheet
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...o&userid=25887 View this thread: http://www.excelforum.com/showthread...hreadid=502534 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Wanting to link inputed data to a paragraph on a different sheet
Bob Wrote: I just saw that you have tried that. I not quite sure about the spaces, but adding the $ can be used through the & function. ="$" & B1. "caliskier" wrote: We are making a spreadsheet that we are going to give to another department to fill out. They will fill in an amount and an explanation. We need this data to link into one cell in paragraph form if possible. For example they will enter in column D the explanation, and in E the amount like below: Because I said so $10 Who is asking $16 I want it to show in the other paragraph cell: $10 Because I said so; $16 Who is asking; The row numbers are 8-52 and the difficult thing is that some rows will be skipped meaning they might enter data in row 8 and 9, and then skip to 33 and 34 then skip again to 45. I have tried using & and in formulas to combine and space things out, but two problems, no $ show up with the numbers in the paragraph and with the skips we end up with several spaces where it looks like this $10 Because I said so; $16 Who is asking; Can anyone help here -- caliskier ------------------------------------------------------------------------ caliskier's Profile: http://www.excelforum.com/member.php...o&userid=25887 View this thread: http://www.excelforum.com/showthread...hreadid=502534 Thanks for your help, yes I tried that, but what happens is it inserts a ton of spaces for skipped cells -- caliskier ------------------------------------------------------------------------ caliskier's Profile: http://www.excelforum.com/member.php...o&userid=25887 View this thread: http://www.excelforum.com/showthread...hreadid=502534 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
| Append the data given in diff sheets of an Excel File to one sheet | Excel Worksheet Functions | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
| Automatic cell increment with data from sheet 1 to sheet 2 | Excel Worksheet Functions | |||
| pull data from sheet two, then fill in the data to sheet one (part | Excel Worksheet Functions | |||
Linear Mode
