Excel report generation dashboard (mulitple files with data brought into new workbooks)
$30-250 USD
Paid on delivery
I have 2 files which are stored in SharePoint and are edited directly in Excel.
One file has up to 40 columns and 1000s of rows; the second file has up to 20 columns and 1000s of rows.
I would like to be able to create new workbooks (like a snapshot) of selected criteria at a given time. I require a separate excel file I can open that will allow to execute such actions that will poll the information from both files, and using the criteria presented at execution build the snapshot workbook. This may be a report for one supplier, or all suppliers in a given month etc to generate the data.
For each action we need to specify the columns it will export to each sheet and how it will be ordered and presented.
This project will act as a guide and the work offered will help me apply the VBA and logic to the real data.
For the attached sample sheets I have an example below to illustrate what I need to be able to do:
Set critera on a form (manufacturer, data ranges (or all) and create a new workbook with an orders sheet and deliveries sheet that matches the criteria I'd like to be able to sort the orders by status (custom order if possible) and deliveries by status (custom order if possible).
The file will need to be saved to a specifed location with a name format such as 'YYYY-MM-DD - Snapshot - Manufacturer [login to view URL]'
These files need to be sent externally which is why I need to export selected data to new workbooks. This is excel based and is not likely to be moved to a database/web app type setup anytime soon.
I would like 4 variations of my needs to be produced in this project- 4 different report types that can be ran with appropriate files to be produced.
Ideally, an ability to configure conditional formatting to some of the output or pivot tables would be a definite bonus!
Project ID: #4201694
About the project
22 freelancers are bidding on average $171 for this job
Pls only consider my bid, if you can assign higher budget to your project. If not, good luck! Regards, Svet.
I know how daunting it is to try and describe what you are wanting. I have been doing my contracting work with VWorker/Freelancer for the past 3 years, I had completed 70 projects ranging from Excel VBA to SQL Server More
Hello, I am offering you to make this project in the next couple of days. Please see PM for details.
Hi, I can do the job, MS Excel VBA expert, Software developer for a several years I am looking forward to work with you Best Regards Diego
Hi , I can do almost anything in excel vba (forms, butons,automate pivot tables, ). If you need me contact me. Best regards!
Dear Sir/ Madam, If you wish to get your work done accurately and timely you can rely on me. I'm here to provide you a better service possibly by meeting all your criteria. Please check the private message for detaile More
I have extensive programming experience and can complete this project in a professional and timely manner.
Dear Sir, I'm an experienced developer as you can see from my profile and I have the time and knowledge required. Best Regards, Elisa Resina
Hello, I'm an Excel Expert, and I havve developed a lot of Excel applications and tools. I can do this work correctly, faster and cheap.I can guarantee you that this work will be like you want.