Link to home
Start Free TrialLog in
Avatar of Nirvana
NirvanaFlag for India

asked on

work allocation; web development; vba; access;

I download a report (to excel) from a website every half hour (by clicking on specific drop-down);

update the file into a master spreadsheet (shared workbook)
allocate work to team members  (Example i receive 100 rows in excel allocate to 5 members manually by updating their name in column)
each individual open the master file update the status as "Completed", "WIP", "not started, "etc"

I want to automate the process by

1: automatically pull the data from website
2: auto updates to excel
3: allocate based on number (if i have 5 members and received 50 new rows should be allocated as 10 to everybody)
4: team should be able to update status
5: build a dashboard for status

current challenges: excel get crashed, if multiple team updates in the same row of shared workbook it takes last updated one, takes lot of times to open

Question:

what will be the best solution

1. Building a web app if so any resources would be of great help
2: MS access database with GUI and how can I do it?
3:  Excel macro

or are there any tools which does the ask

thank you
Avatar of JesterToo
JesterToo
Flag of United States of America image

Although I don't have experience in using Excel in this manner, my research thru the internet indicates that this usage is problematic... for instance, Microsoft says:  https://support.microsoft.com/en-us/kb/2735548

I think either option 1 or 2 is quite workable... option 3 is not likely to improve on your current situation.

Using Access would probably be the simplest, although maybe not the most robust, solution.  If you have the ability I would recommend option 1.  A small database with a simple web front end.  You could then "pull" data from the db with any number of tools to create your dashboard.
Avatar of Nirvana

ASKER

Thanks a lot Jester. could you please help with some resource on webapp

what technology to use (.net,java,php etc;,)
are there any similar sites or apps which you are aware


Thank you
ASKER CERTIFIED SOLUTION
Avatar of JesterToo
JesterToo
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial