Find Jobs
Hire Freelancers

Excel Macro Expert need

$2-8 USD / hour

Closed
Posted 11 days ago

$2-8 USD / hour

I have given Start time, Interval, End time in excel When i give start time(Ex:9:15), when that time reached E col data automatically copied in into G col, Next Interval is 10 Mins, When 9:25 reached E col data automatically copied in into H col, When 9:35 reached E col data automatically copied in into I col,When 9:45 reached E col data automatically copied in into J col, When 9:55 reached E col data automatically copied in into K col, When 10:05 reached E col data automatically copied in into L col, When 10:15 reached E col data automatically copied in into M col.(H col vale > G col, that cell is green, H col vale < G col, that cell is red, same process for all col) 9:15-9:25 is 1 10Mins during that time, how many time(count) E col value>G col value( Ascending not decending) Default value is 1, when e col value less than G col and comes again > G now count value is 2 same process for all 10 mins count( I have given any start time, Interval, end time, It will automatically copy the data and process the given time duration. Note: I dont know about coding, If you install the code and run successfully at my system thereafter I will hire you and release the payment. If you agree this term you will apply this task Budet is 300 INR and Good review, Dont expect more I am not big fish. it is difficult job dont come for Money you should waste you time for unrealish Expectation
Project ID: 38024653

About the project

13 proposals
Remote project
Active 5 days 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
13 freelancers are bidding on average $5 USD/hour for this job
User Avatar
Hi There Nice to know your requirement. I have delivered more than Two Hundred Excel Automation Projects in the past five years. Can discuss and work with you to get this task done. Thank you. Durai
$15 USD in 40 days
5.0 (196 reviews)
7.1
7.1
User Avatar
I am Kamal, a seasoned Excel professional with a decade of in-depth experience in formulas, macros, and VBA scripting. Your project aligns perfectly with my core strengths and I am confident in delivering an efficient and tailor-made solution to automate your data-copying needs. My proficiency extends beyond mere proficiency in formulas. I am deeply knowledgeable about over 115 Excel functions, including precisely those that you require to establish the relationship between E and G columns. This understanding allows me to employ my expertise to optimize your process for speed and accuracy. Moreover, I believe in sharing my Excel passion and empowering others through knowledge transfer. With over 250 professionals under my wing, I have curated bespoke training programs that facilitated their growth and skill enhancement. Together, we can take your data processing needs from manual labor to intelligent automation. Let's transform your spreadsheets!
$4 USD in 2 days
5.0 (4 reviews)
2.5
2.5
User Avatar
مرحبا أنا منه يمكنني فعل ذلك العمل باحسن جوده وبأقل سعر وفي أسرع وقت يمكنني فعل هذا العمل بكاءة وفاعلية ممتازه ويممكني أيضا أن اعمل هذا العمل بدون مقابل اتمنا فقط أن أعمل هذا وشكرا لك
$5 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I can write the program for you on your terms, if it works for you only than you may release the payment.
$3 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I'm excited to submit my proposal for the Excel automation task you've posted. With my extensive experience in Excel and automation, I'm confident I can deliver a solution that meets your requirements effectively and efficiently. Here's how I plan to tackle the task: 1. **Dynamic Data Input**: I'll set up the spreadsheet to allow input of start time, interval, and end time. This will enable easy customization and adaptation to different timeframes as needed. 2. **Automated Data Population**: Using Excel formulas, I'll create a system where, at each interval (e.g., every 10 minutes), the data from column E will be automatically copied into the corresponding column (G, H, I, etc.). Additionally, I'll implement conditional formatting to highlight cells in green when E col value is greater than G col value, and in red when E col value is less than G col value. 3. **Incremental Counting**: I'll devise a mechanism to track and increment the count each time E col value exceeds G col value within each 10-minute interval. This count will be displayed prominently, providing real-time insights into the data trends. With my expertise in Excel automation and attention to detail, I'm confident I can deliver a high-quality solution that meets your specifications. Thank you for considering my proposal. I look forward to the opportunity to work with you and deliver a solution that exceeds your expectations. Warm regards, Naeem
$2 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hey, One-liner: please confirm you need an Excel Macro, I don't think so. If yes, I am excited to create required macro for you in your budget IRN 300 + a good review. I’m Azhar, excel of Excel Macro guy for making Excel work wonders for you. I’ve spent over ten years turning complex data into clear, useful spreadsheets through Macro / VB Script. I will bring to the table: • • Macro for excel to excel (report generation etc.) • • Macro for excel to word (agreement generation etc.) • • Macro for excel to PDF (PDF creation etc.) • • Macro for web to excel (data scraping) and more.... Let’s talk about how I can help you with Excel. And remember, first-timers get a discount! Cheers, Thank you, • Azhar
$5 USD in 40 days
5.0 (1 review)
0.0
0.0
User Avatar
As an experienced full-stack developer, I have the necessary skill set to tackle your Excel Macro project with ease. My proficiency in Excel, Excel Macros, and Excel VBA combined with coding languages such as Python will ensure the successful implementation of your desired functionalities. I know you don't have knowledge in coding, but don't worry, I will install and run the code successfully on your system before you make any payment. My expertise not only includes Excel Applications but also extends to web scraping - a skill that can conveniently contribute to capturing and populating the data you need at specified intervals from E column to G-L columns. Additionally, my proficiency in programming concepts like iteration and data comparison perfectly aligns with your project's need for tracking count and color codes based on column values. Rest assured, I'll provide a seamless and efficient solution tailored to your specific interval requirements. In conclusion, I understand that you may require constant support post-installation of the code, and I assure you that I'm dedicated to client satisfaction. My reasonable budget expectation does not in any way compromise my dedication or quality of work. I value transparency and successful project completion above all else – expecting a good review from me at the end of this project.
$2 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am writing to express my keen interest in the appointment setup position in your company. With a strong background in customer service, administrative tasks & scheduling I am confident in my ability to contribute effectively to your team. You sent Thank you for considering my application. I am eager to discuss further how my background, skills, and enthusiasm align with the needs of your team. Please find my resume attached for your review. Warm regards,
$5 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Having worked with data for several years, I'm well-positioned to tackle your complex Excel macro project. My mastery of Excel, Excel Macros, and VBA programming will be instrumental in creating a functional and efficient solution. I've previously automated similar tasks, which gave me extensive knowledge on how to customize Excel to carry out calculations based on specific time intervals. For example, I've created macros to retrieve real-time data from APIs and recalculate it within specified ranges. My 'drive-for-results' nature aligns perfectly with your budgeting concerns; my primary focus is delivering value rather than exorbitant fees.I guarantee that the work will be handled professionally, meeting all your requirements within the budget stipulated. Through my career, I've honed an array of skills that make me not only a competent HR specialist but also an invaluable asset with regards to data analysis and management. Considering this, I am confident that my skills in Excel Macros/VBA programming, attention-to-detail, analytical abilities, and commitment to customer satisfaction make me the ideal fit for your project. With this skillset, you can trust that I will not only deliver this project excellently but also make complex data analysis easier moving forward. I look forward to discussing this further!
$5 USD in 40 days
5.0 (1 review)
0.0
0.0
User Avatar
Dear [client name], Thank you for considering my services! I have the skill set you need to make this project a reality. Given my substantial experience with data entry , I’m confident I can deliver top-notch content within your required time frame.
$5 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
i have understood your problem i can solve your problem with if you are interested we can discuss further more in chat box
$3 USD in 40 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of INDIA
Chennai, India
5.0
20
Payment method verified
Member since Nov 2, 2014

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.