I am a private individual based in England with a data analysis problem.
I download access files daily and import them into 4 excel files.
I need a master workbook created with an automatically generated workbook and approx 50-60 worksheets(named with filtered and sorted data from 1 of the Spreadsheet).
The workbook and worksheets will then be populated with data that is filtered, sorted and analyzed with formula, colour coded and then distributed into the relevant worksheets.
I will need a dashboard to activate the Workbook and sort and filter information within each worksheet (all worksheets will have same filters/analysis)
31 freelanceria on tarjonnut keskimäärin £118 tähän työhön
Hi, it will be a quick turnaround! I can create a macro for u which will copy the sorting and analysis for all ur worksheets at a time! will you please send me a message to discuss it :) Thanks, RK.
Respected Client I am expert in ms excel and provide automatic processing data between ms excel and ms access. please send your files and discuss more. check my portfolio and proceed. Thanks & Best Regards
Hi. By using excel Power Query, it can automatically do the data retrieval, cleansing, formating for you. And it's easy for maintainance. Please discuss for the detail. Johnny
Hello Dear I am data analyst using Python, Tableau and Excel I can make dashboard for your data in nice way You can check my previous work privately before hiring me Regards