
Completed
Posted
Paid on delivery
I need a single Excel file, compatible with my Microsoft 365 (always on the latest update), that behaves as a lightweight task-tracker: • Two worksheets: “Open” and “Completed”. • Columns on both sheets must be identical—Date Created, Created By, To Do Item, Date Completed and a Completed checkbox. • A user ticks the checkbox in the “Open” sheet to mark a task done. The moment it is checked, the workbook should: – Stamp Date Completed with today’s date, – Cut the entire row from “Open” and append it to the bottom of “Completed”. --Date entered as d/m/yy and formatted as dd/mm/yyyy • Row order has to stay tidy without manual intervention: – “Open” is sorted by Date Created, oldest tasks at the bottom. – “Completed” is sorted by Date Completed, newest items at the bottom. • Apply conditional formatting that highlights any task in “Open” whose Date Created is more than X days old (let’s default to 7, but make that easy for me to change later). Feel free to employ VBA, Office Scripts or dynamic array formulas—whichever runs reliably in Microsoft 365 desktop. The solution should avoid external add-ins so the file remains portable. Deliverables: 1. The finished .xlsx or .xlsm file ready to use. 2. A brief, step-by-step note inside the workbook (or separate PDF) explaining where the code lives and how I can adjust the “overdue” threshold or add new columns in future. I’ll test by adding sample tasks, checking a few off and confirming they relocate and re-sort automatically without breaking formatting.
Project ID: 40776237
19 proposals
Remote project
Active 6 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

Hello, I HAVE REVIEWED YOUR PROJECT, AND I AM READY TO START WORKING IMMEDIATELY. I am an expert in Excel creation and formatting, Google Sheets creation and formatting. I am an expert in Excel data categorization, merging and consolidation I am an expert in form creation using Excel and Google Sheets. I am an expert in trackers. I am an expert in formulas and functions, conditional formatting, pivot tables, data visualization and dashboards, charts and graphs. I am an expert in data analysis, income and expenses trackers, timeline trackers, and Gantt charts. I offer unlimited revisions and guarantee 100% satisfaction. Let's discuss the details in chat.
$10 USD in 1 day
4.7
4.7
19 freelancers are bidding on average $21 USD for this job

Hi there, I went through your project description and understand you need a reliable Microsoft 365 task tracker that automatically moves completed tasks, stamps completion dates, maintains sorting, and highlights overdue items. I will build the workbook with matching Open and Completed worksheets, consistent columns, and the requested date formats. I will use VBA in an .xlsm workbook to handle checkbox interactions, stamp the completion date, move completed rows, preserve formatting, and maintain the required sort order automatically. I will also add conditional formatting for overdue tasks, with the default seven-day threshold stored in an easy-to-change settings cell. The workbook will include clear instructions explaining how to use the tracker, adjust the threshold, and extend the columns without breaking the automation. I will test task creation, completion, row relocation, sorting, date formatting, and overdue highlighting in Microsoft 365 desktop to ensure the workflow behaves consistently. To confirm the best implementation, will the workbook be used primarily in desktop Excel, and do you need multiple users to update it simultaneously? Kind Regards, Imran Ali
$50 USD in 1 day
3.9
3.9

I can build a reliable Microsoft 365 task tracker that automates task completion, date stamping, row transfers, sorting, and overdue highlighting, eliminating repetitive manual updates. I’ll create the Open and Completed worksheets with identical columns, checkbox-driven task movement, the required date formats, and an easily adjustable 7-day overdue threshold. I’ll also include clear instructions explaining the automation code, how to change the threshold, and how to add columns without breaking the workflow. Thank you for considering my proposal. I have gone through the requirements in detail. I have uploaded samples similar to this project completed by me earlier in my profile. With 10+ years of experience as a Chartered Accountant (ICAI) and CPA, I bring strong Excel automation, VBA, and reporting expertise to deliver a practical, well-documented solution. Payment & delivery assurance: ✅ No upfront payment ✅ Release payment after completion or milestone ✅ Regular update related to project ✅ Timely delivery ✅ 100% commitment to project completion I’ll ensure the workbook is easy to use, maintain, and test, with no external add-ins required. Would you prefer VBA-based automation in an .xlsm file for desktop use?
$20 USD in 1 day
3.2
3.2

Hi there! We've recently helped a client streamline their task management system with an automated Excel workbook. I will assist you in creating a clean and user-friendly task tracker that meets your specifications. I understand you need a solution that seamlessly cuts and appends tasks, sorts automatically, and highlights overdue items, all while remaining fully compatible with Microsoft 365. My expertise includes Excel automation, VBA programming, and creating efficient workflows, ensuring your project is completed reliably and effectively. I bring real experience as I'm building my profile here, so every client gets my full attention, clear communication, and reliable delivery. I would love to chat with you about your project and hear more about what you’re looking to achieve. There’s absolutely no pressure, the worst that can happen is you walk away with a free consultation and a few helpful ideas for your project. Regards, Melissa
$10 USD in 7 days
0.0
0.0

Hello! Your Open/Completed to-do workbook for Microsoft 365, ready 2 days after the award (first working file on day 1). You pay us nothing until you've seen it working. Here is what you get: • Tick the checkbox on "Open": Date Completed is stamped and the row moves to the bottom of "Completed" • Both sheets keep the same five columns; dates typed d/m/yy show as dd/mm/yyyy • "Open" and "Completed" re-sort themselves on every change, with no manual step • Overdue highlight driven by one cell (default 7 days) that you change in a second Good to know: the automation is VBA, so the file is .xlsm and Excel asks you to enable macros once. We check the logic on sample rows and write the how-to note inside the workbook. ✅ Included: 3 small changes within 3 weeks after you approve the work, and we fix any bug of ours for free. Bonus: a short "Notes" sheet showing where the code lives and how to add a new column without breaking the move-and-sort. Price: $15 for the whole job. One question: should "Created By" fill in automatically from the Windows user name, or do you type it? P.S. Oldrich, the owner, supervises the work and stands behind every result. We use various tools and AI agents to work fast and efficiently.
$15 USD in 2 days
0.0
0.0

Hi there,I am a highly skilled Excel professional with extensive experience in data management, advanced formula development, dashboard creation, automation, reporting, and business intelligence solutions. I can transform complex and unorganized datasets into accurate, interactive, and actionable reports that support informed decision-making. My expertise includes Pivot Tables, Power Query, VBA/Macros, data cleansing, conditional formatting, lookup functions (VLOOKUP, XLOOKUP, INDEX-MATCH), financial modeling, KPI dashboards, and automated reporting systems. I focus on delivering efficient, error-free solutions that save time, improve productivity, and provide meaningful insights from your data. I am committed to understanding your specific requirements, maintaining clear communication throughout the project, and delivering high-quality results within the agreed timeline. My goal is not only to complete the task but to provide a scalable and reliable Excel solution that adds long-term value to your business. Thanks Gdev
$20 USD in 7 days
0.0
0.0

Hi, I'll send you a free sample Open sheet with the 7-day overdue highlight and checkbox-triggered row move so you can test it before paying anything. The sample will handle d/m/yy entry formatted as dd/mm/yyyy and stamp Date Completed on check. Send me a few sample tasks and I'll send back the working Open sheet.
$33 USD in 10 days
0.0
0.0

Being a Data Entry and Data Processing expert, I have developed a deep understanding of Excel's potential. I'm confident that I can deliver the focused, reliable, and easily maintainable Excel workbook you're looking for, even with your detailed requirements. I've worked extensively with Excel Macros and VBA which are powerful tools to accomplish your preferred automation quickly and accurately. Besides, as a freelancer for over five years, my clients have always been satisfied with my prompt delivery of quality work without any hidden charges – and that's precisely what I'll bring to your project. The way that I structure my work will save you a lot of time and effort in the long run. Everything will be clearly documented, stored in your workbook and backed by an additional step-by-step note or separate PDF highlighting the code location, allowing you to easily update the “overdue” threshold or add new columns whenever needed. on time and completed to perfection
$25 USD in 1 day
0.0
0.0

Hello, I'm based in Japan, blending strong technical skills and rich experiences on Excel VBA with Japanese discipline, punctuality, and attention to detail. I'll work efficiently to complete your project perfectly, and as quickly as possible. Unfortunately, I can't write full description in this by character limit of this site and so I hope we can discuss more detail in direct chat. Looking forward your response, Warmly Regards.
$30 USD in 1 day
0.0
0.0

You need one Microsoft 365 workbook with identical "Open" and "Completed" sheets (Date Created, Created By, To Do Item, Date Completed, Completed checkbox) where ticking the box stamps today's date, moves the row to the bottom of "Completed" and keeps both sheets sorted. How I'll build it: 1. Two Excel Tables with the native M365 checkbox, dates entered d/m/yy and shown dd/mm/yyyy. 2. A Worksheet_Change macro in the "Open" sheet module: stamp Date Completed, append the row to "Completed", delete it from "Open", re-sort both tables, with events disabled during the move so formatting never breaks. 3. Conditional formatting driven by a named cell "OverdueDays" (default 7), plus an "Instructions" sheet explaining where the code lives, how to change the threshold and how to add columns. We can split it into Freelancer milestones: first the move-and-sort logic, released only once you have tested it with your sample tasks. I'll send a first progress update within 24 hours. One question: if a task is unticked in "Completed", should it move back to "Open"? Deliverable: the ready-to-use .xlsm plus the in-workbook guide.
$16 USD in 3 days
0.0
0.0

New York, United States
Payment method verified
Member since Apr 4, 2009
$30-250 USD
$30-250 USD
$30-250 USD
$30-250 USD
$30-250 USD
$15-25 USD / hour
₹750-1250 INR / hour
$15-25 USD / hour
₹750-1250 INR / hour
₹750-1250 INR / hour
$250-750 USD
$15-25 USD / hour
₹750-1250 INR / hour
₹750-1250 INR / hour
₹1500-12500 INR
₹750-1250 INR / hour
₹400-750 INR / hour
$15-25 USD / hour
₹12500-37500 INR
₹750-1250 INR / hour
$50-100 USD
$15-25 AUD / hour
$30-250 USD
₹1500-12500 INR
€30-250 EUR