Oct 02 2021 01:46 PM - edited Oct 02 2021 01:56 PM
Oct 02 2021 11:19 PM
@JStender1994 Well, you'll have to give a bit more information. What is "nee/updated information"? Can you share the Excel file (or at least a representative example of it)? Can you share the CSV file, or at least part of it? What text needs to be extracted from that CSV and how does it need to be incorporated in the Excel document?
Oct 02 2021 11:46 PM
@JStender1994 Hi. Assuming Excel 365;
Connect to the csv by
Data: Get Data: From File: From Text/CSV...
[Choose the file]
Click Load
You will have your data in a "Table".
Select a cell in the table and you will have a new menu, Table Design where you next time can do a Refresh (also by typing Ctrl+alt+F5)
Oct 04 2021 09:52 PM
May 03 2022 03:28 PM