Excel help

AlexP1980
Copper Contributor
Dec 06, 2023
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
- JKPieterse
  Silver Contributor
  Dec 08, 2023
  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")
- peiyezhu
  Bronze Contributor
  Dec 07, 2023
  The issue is I cannot link several cells inside the text box,
  
  one to many structure in Excel sheet?
  
  https://www.bilibili.com/video/BV1Tm4y1K7Ug/?buvid=XX85E838539534AD650323D79CEE8DA100517&from_spmid=default-value&is_story_h5=false&mid=FSMZLyVVbtrPTKay0%2Fc9Fg%3D%3D&p=1&plat_id=116&share_from=ugc&share_medium=android&share_plat=android&share_session_id=4d02aea5-46dc-4a48-af6d-7da449e41e91&share_source=COPY&share_tag=s_i&spmid=main.ugc-video-detail.0.0&timestamp=1701924103&unique_k=eVNSI0p&up_id=634143044
  
  have a Word document
  
  How about Excel.sheet as template rather than Word document?

Forum Discussion

Resources