Find Jobs
Hire Freelancers

Modify Existing Excel Macro to add value of similar items and insert an entry in the sheet

₹600-1500 INR

Completed
Posted over 4 years ago

₹600-1500 INR

Paid on delivery
Hi I have existing excel macro workbook, when we open and select the excel file it will extract data from work sheets in the file and populate it into a sheet of macro workbook. Now i want help regarding the data populated into the macro workbook. Just we have to add similar data and add its value at the end of data items with the names i give you. You can find the results sheet in the attached macro workbook. we need to add product wise all tanks based on station name present in tank name. For Example in Tank names you will find station as Mundra and its product is H4, then we need to add all the tanks having m4 as product in Mundra and add an entry with a name and its value(sum of all).
Project ID: 21932875

About the project

16 proposals
Remote project
Active 4 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
Awarded to:
User Avatar
Hello ! My experience with vba is more than 10 years. I'll need to clarify a lot. For example, the "Clear Results" button does not clear the data - do you need to fix this ? It is also unclear how the names in the sheet "Results" and "Tank No" are taken - why is there "1(FR) - Mundra" and "2 (FR)-Mundra" etc. ? Thank You. Regards, Alexei.
₹950 INR in 7 days
5.0 (3 reviews)
2.1
2.1
16 freelancers are bidding on average ₹1,286 INR for this job
User Avatar
I am postgraduate with more than 6 years of experience in advanced excel based tools, VBA automation, google scripting and data processing. I have successfully completed similar projects, please have a look at my portfolio for details. I have developed excel based automation tools for Ernst & Young also. You can get your work done here with highest quality at lowest price. Looking forward to work with you
₹4,000 INR in 1 day
4.9 (35 reviews)
5.2
5.2
User Avatar
Hi, I can give you a solution which will give a summary of the data you have on the results sheet. It will be a table with the stations on the left column and Products in the top row. It will show the total stock per station for all the products. regards Reuben
₹900 INR in 1 day
5.0 (2 reviews)
1.1
1.1
User Avatar
Proven experience as data entry clerk Fast typing skills Excellent knowledge of word processing tools 3 years of experience with spreadsheets (MS Office Word, Excel etc.) Basic understanding of databases
₹1,200 INR in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, i am interested in your work. I am a dedicated and hard working person who believes in honesty and good working relation. Though I am new at this sector of job but I have certain qualities which makes me good at this.
₹1,050 INR in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello. This sounds like a job I could allocate around 15 hours a week for. I can start immediately, and I am highly skilled in using a computer and being precise. I can start immediately - reach out to me and let's get going.
₹1,050 INR in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Sri Lanka
₹1,300 INR in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
We can do it by adding lookups and formulas in macro. I will have to look into the sheet though.
₹1,350 INR in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
₹1,300 INR in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I am Tural. I would like to help you on your work. I did similar jobs before. I have enough experience.
₹600 INR in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi there, I like to be considered for your hire position. I'm a strategic freelancer with strong background expert in Office 365, including data entry, proof reading, social media post, and digital marketing work. I can turn an ordinary document in a way that represents the work and appeals to target with knowledge and principles. Whether you need a formal, serious or playful, I can make them work with an excellent outcome.
₹1,050 INR in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have done many macros for my office project. hopefully I can do to that macro has you requested... gives us chance....
₹1,150 INR in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello there, I can write macro for you that will selectively load data into desired worksheet. I will try to make it adaptable and flexible
₹1,029 INR in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I have been working with similar proyects for more than 5 years, job guaranteed and will support after delivering
₹1,050 INR in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of INDIA
Hyderabad, India
0.0
0
Payment method verified
Member since Jan 2, 2018

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) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
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.