Silva_Citizen
New Member
- Joined
- Jul 19, 2018
- Messages
- 3
Hi
I have a excel CSV file which is auto generated to the same file on the company server every day.
I have an excel workbook which contains a table of the exact information that is in the CSV file
This table (will) contain Pivot information which will drive a dashboard (including some lookup formulas tagged onto the end which relate to a different workbook)
My question is - can I get the workbook to update with the information from the CSV file automatically or with a simple refresh prompt.
Thank you in anticipation
I have a excel CSV file which is auto generated to the same file on the company server every day.
I have an excel workbook which contains a table of the exact information that is in the CSV file
This table (will) contain Pivot information which will drive a dashboard (including some lookup formulas tagged onto the end which relate to a different workbook)
My question is - can I get the workbook to update with the information from the CSV file automatically or with a simple refresh prompt.
Thank you in anticipation