Hello there,
I want to make an office Excel data analysis template
And make the source outside file.." Week Sales"
Like make button * Upload Sales*
1. Week sales
^^^^^
Need
I- Auto Recalculate and analysis Template to show results.
* Hope i can connect it automaticaly with no needs to copy and paste sales data
How to do that please?
===
Q 2..
How to replace massive data easily at excel automated...
Lets say i have old pos system category not uprgadable
And i want to make the analysis with the new category ...
So
We have sales file with old category
Code... category ... sales
New file index
CODE .... Category
Q; how to replace the exact category of code with the new one?
I want to make an office Excel data analysis template
And make the source outside file.." Week Sales"
Like make button * Upload Sales*
1. Week sales
^^^^^
Need
I- Auto Recalculate and analysis Template to show results.
* Hope i can connect it automaticaly with no needs to copy and paste sales data
How to do that please?
===
Q 2..
How to replace massive data easily at excel automated...
Lets say i have old pos system category not uprgadable
And i want to make the analysis with the new category ...
So
We have sales file with old category
Code... category ... sales
New file index
CODE .... Category
Q; how to replace the exact category of code with the new one?
