Find Jobs
Hire Freelancers

Creating an Excel formula to aggregate underlying reports into a master report based on conditions - Repost - open to bidding

$10-30 USD

Closed
Posted over 7 years ago

$10-30 USD

Paid on delivery
I need someone to create the most effective formula to pull underlying reports (business cases) into a master consolidated file based on a Yes / No Condition of whether those financials should be included in the total. The master file needs to pull through identically formatted reports i.e. a standard Balance sheet, Profit and Loss and Cash Flow from up to 8 individual business streams / business segments and aggregate them based on the Yes / No Condition of whether they should be included in the scenario or not. I have uploaded a simple template example. I would like someone to make the formula work for this example. I can then copy it over to all files. I only need a working example of the formula that I can then apply. I don't need all the files updated. The formula needs to say if the condition is Y then pull the data from the corresponding Filename, worksheet and cell dynamically referenced from the list of file names.
Project ID: 11482762

About the project

11 proposals
Remote project
Active 7 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
11 freelancers are bidding on average $28 USD for this job
User Avatar
Hello, I have been working as freelancer since last ~ 3 years,prior to this was working with a MNC as an Sr. Software Professional. The project is Product based development and integration of the product with various already existing Products and processes.. Below are some key areas of my skills: -- VBA and Excel,Word,Office Applications -- Expert on C# using .NET framework using Visual Studio 2012 and 2013 -- Expert in ASP.NET,MVC -- Expert in VB.NET using VS2012/VS2013 -- WPF and Windows Forms Application I have experience in all the above areas and during my project work I have completed all of the above tasks. As a Freelancer also I have worked in few of the above areas where I got a chance and delivered the best. Delivering best & Customer satisfaction is the key for any individual and I always worked keeping these things during project execution. Would be looking forward to work on this opportunity and will ensure to deliver best. Regards, Abhinov
$30 USD in 2 days
4.9 (25 reviews)
5.1
5.1
User Avatar
I have 7 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server databases. And also I have worked on extraction with websites like Amazon, Cellpex,Costco,etc., hope if awarded with this project I can make it best and better with maximum 100% accuracy and satisfaction. please award me this project and contact me for further details
$55 USD in 2 days
5.0 (21 reviews)
3.9
3.9
User Avatar
I have experience in MS Office, VBA Programming, XML, MS Work, Google Docs, SQL, Google Spreadsheet, Data Entry in Odoo, Google Document and other related applications. I believe my capabilities would be perfect for your project. I can complete this job within the necessary period. I have years of encounter in this work and can offer you my past taste work. I will be offering you with all my effort and capabilities. “Moving ahead, I can dedicate 35 hours/week for your job, and my daily hours are negotiable. I’m very empowered to offer my services for your job. Please you can get in touch with me instantly to discuss this place further.” I am mostly online at Yahoo Messenger, Google Talk and Skype. We can discuss there in details, if you are interested. I wish you'd give me this chance. Regards, Mohsan Ijaz
$35 USD in 1 day
5.0 (13 reviews)
3.7
3.7
User Avatar
Dear Project Poster, I have relevant hands on 5 years of experience .We have a team of all the skills. I assure you about the work quality and time delivery. Please give me chance to complete this project. I Have 100% completion ratio. I had already done the same work in past. Looking forward to hear from you. Let me give an opportunity to work. We can talk further when you message me.
$34 USD in 1 day
5.0 (8 reviews)
3.8
3.8
User Avatar
Hi, I am familiar with data analysis and Excel VBA. Please feel free to contact me with more details about your project. Thanks,
$25 USD in 1 day
5.0 (6 reviews)
3.3
3.3
User Avatar
Thanks for posting the job, having carefully gone through the project description, I believe I can handle your work in a well structured, accurate and compelling style which will surely surpass your expectation. As a university graduate, with working experience in data entry, Microsoft office, typography , Excel to name few, I will gear up the necessary skills required for the proper handling of your project, and you will be surprised at the delivery. I will deliver the work on-time, and of course cheaper rate, so I look forward to chatting with you about this project sir, Thanks.
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi there. I am an Israeli student from Berkeley with significant experience in data analysis. I am currently on a trip to India and in need of some moolah to carry on. The project you talked about sounds interesting to me. Can we discuss the project over chat or maybe a call and then we could decide if you wish to award it. Cheers!
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I will do it as soon as posible. Looks pretty easy and I need to build my portofolio, so I will charge the minimum. My pay would be a good grade :)
$10 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi , I gone through your requirements but I dint find any attached file here. Can you share with me those files and I will tell how it can be done, Later you award me project. I am an Engineer with 8 years or experience. And from last 8 years I am also working on Data Entry/ Excel. I feel I can call myself as an expert in Copy Typing/Data Entry/ Excel. I have created many Macros for my organization. Being a corporate employee I believe in fulfilling client's expectation. Please give me a chance to prove my self. Please don't hesitate in giving me offline message in chat if I am not available for the moment,as I am following my mail id constantly, I can login here in seconds.
$19 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I work as BI Developer. I do a lot of automation in Excel and love to work with macros. I am sure I can help you with what you need. Just let me know. Wish you a great day! Sergiu.
$25 USD in 2 days
5.0 (1 review)
0.0
0.0

About the client

Flag of INDONESIA
Muara Bungo, Indonesia
0.0
0
Member since Sep 6, 2016

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.