Find Jobs
Hire Freelancers

Excel Macro Basic Coding skills required

₹600-1500 INR

Completed
Posted almost 6 years ago

₹600-1500 INR

Paid on delivery
I have a master sheet which collates files from a chosen folder. I need some changes/additions to the existing code. 1>Attached Sheet Master 2>Attached Sheet Sample 1 (DR 17th) 3> Attached Sheet Sample 2 (RR 18th) Sample 1 and sample 2 will always be in the same format. Currently i have shown only two sheets. in real life I will have multiple number of sample sheets. also the number of columns filled in the sample sheet will vary. Sample sheets are locked with password 'lb' Save sample sheet in a folder and master sheet in a different location. ON sheet1 of master execute the macro, and this collates data from sample1 and sample 2 sheets in a new tab on master sheet.. Changes required 1> Everytime when data gets collated in master sheet the new tab where data is collated should be equal to todays date 2> column A cell 1 of master sheet (on the tab where data is collated) has the file name of the sample [login to view URL] file name should be present in column A all the way down till there are data points for that particular sample sheet 3> For data points of each sample sheet which gets collated in master sheet, if the value in column I is 0, that particular row should be deleted (shift up, so that there are no gaps between) 4> Any completely Blank rows within a sample data collated in the master sheet should get deleted. If you use the current sheet you will see a blank row in row8 5>Journal number column should be filled. every sample data set should have an incremental journal number starting 10001. once a journal number has been assigned, it should update the jounal number in the journal tab in master. The next time when the master is run again, it should pick up from the last journal number, add 1 and use this journal number for the next samples. Each sample should have a unique journal number 6> There should be a blank line in between each sample consolidated in master 7> Except for the 1st sample, headers for each sample should be deleted 8> For each sample consolidated in the master sheet, sum up the values in column I. If the values don't add up to ZERO (0) then that journal number should be updated in Sum Error tab. If no errors in sum, then sum tab to be hidden. If error the sum tab is unhidden and user get a msgbox after execution of macro, "There are errors in your sum" and the activesheet after end of macro should be sum error sheet Once macro is executed, the master sheet should save itself. Journal number tab should be hidden. I am also attaching sheet final master to show how the final output after your code should look like (this sheet is called final output). Please read the requirements carefully. My budget is INR 2500 only. So if you bid above that I will not be considering your bid.
Project ID: 16746159

About the project

5 proposals
Remote project
Active 6 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
Sounds like a project right up my alley. I can deliver by Monday morning. Let me know if you want to proceed
₹2,500 INR in 2 days
4.9 (3 reviews)
3.7
3.7
5 freelancers are bidding on average ₹2,361 INR for this job
User Avatar
Greetings for the day!! We have experience working on this subject. We ensure 100% QUALITY with ON-TIME Deliveries. Please allow us to take this opportunity. Thanks & Regards, Team@The24CarrotsInc VBA/EXCEL 100% Satisfaction Of Deliverable
₹5,555 INR in 1 day
4.9 (51 reviews)
5.6
5.6
User Avatar
"Dear Next Employer We will give you the best result by using my Past experience and excellent academic skills on your project. You can chat with me and let's get started, I'm ready to show you samples of similar projects I've completed. Thanks
₹1,300 INR in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello sir, I am interedted in your project. I would like to discuss details via pm. Yours sincerely,
₹700 INR in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
₹1,750 INR in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of INDIA
Mumbai, India
5.0
1
Payment method verified
Member since Apr 3, 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)
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.