Forum Discussion
Excel help
Thank you for the quick reply. JKPieterse
I was checking and I don't think that he does exactly what I need. Let me explain better what I need.
The user will have a generic Excel file where they put some details. According to the details the Excel will show some figures.
I would like the user to have the possibility to have a Word document with some of the details they put in the excel file.
I thought opening a second sheet in the excel file and copy the content of the word file to a text box. The issue is I cannot link several cells inside the text box, I only can link one text box to one cell of the excel file. I wanted within the text box link several data from different cells.
I don't know if I made myself clear and I don't know if this is someway possible.
Thanks.
Alex
You could prepare an Excel cell with all the information that you want to get displayed in Word , by using string functions. Like this:
="The value in cell A1, formatted with two decimals is: " & TEXT(A1,"0.00")&CHAR(10)&"And the value of cell A2, formatted as a date is: " & TEXT(A2,"dd/mm/yyyy")