Reflection unix macro vba jobs
Hello, We're looking for someone to help up integrate an online wholesale diamond catalogue with our premium Shopify theme The wholesale website: It's API documention: Our website: You'll see that our site is just a reflection of the Stuller catalogue, this is because it's using IFrames WHAT WE WANT: -For our site to look and feel like or something similar -To have access to the Stuller catalogue with Shopify's functionality -A shopping cart -A custommer service chat box -For the site to update it's inventory based on Stuller SOME THINGS TO NOTE: -Shopify has a payment integration system -We'll be based in Canada and the States for the only currency to worry about for
I'm in need of an experienced Photoshop expert to help remove unwanted reflections from a batch of 1-5 images in total. Key Requirements: - The main objective is to eliminate reflections on the images to ensure they are distraction-free. Final Deliverables: -...unwanted reflections from a batch of 1-5 images in total. Key Requirements: - The main objective is to eliminate reflections on the images to ensure they are distraction-free. Final Deliverables: - The final images should maintain the same resolution as the original ones. Ideal Skills and Experience: - Proficiency in Photoshop with a strong background in image editing. - Previous experience in reflection removal is a plus. - Attention to detail to ensure the final deliverables are of high quality and free from any...
I need a professional to Photoshop edit an image to remove a moderate lens reflection from glasses. The key requirements are: - You must work exclusively on the lens. The frame should remain intact. - The removed reflection should result in a natural-looking finish. There is no need for enhancement or black and white finishing. - I require someone with experience in editing glasses and managing reflections. Your ability to retain details and authenticity while removing reflections will be essential. Your role will involve assessing the intensity of the reflection and executing an expert removal without impacting the overall aesthetics of the glasses. Please submit your proposals along with similar projects you've worked on.
I'm looking for an expert in VBA and macros to help streamline my processes in Excel. Key Requirements: Shifts: Defined two shifts in the "task tap": Morning: 6:00 to 15:30 Afternoon: 14:00 to 22:30 Quality: Updated the agreed-upon columns in the "quality tap." And remove the error code if there is no any number Delays: Ensured delays are reflected as discussed. Task Order: Arranged tasks in the "task tap" from oldest to newest. Please review the file and let me know if you have any questions or require further changes. Requirements: 1- Required an option in this file (Excel) that when the planner change the completion date of any task in column K in the TASKS tap, the color of the cell will be changed to yellow, and a not...
I'm in need of an experienced Excel professional to help me build a secure data management system. This system will be used to handle both financial and customer information. Key Requirements: - **Data Security**: A robust system that...customer data. - **User Management**: The system should be designed for 1-10 users, allowing them to access and input data securely. - **User Experience**: While the users are expected to have advanced Excel skills, the system should be designed with clear interfaces and user-friendly features. Ideal Candidate: - Proven experience in designing secure data management systems in Excel - Proficiency in VBA and Excel's advanced features - Strong understanding of data security and privacy - Excellent communication skills to understand and mee...
I'm looking for an experienced VBA coder who can focus on two main tasks. 1. **Fixing Existing Issues:** - My current VBA code has issues with execution errors and incorrect results. I need solutions to these two problems. 2. **Adding Modifications:** - I'm looking for someone who can add additional features to my existing VBA code. - Good user experience is important too so improvements on the user interface would be very beneficial. Ideal candidates will have an excellent understanding of VBA syntax, debugging, and error handling. Experience with user interface design is also appreciated. The aim here is to produce accurate calculations, formatted data or reports swiftly and easily.
I'm looking to hire someone who can create an Excel VBA workbook to seamlessly integrate with my Zoho Desk setup. This workbook should be specifically engineered to perform the following: - Retrieve the required information from Zoho Desk tickets upon pressing a button inside Excel. Specifically, I need someone skilled in Excel VBA programming and API integration work to: - Design a user-friendly interface in the workbook where one can press a button to initiate the retrieval of ticket information. You should be able to retrieve the latest ticket, and then have two more buttons to go to next & previous tickets. - Implement secure API connections to Zoho Desk to enable the retrieval of ticket information usuing oauth. The fields I need are: Subject Account Name: C...
I'm seeking a proficient Excel VBA coder to create a system that automates data entry from Excel files. The task involves: - Creating a VBA function that can input data automatically into my current system. - Implementing a data sorting feature as part of the data entry process to ensure that all data is easily read and interpreted. The ideal freelancer should have the following skills and experience: - Proficiency in Excel VBA - Experience with automated data entry - A solid understanding of data sorting techniques. This project requires precision and attention to detail. It should not only meet the needs listed above but also enhance data accuracy and save time.
...include anything Marian, including references to approved apparitions (ie. Mary of XYZ, pray for us). Icons: Catholic Iconography Stained Glass Window: Abstract interpretations of stained glass windows found in Catholic churches, featuring geometric patterns and vibrant monochrome hues. Faith Quotes: Inspirational quotes or phrases from scripture, saints, or notable Catholic figures encouraging reflection and spiritual growth. Bible Stories: Illustrations or symbols from popular Bible stories, such as Noah’s Ark, David and Goliath, or the Nativity. Guardian Angels: Imagery depicting guardian angels watching over and protecting children. Sacraments: Symbols or representations of key Catholic sacraments like Baptism, Holy Communion, and Confirmation. Saints: Iconic figures f...
I'm seeking an experienced Excel VBA expert to help me automate some basic, repetitive data entry and formatting tasks. Key Requirements: - Automate basic data entry and formatting tasks in Excel - Develop VBA script to ensure automation runs smoothly Ideal Skills and Experience: - Proven experience in developing VBA scripts for Excel - Strong understanding of Excel functions and data formatting - Ability to create automation systems that run seamlessly without user interaction Please note, no user interaction is required for this project. The VBA program should be designed to run automatically once set up. This task is relatively simple but needs to be executed precisely and efficiently. Looking forward to working with a professional who can deliver ...
I'm seeking an expert in Excel and VBA who can work on an an existing financial model. The primary tasks will involve optimizing formulas, macros, and implementing data validation. I am looking for an hourly regular working engagement where the person will sit with me from time to time online and solve for things one at a time. I cant share workbooks as I have some IP related restrictions so person will have to work on my system, remotely. For Faridabad, Haryana based freelancers, we can do it in physical mode too. Key areas of focus will be: - Refining Formulas and Calculations. - Improving Data Organization and Management - Managing , improving the existing VBAs
...automating the transfer of information between those departments: linking the data, defining "trigger" events, and processing data from various inputs into "smart" trackers. I have a clear outline of what I want to accomplish - what data I need, who I need it from, and how I want the tracking of the inputs to function. My "coding" ability is a limited working-knowledge of JavaScript PDF and Excel VBA. I need someone to provide council and advise on what is possible, what tools or platform would be best for the end product I want to develop, and to advise on any alternatives. Basically, I am in the early stages of a long development process and I need an expert coder to review my outline and provide advise for the best way to accomplish what I want. ...
As an artistic family and motherhood lifestyle photographer, I am in need of a website that primarily showcases my photography portfolio. Here's what I'm looking for: - The site should be visually stunning – a reflection of my photography style. - It needs to have less than 5 pages. Clean and straightforward navigation is key. - No specific booking process will be included. I'll handle inquiries externally. Ideal candidates for this project have experience designing portfolio websites for photographers or other visual artists. Understanding of minimalistic aesthetics and the ability to create intuitive user experiences is paramount.
I require a VBA Developer well-versed in automating repetitive tasks in Microsoft Excel. Your primary task is to automate my existing work functions to increase efficiency. Key Responsibilities: * Understand the current Excel operations and identify scope for improvement. * Develop VBA codes to automate basic standard operations. * Test the robustness and accuracy of the automation. * Combining 2 files into 1 pdf. 1st file is pdf and 2nd is excel(with selected sheets, and selected columns within sheets) Desired Skills & Experience: * Proficient in VBA, specifically for Microsoft Excel. * Experience in automating repetitive tasks. * Sharp problem-solving and debugging skills.
Seeking a proficient Excel VBA developer to aid in the centralization and automation of tasks in Excel 2010. Project requirements include: - Expertise in Excel latest version - Strong understanding of EXCEL VBA for automation purposes. Please note, specific tasks and functions to be automated in VBA have yet to be defined. Flexibility and broad knowledge in different Excel functions will be considered an asset.
...products. The ideal display will seamlessly blend elegance with practicality, offering both aesthetic appeal and usability. Mobility is desired to facilitate versatility in placement within various environments. Key Features: 1. Elegance and Practicality: The display should exude a sense of refinement while ensuring practicality in showcasing our range of clinical skin care products. 2. Brand Reflection: Incorporation of elements that reflect our brand identity is essential, enhancing brand recognition and coherence. for Branding Changes: Design should accommodate potential changes in branding signs and skincare products, allowing for easy updates without compromising the display's integrity 4. Storage Space for Disposables: Provision of designated compartments for dis...
...essential to be an expert. Anyone with generic database experience (with different databases) can also apply. Skills already acquired from previously doing this work: - Understand database schema - understand database structures - create database tables based on bespoke requirements (training included) - Working with relatively large sets of data - has exporting skills into SQL - Excel and VBA, - Has experience in different querying languages - Proficient in Microsoft SQL Server Management Studio - Familiarity with Windows OS - Experience in handling multiple databases with SQL - Strong troubleshooting skills I currently manage over 11 databases via Microsoft SQL Server Management Studio, and my system operates on Windows. You would be working an 8hr paid day in the Austr...
I'm seeking an expert in Excel and VBA who can work on an an existing financial model. The primary tasks will involve optimizing formulas, macros, and implementing data validation. I am looking for an hourly regular working engagement where the person will sit with me from time to time online and solve for things one at a time. I cant share workbooks as I have some IP related restrictions so person will have to work on my system, remotely. For Faridabad, Haryana based freelancers, we can do it in physical mode too. Key areas of focus will be: - Refining Formulas and Calculations. - Improving Data Organization and Management - Managing , improving the existing VBAs
...seeking a skilled developer to create an advanced home affordability calculator. It should be able to utilize a range of user inputs and cater to diverse variables. Key Components: • Calculation of Property Tax, Homeowners Insurance, and HOA Fees • Ability to estimate the largest possible home purchase based on financial data • Consideration of interest rates and their possible fluctuations • Reflection of down payments and portfolio line of credit options Input Requirements: • Annual Income • Monthly Debts • Desired Mortgage Term • Potential Family Gifts • 401k Loan Ideal Skills: • Proficient in financial computing • Experience in creating similar financial calculators • Good grasp of real estate finance variable...
As my project deals intricately with WordPerfect, I'm in search of an experienced freelancer who knows the ins and outs of this software. - **Expertise Required**: In-depth knowledge of WordPerfect is a must. Your task will include document formatting, template designing, and macro automation. - **Application Criteria**: Please include proof of your expertise in WordPerfect in your application, such as a detailed description of a project you have worked on or a list of tasks performed using WordPerfect. Show me why you're the best candidate for this task! - **Note**: This project strictly requires WordPerfect skills only. Additional software expertise is not necessary for this particular project. Your exclusive proficiency in WordPerfect will be vital for the highest ...
I need a knowledgeable Excel VBA specialist, with a background in data manipulation and analysis, to create a custom macro for my spreadsheet. - The macro's primary function is to automate the creation of new rows based on certain numeric values, namely the ones found in columns E to L on a specific sheet in the workbook. - Upon row creation, data from columns A to D should be copied over to the corresponding new row on another sheet. - Additionally, the macro should automate the assignment of values in cells from L to Q based on the count of numbers in rows created. The assignment of values is to be done using a simple addition or subtraction formula. The ideal freelancer should have solid experience in creating advanced Excel VBA macros, and a strong...
...experienced MS Access developer to assist with my form development tasks. The ideal candidate is proficient in VBA (Visual Basic for Applications) coding and has the ability to design and implement forms based on my specifications. Key Responsibilities: - Designing and developing database structures based on my project requirements - Implementing VBA code for basic functionalities such as form submissions and data entry automation - Creating forms in MS Access based on a specific design I have in mind - Ensuring the database and forms meet quality standards and are user-friendly Ideal Skills and Experience: - Proven experience in database design and development using MS Access - Proficiency in VBA coding, particularly for basic functionalities - Previous experienc...
...believe my current photo and header may need an upgrade to attract the right attention. 2. Summary and Experience Descriptions: These sections need to be refined and tailored for the technology industry to ensure they are appealing and relevant to potential recruiters. 3. Skills and Endorsements: I want to ensure that the skills listed on my profile are well-represented and endorsed, giving a true reflection of my capabilities. Ideal Skills and Experience: - Proven experience in LinkedIn profile optimization, particularly in the technology sector. - Strong understanding of what recruiters look for in a LinkedIn profile, and the ability to optimize it accordingly. - Excellent writing and editing skills to refine the summary and experience descriptions. - Previous success in impro...
I am interested in creating an Excel VBA macro that will allow me to import PDF invoices into line items and parse them. The objective of this project is to streamline the process of invoice data entry by automating the extraction of key information from incoming PDF invoices, namely Invoice number, Vendor name, Pricelist, and Detail. The successful freelancer for this project should have: - Demonstrated experience in creating VBA macros for Excel - A strong understanding of PDF parsing and data importation - Knowledge of accounting principles is a plus The imported data should ideally be formatted in Excel as: - Each PDF invoice should be translated into a single row - The extracted information should be available in separate columns for each piece of information.
...YOU CANNOT WRITE EXCEL MACRO TO SCRAPE THE DATA. PYTHON SCRAPPER DON'T NEED I'm in need of a VBA developer who can help in creating a small code for scraping contact details from a specific website. The task involves creating a button in an Excel file that triggers the scraping process and saves the extracted data back into the same Excel file. Note : Project budget is only 6k because it will take max 2-3 hour for experience developer Key Requirements: - Scrape contact details from - Specifically, scrape Owner Name & Address - Implement a function where a user clicking a button triggers the scraping process - Save the extracted data back into the same Excel file Ideal Skills & Experience: - Proficient in VBA programming - Experience
...10 research questions that you may want to explore. Try to create a variety of different types of questions from the different quadrants of the Q-chart so that you can consider questions from different angles. Submit it to your teacher for feedback. PART B: Novel Reflection Please note, that this reflection is not connected to your research report. You will continue working on the report throughout the rest of this unit. This reflection is meant to help you consolidate your thinking about the final part of the novel. In a reflection post of approximately 250-300 words, respond to the following prompt: Now that you've finished your novel, identify and explain the theme of your novel (you may also think of this as the overall message). This is not the same...
We require a specialist Excel developer capable of designing an ERP worksheet that can facilitate efficient inventory management. Notably, this will be identified through its ability to: - Track product movements (Received from Dock, Moved to Location, Picked, RTS) - Forecast demand accurately - Calculate reorder points precisely (Flag Products that are low in stock) - Distr...Sequens is Location, Part, QTY) - Ensure daily inventory updates are possible (Inventory has to be LIVE) - Add a dashboard for visual view of KPI's and results The ideal candidate will have proven experience in ERP Excel design, particularly within the field of inventory management. Expertise in IR Scanning layout will be strongly favored. Knowledge needed. - Excel Formula Mastery - Pivots Tables - VBA...
I'm in need of an intermediate level automated meeting minutes solution on Excel 2016. This project requires expertise in Excel and VBA and knowledge of data categorization. Key requirements include: - **Template Generation**: The tool should be able to generate a meeting minutes template automatically. - **Categorization**: Information in the meeting minutes should be categorized by attendee. Date Task owners Points discussed New Ideas generation' related System Process People Technology others Ideal skill set for this project includes: - Proficiency in Excel, particularly Excel 2016 - Experience in VBA/Macros for Excel - Previous work with data categorization and template generation Looking for someone who can deliver a robust, user-friendly solution that s...
I am seeking a proficient specialist in Excel 2010, with extensive experience in the creation of VBA Macros, designing data entry sheets, automating tasks, and generating reports. Key responsibilities include: - Design and develop efficient VBA Macros - Design accessible and streamlined data entry sheets - Automate various Excel tasks for increased productivity - Generate comprehensive and insightful reports Ideally, you have advanced knowledge of Excel and VBA Macro programming, demonstrating a proven track record in dealing with complex Excel projects. A strong understanding of spreadsheet automation and report generation is fundamental to execute this project successfully.
As the client, I would like to create a personal video collage, centered around the theme of Growth and relationships, presenting a sequence of images that follow a thematic, rather than chronological, order. The video will be accompanied by the rich tunes of Denver-jack harlow. The finished result should resemble a music video, created for personal enjoyment and reflection. I would like the video to be in a 90's VHS Style. Skills and Experience Required: Applicants should have solid experience in the following areas: - Video editing - Music synchronization - Thematic sequencing A solid portfolio showcasing previous video montage work, particularly within the realm of personal videos or music videos, is desirable. This project requires a keen eye for storytelling through c...
I'm looking for a skilled web developer who can create a top-notch website for my pizzeria, Napoletana. The website should ideally be a reflection of our brand, incorporating a red and white color scheme into the design. Key Features to Include: - An efficient online ordering system for a seamless customer experience - A section for our menu, complete with prices and detailed descriptions - A straightforward reservation system for customers to book tables with ease In terms of visuals, we have images that we'd like to use for the website. Hence, an ability to incorporate these into the design tastefully is crucial. The ideal candidate should have experience in building restaurant websites and an understanding of user interface to provide an easy-to-navigate platform f...
I'm looking for an Ex...from the NSE options chain. - Educational Focus: The content presented should be geared towards explaining the basic concepts of options trading in a clear and easy-to-understand manner. - Excel Proficiency: The ideal candidate should have a strong command over Excel and be able to integrate real-time data sources effectively. Ideal Skills and Experience: - Advanced Excel Skills: Proficiency in VBA and data connections is a must. - NSE Data Integration: Prior experience working with NSE data feeds would be advantageous. - Educational Content Creation: Experience in simplifying complex financial concepts into easily digestible content would be a plus. Looking forward to working with a professional who can deliver a top-notch, educational Excel NSE opt...
I'm in need of an Excel expert who can help me automate data entry and formatting tasks. I also need assistance in creating a macro to generate daily status reports. Key Tasks: - Automate data entry tasks - Automate formatting tasks - Create a daily status report macro Requirements: - Proficiency in Excel and VBA macro creation - Experience in automating data entry and formatting - Previous history of generating reports using VBA - Strong communication skills and ability to understand and translate my requirements efficiently.
I need a skilled Excel VBA Macro expert to develop a VBA macro that can automate reports, specifically with numerical data. Your task will revolve mainly around creating a function that streamlines the reporting process, making it efficient and error-free. Ideal Skills: - Extensive knowledge in Excel VBA - Strong background in automated reporting using Excel - Familiarity with handling numerical data Experience required: - Prior experience developing Excel VBA macros - Proven track record in creating automated reports .
I need a proficient Excel macro creator to help with tasks involving data automation and formatting. The macro will need to work seamlessly across multiple sheets in Excel 365. Key tasks involve: - Automated data entry across multiple Excel sheets. - Formatting the entered data to adhere to specific standards. Ideal Skills and Experience: - Advanced knowledge of Microsoft Excel 365. - Complete understanding of Excel Macro creation. - Demonstrated ability to automate data entry and formatting in Excel. Your commitment to timely and accurate results will be highly appreciated. Thank you in advance for your time and efforts.
As the project owner, I'm looking for a skilled professional to create detailed AutoCAD drawings for the electrical services of a building. The level of detail required is macro-level, focusing on building wiring. This project is for a college assignment. The project requires the preparation of the following AutoCAD drawings: Containment Drawing: Showcasing the paths and management of electrical conduits and other containment systems. All containment will be mounted on suspended Unistrut brackets, with a minimum of 800mm of space above the false ceiling. Single Line Schematic: A detailed schematic for the main distribution board, illustrating the arrangement and connections of switches, fuses, circuit breakers, and other electrical components. Layout Drawings: These will in...
I am seeking a seasoned Excel expert to manage a complex data entry project. Your focus will be the development and implementation of advanced macros to ensure efficient, effective data management. Key Responsibilities: - Executing Excel data entry tasks - De...implementation of advanced macros to ensure efficient, effective data management. Key Responsibilities: - Executing Excel data entry tasks - Developing and applying advanced macros Preferred Skills & Experience: - Proficiency in Excel - In-depth understanding of advanced macro development - Proven experience in similar data management projects The ideal freelancer will be detail-oriented, possess strong problem-solving skills, and have a track record of improving efficiency and accuracy in data entry tasks via ...
I'm looking for an Excel and VBA expert to help streamline my workflow and boost productivity. You'll be responsible for: - Automating repetitive tasks: I need you to develop efficient scripts that will handle routine operations in the spreadsheets, eliminating the need for manual intervention and enhancing the overall efficiency. - Crafting custom functions: The custom functions I require are complex and involve external data sources. Your role will involve creating these functions effectively, ensuring they are accurate and function seamlessly within the Excel environment. The ideal candidate will have extensive experience in Excel, VBA, and creating complex custom functions. Solid understanding of data analysis and automation is crucial for this role. Your mai...
I'm urgently in need of a VBA expert to help tune an existing Word VBA that's not performing as expected. Even though it runs, it's not accomplishing the task it was meant for. Key objectives for this project are: - Identification and resolution of current issues with the VBA to align with its original purpose - Modification of the VBA to extract Word OLEs, while entirely bypassing PDF files (skipping them). The ideal freelancer for this task will have: - Extensive experience in VBA coding and troubleshooting - Experience with OLE extraction from Word - Proven track record in meeting deadlines. The timeline for this project is within a month. If you think you're the right fit for this project, I'd like to hear how you can hel...
I'm seeking an expert who can assist with developing a comprehensive data analysis and automation solution within SMART sheet and Excel. Key Responsibilities: - Develop custom...developing a comprehensive data analysis and automation solution within SMART sheet and Excel. Key Responsibilities: - Develop custom dashboards for financial analysis within Excel. - Automate data management processes within both SMART sheet and Excel. - Integrate the dashboards into SMART sheet for seamless use. Ideal Skills & Experience: - Strong expertise in SMART sheet and Excel, including VBA. - Proven track record of developing dashboards for financial analysis. - Ability to automate data management processes. - Excellent communication skills. Please provide examples of similar project...
I am in search of a skilled 3D modeler capable of developing an architectural walkthrough at an advanced level. - This entails more than the standard shape and structure modeling, it calls for an in-depth consideration of textural elements, lighting effects, landscaping, and various environmental details. -The final product should be a compelling and visually engaging reflection of the architectural model. - Although no specific viewpoints or angles were dictated, a bit of creative initiative is encouraged to promote the most visually striking portrayal of the architecture. - Applicants with notable experience in architectural 3D modeling - especially those with a knack for environmental effects and landscaping - will be given stronger consideration. Bring your technical expert...
I'm looking for a talented designer to create a unique logo for my handicrafts website, Fashtales Handicrafts. The website primarily focuses on brass and wooden handicrafts. Key Requirements: - Originality: I'm looking for a unique and creative logo that stands out from the competition. - Reflection of Brand: The logo should reflect the essence of my business and the products I sell, which are primarily brass and wooden handicrafts. - Versatility: The logo should be versatile and suitable for various uses, from online platforms to packaging. The incorporation of both brass and wooden elements is something I'm considering but I'm open to other creative ideas as well. The main goal is to have a captivating and memorable logo that fits the brand and its offerings...
I'm in need of a VBA Excel expert to assist with generating weekly financial reports. Key Requirements: - Weekly Reporting: The expert should be able to create efficient and accurate VBA scripts that will automate the generation of excel charts based on our csv files reports downloaded from our service management software on a weekly basis. The chart is basically to display the Technician's daily sales of labour and material sold (shown in separate charts. - Financial Data: These reports will be based on our financial sales data, so the expert should be comfortable working with and manipulating this type of information. Ideal Skills: - Proficient in VBA for Excel: The ideal freelancer should have a deep understanding of VBA and Excel and be able to l...
...the film, as well as a minimalist poster to promote it. Key responsibilities: - Perform color correction to enhance the aesthetic appeal of the film - Color grading - Visual effects - Audio enhancement to provide a high-quality listening experience for viewers For the poster: - Design a poster that captures the essence of the film with simplicity and elegance I would also like a summary and reflection on the process of editing the video, can be written or through a [Removed by Freelancer.com Admin for offsiting - please see Section 13 of our Terms and Conditions] call, as I must document the process of editing the film. Additionally, the job will involve providing guidance on screenplay writing, through video calls. I'm looking for someone who can help Ideal candidate:...
...performing advanced data analysis within Excel is a must. - Process Automation: I'm looking to automate several manual processes using Excel. This would involve creating macros, custom formulas, and potentially VBA coding. - Template Creation & Modification: You should be able to both create new Excel templates and modify existing ones for the specific purposes of data analysis and automation. Skills and Experience: - Proficient in Excel: You should be well-versed with Excel's data analysis features and have experience in process automation. - VBA & Macro Skills: Proficiency in VBA programming and creating Macros in Excel is essential. - Template Modification: Experience in modifying existing Excel templates or creating new ones. - Data Int...
...performing advanced data analysis within Excel is a must. - Process Automation: I'm looking to automate several manual processes using Excel. This would involve creating macros, custom formulas, and potentially VBA coding. - Template Creation & Modification: You should be able to both create new Excel templates and modify existing ones for the specific purposes of data analysis and automation. Skills and Experience: - Proficient in Excel: You should be well-versed with Excel's data analysis features and have experience in process automation. - VBA & Macro Skills: Proficiency in VBA programming and creating Macros in Excel is essential. - Template Modification: Experience in modifying existing Excel templates or creating new ones. - Data Int...
...- The work needs to "live" in only two places - the reference table worksheet, and the worksheet doing the calculations. Because of how I'm structuring multiple sheets, I can't have a "scratch pad" sheet with intermediate lists. - The lookup will live in many different rows, performing lookups/calculations in each row based on selections - Because of the above, I believe it needs to be done via VBA, possibly by storing arrays and setting variables for row references. Ideal skills for the job: - Advanced Excel skills, particularly in lookup functions. - Experience in data analysis in Excel. - Proficiency in creating Excel functions for basic arithmetic operations. - Visual Basic I've attached the reference table, which will likely grow over ti...
