
Đang mở
Đã đăng vào
•
Kết thúc sau 1 ngày
Thanh toán khi bàn giao
I keep all of my renewal data in a single Excel workbook, and every time I need to review information for a specific customer I have to re-apply filters manually. I want that entire routine collapsed into a single click. Here’s what I need: a lightweight automation—VBA, Power Query, or another native Excel approach—that sits inside the file and instantly filters the renewal dataset by customer whenever I press a button or choose a custom ribbon command. The solution must work in standard desktop Excel (Microsoft 365), recognise new rows automatically as the table grows, and preserve any existing formulas and pivot tables. Please deliver a working, macro-enabled version of the workbook (or a clearly commented code module I can import) along with a short set of instructions so I can update the customer criteria or move the code to other files in the future.
Mã dự án: 40275261
34 đề xuất
Mở nhận chào giá
Dự án từ xa
Hoạt động 3 ngày trước
Thiết lập ngân sách và thời gian
Nhận thanh toán cho công việc
Phác thảo đề xuất của bạn
Miễn phí đăng ký và cháo giá cho công việc
34 freelancer chào giá trung bình ₹5.969 INR cho công việc này

Hi, I will create a one-click Excel VBA solution that instantly filters your renewal data by customer, works in Microsoft 365, auto-detects new rows, and keeps all formulas and PivotTables intact. You’ll receive a macro-enabled file (or clean importable code) with brief instructions for future updates. Best Regards, Virendra
₹7.000 INR trong 7 ngày
6,2
6,2

Professional Excel VBA developer ready to do the required fast fliter macro for existing and future added data. All details will be covered properly Regards # sample form my works and clients' reviews from links below. https://www.freelancer.com/projects/excel/Excel-Auto-Execute-Macro-Upon/reviews https://www.freelancer.com/projects/data-processing/data-processing-use-mail-merge/reviews
₹5.000 INR trong 1 ngày
5,2
5,2

Hello, I am Ayesha, a Data Professional specialized in Excel automation and Power Query transformations, focused on building accurate, efficient, and reliable solutions. I’ll implement the most reliable solution: a clean VBA automation embedded directly in your workbook. Your renewal data will be structured as an Excel Table so it automatically expands as new rows are added. A lightweight macro will apply the required filters instantly with a single button click. Your existing formulas and pivot tables will remain fully intact. The solution will be built using standard VBA with no external dependencies to ensure smooth performance in Microsoft 365 Desktop. You’ll receive a macro-enabled file with clearly commented code, along with short instructions so you can easily adjust the customer criteria or reuse the automation in other workbooks in the future. To make sure I design this exactly right: 1. Will the same set of filters apply to all customers, or do certain customer types require different filtering combinations? 2. Are you using Microsoft 365 Desktop on Windows, and will the file be opened only in the desktop app (not Excel Online)? I look forward to collaborating with you. Best Regards, Ayesha Baloch
₹8.000 INR trong 3 ngày
4,1
4,1

Hi there, I will build a lightweight one-click filter inside your workbook (VBA + optional custom ribbon) so selecting a customer applies an auto-expanding Table filter instantly in Microsoft 365 while preserving existing formulas and pivot tables , my experience automating Excel and deploying macro-enabled workbooks makes me the right fit. - Deliverable: Macro-enabled .xlsm with a button + optional custom ribbon command that filters the renewal Table by customer. - Deliverable: Clearly commented VBA module (or importable file) and short instructions for changing customer criteria or moving code. - Quality control: Staged testing, table-bound references (ListObject) so new rows auto-detect, plus rollback instructions and non-destructive code to preserve formulas/pivots. Skills: ✅ Excel Macros ✅ Visual Basic for Applications (VBA) ✅ Table/ListObject automation & ribbon command integration ✅ Microsoft 365 / macro-enabled workbook deployment ✅ Preservation of formulas, PivotTable refresh, and reliable filtering Certificates: ✅ Microsoft® Certified: MCSA | MCSE | MCT ✅ cPanel® & WHM Certified CWSA-2 I’m available to start immediately; Which column header contains the customer name (exact text) and is your renewal data already an Excel Table (ListObject)? Best regards,
₹8.300 INR trong 1 ngày
3,9
3,9

Hi! I can build the one-click filtering system you need using a clean VBA macro or Power Query, depending on your preference. As someone experienced in automation, I will ensure the solution is dynamic, so it automatically recognizes new rows as your table grows without breaking. I will deliver a macro-enabled workbook and provide clear instructions on how to update criteria in the future. I can have this ready for you today. Best regards!
₹5.500 INR trong 7 ngày
3,4
3,4

Hello, I can build a lightweight, one-click automation inside your Excel workbook that instantly filters your renewal dataset by customer while preserving all formulas and pivot tables. My approach will: Convert your data range into a structured Excel Table so new rows are recognized automatically Add a clean VBA button (or custom ribbon command) that filters by the selected customer Keep the solution fully compatible with Microsoft 365 desktop Excel Include clear, well-commented code so you can update the customer criteria or reuse it in other files You’ll receive a fully working macro-enabled workbook (.xlsm) or a standalone code module ready to import, along with simple step-by-step instructions for future edits. Regards, Bakhtawar
₹1.500 INR trong 1 ngày
3,2
3,2

With a strong handle on various Microsoft Office tools, including Excel, I am confident in my ability to deliver a tailor-made, one-click solution for your renewal data management needs. My skills in VBA programming and Power Query will be particularly applicable here. I can create a lightweight automation platform that will effectively filter your renewal dataset by customer at the touch of a button or with a custom ribbon command. Having dealt extensively with Excel spreadsheets and data processing projects, I understand the importance of preserving existing formulas and pivot tables while automating processes. You can trust my ability to recognize new rows automatically as your table grows, delivering a highly efficient system that keeps pace with changes in your data set. As part of the result package, I will provide a clearly commented code module for easy importation and updating in future files. I am committed to delivering not just on-time but also error-free work, sparing you time lost dealing with corrections or reworking tasks. Invest in me for this project, Naresh, and you can expect excellence delivered with unwavering commitment and professionalism.
₹5.000 INR trong 1 ngày
2,9
2,9

Hi! Pleased to meet you on this platform. I just read through the job details and can help you with automation of your excel sheet. I have over 20 years experience with VBA. Let's discuss more on chat about your requirements and budget. Warm Regards. Bc
₹10.000 INR trong 7 ngày
3,0
3,0

@SahyadriTech #SahyadriTech Completed Projects: 1. Hotel Booking Management & Tracking System (Excel + VBA Script) 2. Appsheet: ERP system for textile business 3. MNGL Gas Incident Tracker & Dashboard (Google Sheets + Google Data Studio) 4. Daily Expenses Tracker (Google Sheets) 5. Option Scalping Strategy Automation (Excel VBA) 6. Nifty50 Live Option Chain Dashboard (Google Sheets) 7. Binary Trading Sheet (Google Sheets) 8. Customer Data Cleaning & Sorting Tool (Excel VBA & Python) 9. Historical Stock Closing Price Analysis for 2,600 Stocks (Excel & Python) 10. Power Bi dashboard for F1 Car racing insights 11. GOLD Loan tracking in Google sheet and Google Data studio 12. Local Taxi Tracking System (Google Sheets + Google Data Studio) 13. Appsheet Milk Drivers wages and attendance system (Appsheet + Google sheet ) Key Highlights: 1. Pay only if satisfied with the work 2. Expert in Power BI, Excel, VBA Macros, Google Sheets, Google Apps Script, and Python 3. Experience in 3 American MNCs 4. Skilled in Data Analytics, Automation, and Visualization 5. Proficient in Statistical Analysis 6. Offer Long-Term Support for all projects 7. Quick Delivery with multiple revisions I can deliver any project related to Data Analytics, Automation, and Reporting with precision and reliability.
₹7.000 INR trong 7 ngày
2,6
2,6

Dear Sir/Madam I am writing to express my strong interest in your project. With over 15 years of professional experience mastering Microsoft Excel and Word, I have developed a high level of efficiency and technical expertise. I am confident that I can deliver high-quality results that meet your specific requirements and exceed your expectations. My focus is always on accuracy, professional formatting, and timely delivery. Thank you for your time and consideration. I look forward to the possibility of working with you. Best regards, Sivagurunathan
₹7.000 INR trong 7 ngày
1,2
1,2

Hello, I can develop a lightweight VBA-based solution embedded directly in your Excel workbook that instantly filters your renewal dataset by customer with a single button click or custom ribbon command. The macro will dynamically recognize new rows as your table expands, preserving all existing formulas and pivot tables without disruption. To complete this project, I will: 1. Create a robust VBA script to apply and clear filters based on customizable customer criteria. 2. Add a user-friendly button or ribbon command to trigger the filtering instantly. 3. Provide a macro-enabled workbook or a clean, commented code module with clear instructions for updating customer filters or migrating the code to other files. May I ask if you prefer the button embedded in the sheet or the custom ribbon command for activation? Also, do you have any specific naming conventions for your tables or customer fields? Regards, George Esterhuizen
₹4.000 INR trong 14 ngày
0,0
0,0

I believe I am a good fit for this project because I have practical experience working with Excel on a daily basis, especially with filters, sorting, formulas, and data organization. I understand how important it is to make tasks simple and efficient, so creating a one-click renewable filter solution is something I can handle carefully. I pay close attention to details to make sure the data works correctly without errors. I am patient while testing and improving features, and I always try to deliver clean and user-friendly results. I am committed to completing the work on time and making sure it functions exactly as required.
₹7.000 INR trong 7 ngày
0,0
0,0

I can deliver a working, macro-enabled version of the workbook that instantly filters the renewal dataset by customer whenever pressing a button.
₹3.000 INR trong 3 ngày
0,0
0,0

I can create a simple and reliable Excel automation that will filter your renewal data for a selected customer with a single click. Using VBA or Power Query within Microsoft 365 Excel, I will design a lightweight solution that automatically recognizes new rows as your table grows while preserving all existing formulas, pivot tables, and workbook structure. I will also add a button or custom ribbon command to trigger the filter instantly. The final delivery will include a fully working macro-enabled workbook or a well-commented VBA module that you can easily import into other files. Additionally, I will provide clear step-by-step instructions so you can update the customer criteria or reuse the automation in the future without difficulty.
₹7.000 INR trong 6 ngày
0,0
0,0

Hello, I am an experienced Data Entry Operator with strong skills in Excel, Google Sheets, Data Processing, Data Cleaning, and accurate data management. I can complete your 2–3 day task efficiently with 100% accuracy and fast turnaround. I am detail-oriented, follow instructions carefully, and can start immediately. Please share the workflow—I'm ready to begin right away and deliver clean, organized, and error-free work. Looking forward to working with you.
₹7.000 INR trong 7 ngày
0,0
0,0

Lets hop on the 10 minutes call and analyze your problem perfectly. You're aiming to streamline renewal data reviews in Excel, eliminating manual filtering for each customer. This is achievable through structured VBA or Power Query implementation directly within your workbook, guaranteeing seamless integration and automated row recognition. Previously, I've automated similar Excel workflows for business owners to boost reporting speed by 40%. * Develop a single-click filter using VBA/Power Query. * Ensure compatibility with Microsoft 365 Excel. * Automate new row recognition. * Provide clear instructions for future updates. Message me to schedule the call, and let's turn that Excel routine into a single click.
₹2.500 INR trong 2 ngày
0,0
0,0

With a strong handle on various Microsoft Office tools, including Excel, I am confident in my ability to deliver a tailor-made, one-click solution for your renewal data management needs. My skills in VBA programming and Power Query will be particularly applicable here. I can create a lightweight automation platform that will effectively filter your renewal dataset by customer at the touch of a button or with a custom ribbon command. Having dealt extensively with Excel spreadsheets and data processing projects, I understand the importance of preserving existing formulas and pivot tables while automating processes. You can trust my ability to recognize new rows automatically as your table grows, delivering a highly efficient system that keeps pace with changes in your data set. As part of the result package, I will provide a clearly commented code module for easy importation and updating in future files. I am committed to delivering not just on-time but also error-free work, sparing you time lost dealing with corrections or reworking tasks. Invest in me for this project, Naresh, and you can expect excellence delivered with unwavering commitment and professionalism.
₹7.000 INR trong 7 ngày
0,0
0,0

Hello, I have strong experience working with Excel automation and data management. I can help you create a simple one-click solution that automatically filters your renewal data by customer. Using Excel automation and macros, I will ensure the solution works smoothly in Microsoft 365 and automatically recognizes new rows as your data grows. I will also preserve your existing formulas and pivot tables. You will receive a clean macro-enabled workbook along with clear instructions so you can easily update or reuse the solution in the future. I would be happy to review your Excel file and discuss the best approach for your requirement. Looking forward to working with you. Best regards Nagabhushana
₹3.000 INR trong 7 ngày
0,0
0,0

As a self-proclaimed "Excel wizard", I believe I can make your request come true seamlessly. Though my usual domain is data entry and restructuring, I am also well-acquainted with the power behind Excel's functionality through VBA, Power Query, and other native approaches. Given this, I can create a lightweight automation for you—a one-click wonder—that instantly filters your renewal dataset by customer, all initiated by simply pressing a button or selecting a custom ribbon command in standard desktop Excel (Microsoft 365). My familiarity with Excel also extends to recognizing new rows automatically as the table expands - an asset that would help preserve any formulas and pivot tables you currently have in place. My deliverable will not only be a working macro-enabled version of the workbook, but it will also include a comprehensively commented code module that you can effortlessly import to other files if needed. I am looking forward to the opportunity of putting my skills on display and providing you with an accurate, user-friendly solution that promises to greatly optimize your workflow. Let's get started!
₹2.000 INR trong 10 ngày
0,0
0,0

With 15+ years of experience streamlining data workflows in multinational retail, I specialize in turning tedious manual tasks into efficient, "one-click" solutions. I will automate your renewal dataset filtering to save you time and ensure data accuracy. Technical Highlights: Dynamic Data Handling: I will use Excel Tables (ListObjects) to ensure the macro automatically scales as your dataset grows. User-Friendly Interface: I'll set up a search cell or dropdown menu linked to a custom Ribbon command for instant results. Formula-Safe VBA: Using the native AutoFilter method, I will ensure that your existing formulas, formatting, and Pivot Tables remain perfectly intact. Portability: The code will be modular, allowing you to easily migrate the automation to other workbooks in the future. Deliverables: A ready-to-use .xlsm workbook. Fully commented VBA code for easy maintenance. A "Quick-Start" guide to updating customer criteria. My background in high-volume retail environments guarantees a professional, reliable, and lightweight tool that works every time.
₹8.500 INR trong 5 ngày
0,0
0,0

JHANJHARPUR, India
Phương thức thanh toán đã xác thực
Thành viên từ thg 3 3, 2026
₹1500-12500 INR
₹1500-12500 INR
$1500-3000 USD
₹750-1250 INR/ giờ
$30-250 USD
₹750-1250 INR/ giờ
$750-1500 USD
₹1500-12500 INR
$10-30 USD
$30-250 USD
$10-20 USD/ giờ
$30-250 USD
$8-15 AUD/ giờ
₹12500-37500 INR
₹1500-12500 INR
₹600-1500 INR
₹400-750 INR/ giờ
₹750-1250 INR/ giờ
₹1500-12500 INR
$250-750 CAD
₹100-400 INR/ giờ