Excel: create a report from 3 differrent excel files which either have codes (VN.net) or using pivot tables
$10-30 USD
Complété
Publié il y a environ 9 ans
$10-30 USD
Payé lors de la livraison
Dear Freelancer,
I need to get a final report out of my 2 different excel files. I am enclosing 4 screenshots to understand more better. Please check the content and screenshots before bidding. Make sure you understand what I need.
1. I am doing a daily update using Spreadsheet one (table 1), to receive a report of the updated data. That spreadsheet is using a VB.net coding and uses pivot tables, like seen in the sample file (table 1)
2. I am scraping data into spreadsheet two. that spreadsheet has VB.net coding to receive the wanted data (see table 3)
3. You will want to create a final report, which needs spreadsheet one and two to get the data. I wish to use an inputmask (like seen in table4), that I can use differrent opinions to what I want the results for.
I created a sample, for you to look at (please see tables 1-4) for better understanding.
Best would be to use spreadsheet two (matchestable (table 2)) to get the final report.
However, it may not be too wise to do since spreadsheet two is already using a VB.net code. I can use a third spreadsheet instead to get to the final report (see table 4)
After I put in the two values (pls see table 4) into the inputmask, I should get my final report by clicking a button.
If you have any further questions, please feel free to ask.
Good luck on your bidding.
Thank you
Thomas
Hello Sir,
I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree.
If you see I am among niche bidders who have 100+ completed projects with zero failed projects and a very high completion rated since I do not bid on projects which I am not certain of.
I will not disappoint you, please give me an opportunity to work with you. No milestones required. Pay me only when your job is 100% done. Also I will provide you with a working version of file before you consider awarding me the project.
Thanks,
Jay