Description of excel work: While we have significant expereince using Microsft excel we want to create a relationship with a Microsoft Excel/ Access consultant to help us develop an excel/ access model. I have created a simple mock up of the type of model we want to create and included it below. The finished model will contain more information and templates however at first we would like to understand how to create this version.
Our initial issues are in understanding how to create:
1 An automatic upload of a new sheet for each company where the information is correct despite the directors shareholding creating varying amount of rows for each company.
2 Dashboard information and detailed specific template for each company
3 Link to outside excel worksheets to bring information across if necessary and display symbol
4 Create graphs in dashboard
Tadhg D.100% (1)
Create an account now and send a proposal now to get this project.Sign up
Clarification Board Ask a Question
For your worry of automatic upload of data into your excel workbook,you have option in excel called connection.
Using this we can automatically import your different company data and compute and generate dashboards.