csimpson24
New Member
- Joined
- Feb 22, 2018
- Messages
- 22
Hi all,
Here's my scenario. We have sales people who travel everywhere and sometimes VPN connectivity is limited. In our business system, we have a dashboard of their sales data that they want to copy into Excel to use while they travel. The spreadsheet needs to have formulas to calculate things such as profit, mark up, margins, etc. I have a couple of ideas to accomplish this. Dump the data from the dashboard to a CSV file, have a prebuilt spreadsheet containing the necessary formulas in the correct cells that is always linked to that CSV file. Possible?
Or
Have the prebuilt spreadsheet. They copy the data from the dashboard, paste into the spreadsheet while retaining the formulas. Possible?
If either is possible, I may need some help in doing so. Possibly.
Thanks in advance,
Chris
Here's my scenario. We have sales people who travel everywhere and sometimes VPN connectivity is limited. In our business system, we have a dashboard of their sales data that they want to copy into Excel to use while they travel. The spreadsheet needs to have formulas to calculate things such as profit, mark up, margins, etc. I have a couple of ideas to accomplish this. Dump the data from the dashboard to a CSV file, have a prebuilt spreadsheet containing the necessary formulas in the correct cells that is always linked to that CSV file. Possible?
Or
Have the prebuilt spreadsheet. They copy the data from the dashboard, paste into the spreadsheet while retaining the formulas. Possible?
If either is possible, I may need some help in doing so. Possibly.
Thanks in advance,
Chris