
Completed
Posted
Paid on delivery
I maintain a production workbook in Excel 365 and need a small VBA routine that changes how the cursor moves in two adjacent columns on every sheet. • In the first of those columns, pressing Tab or Enter should move the active cell one row down and one column to the left. • In the second column, the same keys should move one row down and two columns to the left. Because the columns sit side-by-side, the logic can key off the active cell’s column index. I want this to work across the entire workbook, with no disruption to normal navigation everywhere else. Please deliver a clean, well-commented macro (Workbook or Worksheet event—whichever is more robust) along with a brief note explaining how to install and, if needed, remove or edit the code.
Project ID: 40613328
74 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
74 freelancers are bidding on average $98 USD for this job

Hi There, I can create a clean, well-commented VBA solution that customises the Tab and Enter key behaviour exactly as required across your entire workbook, while leaving normal navigation unchanged elsewhere. I'll also include clear instructions on how to install, edit, or remove the code. I'm ready to start immediately.
$30 USD in 1 day
8.7
8.7

As a highly skilled data analyst and Excel expert, I have extensive experience creating innovative solutions through the use of VBA macros. Your project aligns perfectly with my skillset. Having had to process vast amounts of data for various clients over the years, I have honed my abilities in data processing, Excel applications and macros to streamline workflows and enhance productivity. In past projects similar to yours, I've successfully developed intuitive VBA routines that significantly increased data navigation efficiency. In your case, the macro I will build will intelligently adjust the cursor movement based on column index, providing a seamless experience without disrupting normal navigation elsewhere in the workbook. My commitment to providing quality work along with clear and concise documentation makes me an ideal choice. With my solution, you will receive a clean and well-commented macro along with a brief note detailing installation instructions, editing options and removal steps if needed. Let's not only improve your current workflow but also ensure easy adaptability and scalability for any future needs. Let's discuss further on how my expertise can dovetail with your vision.
$140 USD in 1 day
7.7
7.7

Hi, I am Noyon from Global Service 24/7. I have experience with Excel VBA and automation. I can create a clean, well-commented VBA solution that customizes the **Tab** and **Enter** key behavior based on the active column, works across the entire workbook, and leaves normal navigation unchanged elsewhere. I'll also provide simple installation instructions and explain how to modify or remove the code if needed. I'm ready to start immediately.
$150 USD in 2 days
7.2
7.2

Hi there, I understand you need a lightweight VBA solution that customizes Excel's Tab and Enter navigation for two adjacent columns while leaving the rest of the workbook's behavior unchanged. I am confident I can implement a clean, reliable event-driven solution that works seamlessly across every worksheet in your Excel 365 workbook. My approach will be to implement a Workbook-level event that detects the active cell's column and intercepts the navigation logic only for the two specified columns. Depending on the active column, pressing Tab or Enter will move the selection one row down and either one or two columns to the left, while all other cells retain Excel's normal navigation. The code will be well-structured, thoroughly commented, and designed to minimize conflicts with existing workbook functionality. I'll also test the behavior across multiple sheets to ensure consistent performance. The deliverable will include a well-documented VBA module, installation instructions, guidance for modifying or removing the macro, and a tested workbook that behaves exactly as specified. Before I proceed, could you confirm the exact column letters that require the custom navigation, or should the macro detect them dynamically based on their current position? I'm ready to start immediately. Warm Regards, Aneesa.
$80 USD in 1 day
6.9
6.9

As-salamu alaykum, valued client. Being well-versed in Excel and Excel VBA, I believe I'm a perfect fit for your project. I've successfully tailored numerous complex macros to meet clients' specific needs while ensuring they do not disrupt any existing functionalities. My deep understanding of data processing has allowed me to develop clean and efficient codes that deliver the desired results – just like you're asking. My experience in bookkeeping, account reconciling, and data entry has honed my understanding of organizing and manipulating data in Excel, which is crucial for creating an effective macro. I guarantee a clean and well-commented macro that will navigate through the adjacent columns in your entire workbook, without interfering with any other areas. In addition to providing you with the custom-made navigation macro, Icomprehensive note on how to install, edit, or remove it from your workbook. In summary, my expertise in Excel VBA combined with my dedication to quality work ensure that you get precisely what you need within the agreed timeframe. Let's bring efficiency and ease to your production work – choose me for this job.
$30 USD in 1 day
7.1
7.1

Hi, I understand you need a reliable Excel 365 VBA solution that customizes Tab and Enter navigation only for two specific adjacent columns while keeping normal workbook navigation unchanged elsewhere. I have experience creating VBA automation, Excel event-driven solutions, and custom workbook workflows. I can provide a clean, well-commented macro using the most robust event approach, with logic based on the active cell’s column index and clear installation/removal instructions. The solution will be designed to work across the entire workbook without affecting standard Excel behavior outside the targeted columns. Best regards, Muhammad Usman
$220 USD in 3 days
6.7
6.7

AVAILABLE TO START IMMEDIATELY..,,. I will deliver a robust, well-commented VBA macro for Excel 365, precisely handling the custom cursor navigation across all sheets in your production workbook, along with clear installation and management instructions. 10+ years Advanced Excel experience, Certified VBA Programmer, MBA.
$51 USD in 1 day
6.6
6.6

Hello, I am an Excel VBA specialist who will create a clean, well‑commented macro for your workbook that changes cursor movement in two adjacent columns: in Column X (specify), Tab/Enter moves one row down and one column left; in Column Y, moves one row down and two columns left — keyed off the active cell's column index. I will use a Workbook_SheetSelectionChange or a Worksheet_Change event. I will provide installation instructions and removal/editing notes. Please specify the two column letters. I can start immediately. Thank you. Regards, Zafar
$65 USD in 1 day
6.2
6.2

With over 8 years of experience under my belt, I have honed my skills in Data Processing, Excel, Excel Macros, and Excel VBA to a great extent. Having completed 900+ projects with a five-star rating, I know exactly what it takes to deliver a successful assignment – both in terms of exceeding client expectations as well as adhering to deadlines. I assure you of the same level of accuracy and carefulness for your project in creating the navigation macro for your production workbook in Excel 365. My deep understanding of Pivot Tables, Advanced Formulas, Charts, and Dashboards will come handy in figuring out the right way to address the issue you're facing efficiently. Moreover, my breadth of experience with Python will ensure that you receive a clean and well-commented macro - fully tailored to your needs. Since you've emphasized that this needs to work across all sheets in your workbook with no disruption to normal navigation, it's important for me to relay that my ability to create robust solutions is unrivaled. In summary, choosing me for this assignment would provide you with not just a quick and accurate solution but also an opportunity to work with someone who understands the need for clear communication throughout the process along with regular updates and a respect for confidentiality. I believe that my skills are perfectly aligned with this project’s requirements and that I possess the proficiency needed to complete it successfully.
$40 USD in 1 day
5.4
5.4

Hello I can create a clean VBA solution that customizes Enter/Tab behavior for the two adjacent columns across all worksheets while leaving normal navigation unchanged elsewhere. The code will be well-commented, robust, and include simple installation, editing, and removal instructions. Regards Muhammad
$100 USD in 1 day
5.5
5.5

Hi, I can develop a clean, well-commented VBA solution that works across your entire Excel 365 workbook. The macro will detect the active cell's column and customize Tab and Enter behavior only for the two specified adjacent columns: * First target column: move one row down and one column left. * Second target column: move one row down and two columns left. * Everywhere else, Excel's normal navigation will remain unchanged. I'll use a robust workbook-level event, keep the code easy to maintain, and include concise installation, editing, and removal instructions.
$30 USD in 2 days
4.9
4.9

With over 9 years of experience in Data Processing and data analyst, I perfectly align with your requirements of creating a custom Excel Navigation Macro. I am well-versed in VBA and have a profound knowledge of Excel functions and formulas. Your project aligns directly with my specialization in Excel management and data processing. I have worked extensively on similar assignments before and have honed my skills at building robust macros that perform flawlessly without hampering normal functionality. Being familiar with the navigation inside-out, I can provide you with a neat, concise code along with detailed instructions for smooth installation and modify when needed. My commitment to accuracyand meticulous approach will guarantee a bug-free solution that satisfies your requirement:tab and enter operations shifting one row down and one column to left and two columns respectively across the entire workbook while ensuring no disruption elsewhere .Let's work together to streamline your Excel process!
$150 USD in 2 days
5.1
5.1

Hi, I got that you are looking for a custom Excel navigation macro in Excel 365 that changes the cursor movement in two adjacent columns on every sheet. This is what I can help you with, let's chat. My approach is to create a VBA routine using Worksheet events to precisely control the cursor movement based on the active cell's column index. By utilizing VBA, I will ensure seamless navigation in the specified columns without disrupting the standard Excel navigation functions. The outcome will be a user-friendly solution that enhances efficiency in your production workbook. Before final delivery, I will conduct thorough testing to refine the macro for optimal performance. As final deliverables, you will receive a well-commented macro that meets your specific requirements and a detailed guide on how to install, modify, or remove the code as needed. One thing I'd like to confirm before we start: Do you have any preferences for the macro's user interface or additional functionalities? Looking forward to discussing this further with you. Regards, Imran
$90 USD in 1 day
4.5
4.5

i am macro navigation expert, can you please come to the chat box so we can easily discuss in details, and start this will be finish today soon , thanks
$155 USD in 1 day
4.8
4.8

Hello, I can create a clean, reliable VBA solution that customizes the behavior of the **Tab** and **Enter** keys for the two specified adjacent columns while leaving navigation everywhere else in your workbook unchanged. The solution will: * Detect the active cell's column and apply the appropriate movement logic. * Move the selection **one row down and one column left** in the first target column. * Move the selection **one row down and two columns left** in the second target column. * Work consistently across every worksheet in the workbook using a robust event-based approach. * Include clear, well-commented code that is easy to maintain and modify in the future. You'll also receive concise installation instructions, guidance on how to edit the target columns if your workbook changes, and simple steps to disable or remove the macro if needed. I focus on writing maintainable VBA code that integrates cleanly with existing workbooks and minimizes interference with normal Excel functionality. I can deliver a tested solution that is ready to use.
$80 USD in 1 day
3.7
3.7

As an experienced full-stack developer with a strong command over Excel and Excel VBA, I am confident in my ability to deliver the solution you need. I completely understand that your workbook's macro, which modifies the default navigation behavior in two specific columns, must blend seamlessly with the rest of your workflow without causing any disruption elsewhere. I assure you that my extensive experience in API Development & Integrations along with Automation & Data would be instrumental in building such a macro. Throughout my career, I have emphasized on building scalable and high-performing software while ensuring maintainability and clean architecture - traits that are vital for VBA macros. Moreover, my core proficiency in Excel will help me create a clean and well-commented codebase for your project. Additionally, I give utmost priority to communicating effectively with my clients at every stage of the project, thereby giving them complete control over their requirements.
$50 USD in 3 days
3.5
3.5

Your workbook needs custom Tab and Enter behaviour in two adjacent columns while preserving Excel's normal navigation everywhere else. I'll implement this using a robust Workbook event that checks the active cell's column index and redirects the cursor exactly as required, without affecting any other cells or sheets. The code will be clean, well commented, and easy to maintain, and I'll include clear instructions for installing, editing, or removing it whenever needed. If you'd like the behaviour to apply only to specific sheets or be easily configurable later, I can structure the code accordingly. Let's discuss the workbook layout so I can tailor the solution precisely.
$30 USD in 1 day
3.7
3.7

As an experienced Excel specialist, I have developed a keen eye for customization, automation, and macros within the Microsoft suite. Your project aligns perfectly with my skill set and expertise, enabling me to deliver a clean and well-commented macro for your production workbook. With over five years of experience in data automation, my approach is meticulous to ensure 100% accuracy and zero disruption to normal navigation throughout your workbook. Additionally, my background in accounting and bookkeeping affords me an analytical mindset that is perfect for understanding and implementing the specific requirements you've outlined. Being able to tailor solutions to unique business needs has long been a hallmark of my work, ensuring that your custom VBA routine functions optimally even as the workbook evolves. Client satisfaction is always paramount to me, so I'll provide you with a step-by-step guide on how to install the macro into your workbook. In case of future edits or removals, you can also rely on my support. Working together, we can elevate your production process with efficient and error-free results—all while maintaining prompt communication and an affordable cost structure.
$50 USD in 2 days
3.0
3.0

Thank you for considering my proposal. I have gone through the requirements in detail and understand that you need a VBA event-driven solution that customizes Tab and Enter key navigation for two adjacent columns across every worksheet while leaving standard Excel navigation unchanged elsewhere. I have 7+ years of experience in Excel, VBA automation, and workflow optimization. I can develop a clean, efficient VBA solution that detects the active cell’s column and automatically moves the cursor: * First target column: one row down and one column left. * Second target column: one row down and two columns left. The macro will be implemented using the most reliable workbook-level event approach, ensuring it works consistently across all sheets without affecting normal behavior outside the specified columns. The code will be fully commented, easy to maintain, and optimized for Excel 365. You’ll also receive a brief installation guide explaining where the code resides, how to modify the target columns if your workbook changes, and how to disable or remove the feature whenever needed. Payment & delivery assurance: ✅ No upfront payment ✅ Release payment after completion or milestone ✅ Timely delivery ✅ 100% commitment to project completion Profile: https://www.freelancer.com/u/caajoys?sb=t I’m ready to start immediately and can deliver a robust, well-documented VBA solution with a quick turnaround. Best regards.
$75 USD in 3 days
2.9
2.9

I've implemented workbook-wide navigation macros in Excel VBA for production workbooks before, so this is right in my wheelhouse. I'll build a `Workbook_Open` event handler to wire up sheet-level `KeyDown` events, then validate column indices and adjust cursor position accordingly. The macro will use exact column checks to avoid disrupting normal navigation elsewhere. No add-ins or external dependencies—just pure VBA with clear comments for maintenance. I can start immediately. Thanks, Andrii.
$200 USD in 2 days
2.2
2.2

Southampton, United States
Payment method verified
Member since Nov 8, 2023
$30-250 USD
$30-250 USD
$10-11 USD
₹600-1500 INR
₹750-1250 INR / hour
$250-750 USD
$30-250 USD
₹1500-12500 INR
$30-250 USD
$30-250 USD
₹1500-12500 INR
₹750-1250 INR / hour
$10-30 USD
₹750-1250 INR / hour
₹600-1000 INR
₹750-1250 INR / hour
₹12500-37500 INR
₹600-1500 INR
$30-250 USD
₹100-400 INR / hour
₹750-1250 INR / hour
€30-250 EUR