Morshed_Dhaka
New Member
- Joined
- Dec 16, 2016
- Messages
- 42
Hi Everyone,
I am looking for a urgent support from anyone who can helps me. I am familiar how to work with excel and macro's. But right now, my problem is little bit complicated. Below is my problem details :
There is 3 excel file in our office network sharing server.
1 excel file is called " Collect Dashboard". 1 excel file is " Raw Data". 1 Excel file is "Master Dashboard"
Raw data file size is 5 MB. Master Dashboard file size is 16 MB. The process is I updated the data in raw data file regularly in the "Raw Data" file. I can open that file from my home as because the file size is less. The data in Master Dashboard is linked up the file " Raw Data". Problem is I can't able to open the Dashboard file from home as because of high file size and very poor net connection. So, I try to build up a macro in "Collect Dashboard" excel file that if somebody from my office wants to see the Updated Master Dashboard then he should open the Collect Dashboard file and click a macro. Then the macro will automatically open the 2 sharing file kept in the sharing server ( Raw Data & Master Dashboard), updated all the data, then save the Master Dashboard file and then, break all the link of master dashboard file, then by using save as command it will save a copy of the dashboard to the user desktop.
I hope, I am able to describe my problem. The problem is complicated and I almost did 80% solution. Seeking any expert help for finalizing it. Thanks in advance.
I am looking for a urgent support from anyone who can helps me. I am familiar how to work with excel and macro's. But right now, my problem is little bit complicated. Below is my problem details :
There is 3 excel file in our office network sharing server.
1 excel file is called " Collect Dashboard". 1 excel file is " Raw Data". 1 Excel file is "Master Dashboard"
Raw data file size is 5 MB. Master Dashboard file size is 16 MB. The process is I updated the data in raw data file regularly in the "Raw Data" file. I can open that file from my home as because the file size is less. The data in Master Dashboard is linked up the file " Raw Data". Problem is I can't able to open the Dashboard file from home as because of high file size and very poor net connection. So, I try to build up a macro in "Collect Dashboard" excel file that if somebody from my office wants to see the Updated Master Dashboard then he should open the Collect Dashboard file and click a macro. Then the macro will automatically open the 2 sharing file kept in the sharing server ( Raw Data & Master Dashboard), updated all the data, then save the Master Dashboard file and then, break all the link of master dashboard file, then by using save as command it will save a copy of the dashboard to the user desktop.
I hope, I am able to describe my problem. The problem is complicated and I almost did 80% solution. Seeking any expert help for finalizing it. Thanks in advance.
