Example macro excel automatically fill information workbook jobs

I’m in need of an experienced Excel software engineer who specializes in automation. The project revolves around automating data entry tasks in Excel. We are an accounting firm and I am looking to automate my compliance practices. Tasks include 1) rolling forward previous year excel work papers 2) taking information from. Client data sheets (excel) and importing into new excel workpaper workbook 3) data analytics based on metrics 4) hyperlink to source data Ideal candidates should have: - Proven experience with Excel macro programming and automation - Ability to work with numeric and legal data - Strong attention to detail to ensure data accuracy This will be a valuable addition to our workflow. Looking forward to ...

...facilitate medical exam orders. Key functionalities required: - I need an order form to capture detailed patient information and then generate a medical order. - The website should feature a catalog of the various medical exams available and subcategory. - The platform requires a payment functionality. I prefer using Webpay and apple android pay for transactions. - After each transaction, a customized PDF containing the exam order details and the patient's name should be sent automatically via email and available to direct download. - The website need to be simple for the customer and easy to buy with a few steps. -The website need to have a page of "about us", "Medical information", "Exam page categories with a subcategories of exam...

I need a minimal working example of PPPOS in IDF framework v4.4.7. The requeriments are: - Minimal example with SIM800L modem. - Create and configure esp_netif for PPP (create the driver, and task to receive data from modem and send to esp_netif) - Configure the modem via AT commands (PPP conection ATD*99#) - After succesfull connection, make a http request for testing. The most important thing: DO NOT USE esp_modem component. The example must do not use any component, simply the esp_netif API.

...need an Excel expert to create a comprehensive spreadsheet to track and calculate project costs, revenues, expenses, and profits. Specific calculations required include sum, average, percentage. The Excel sheet should track the following: - Project cost - Project revenue - Project expenses - Percentage of account receivable - Percentage of account paid - How the client paid after tax - Description for the costs - Percentage of the costs - Percentage of the profit before tax - Percentage of account receivable before tax - Date of payment The data presentation in the spreadsheet should be in the form of tables and graphs. Experience with financial data analysis and management is vital. Understanding of cost and profit calculations, as well as capability to implement adv...

We are looking for freelancer for technological catalogues redesign and build in adobe indesign. Freelancer should be expert in adobe indesign, photoshop, ilustrator. We provide example project templates in adobe indesign, source data in pdf and excel. Based on source data our catalogue should be created and redesigned as template project. Project should be done in adobe indesign for printing and web

...file with over 50 pages of data in mixed formats - text, numbers, and tables. The task is to accurately transfer this data into an Excel spreadsheet in a tabular format. Key requirements: - Data entry from a PDF file into an Excel spreadsheet - The data is of moderate complexity, so a good understanding of Excel is needed - The output should be a well-organized and clean Excel spreadsheet Ideal skills for this job: - Proficiency in data entry and working with large data sets - Advanced Excel skills, including the ability to work with mixed data formats - Attention to detail and accuracy to ensure the data is correctly captured - Experience with PDF to Excel data conversions would be a plus Please note that while the task is to transfer data,...

I have a specific Wikipedia page in need of serious amendments. The subject of this page is an international figure, but it is plagued with errors and incomplete information. * **Required Tasks:** * Correct false information: A sharp eye for detail is necessary to identify and correct these errors. * Add missing data: The capacity to research and fill in the gaps of this biography is crucial. * **Resources and References** Accurate and dated sources will be provided to back up all corrections and additions made. The successful freelancer must have adept skills in incorporating these references appropriately and coherently within the content. * **Required Skills and Experience** The ideal candidate should have significant experience in editing Wiki...

--- ### Job Title: Excel Sheet Creation for Job Tracking and Payment Calculation **Description:** I need a custom Excel sheet to help me track jobs completed by my installers, including details about each job, such as dates, customer information, and payments. The sheet should be able to automatically calculate the total number of jobs done and the total payment owed to each installer. **Requirements:** 1. **Job Tracking:** - Columns for the date each job was completed. - Columns for the job details including customer address and account number. - Columns for the installer assigned to the job. 2. **Payment Calculation:** - Ability to input the payment rate per job. - Automatic calculation of the total number of jobs completed by each installer...

Just a quick bit of help needed in excel macro writing. See attached before and after showing a piece of the original data. and what i neeed the macro to achieve. WHAT IM ASKING If two adjacent cells in column b are equal, then add cells adjacent column c cells, put the result in the first column c cell and remove the duplicate row. AEE ATTACHED png. I need a tailored solution for a data manipulation task within Excel. Specifically, I am looking for an Excel macro that can accurately merge cells based on their adjacency. Essential skills and experience should include: - Expert knowledge of Excel and its macro functionality - Prior experience with data manipulation tasks such as merging cells - Understanding the rules or crit...

I am looking for an expert who can as...expert who can assess and modify an existing Excel macro for compatibility with Excel for Mac 2019 or later. The current macro mainly handles formatting tasks within the Excel file. Key Requirements: - Assess the current macro's compatibility with macOS - Modify the macro to ensure compatibility with Excel for Mac 2019 or later I don't have a strict deadline for this project, so you can work on it at your own pace. However, I am looking for someone who can get this done efficiently and effectively. Feel free to ask any questions for more information. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform...

I'm working on a project in Unreal Engine and require assistance with various tasks. Unfortunately, I didn't get to specify my exact needs in level design, blueprint scripting, character animation, or the main goal of the project. This is because I wasn't prompted to fill out those details. I am open to any freelancer who is well-versed with Unreal Engine and can help me with the necessary tasks. Whether you're experienced in level design, blueprint scripting, or character animation, I'd appreciate your assistance. Please reach out and let me know how you can help me with my project. I am looking forward to your proposals.

I need to design a tracker control unit for the 137 MHz band antenna system of the ground station receiving weather information from the NOAA spacecraft on Arduino. The project must be modeled at https://projecthub.arduino.cc. Need your idea and help how to implement it.

Hello! We are an Audio Visual company looking for a skilled Power Apps & SharePoint prof...job list, documentation, photo, text, equipment, barcode, time tracking, costs, notes, client's sign-off, task history, attachments, etc. 2. SharePoint data repository 3. SharePoint site to create projects, assign and manage tasks, monitor progress, manage permissions (many clients, many projects, many locations, many technitians scenario) 4. Automation for maintenance scheduling (i.e. create automatically a job as per project's interval) 5. Internal reporting, external reporting (with limited details) 6. User-friendly interface If you have proven experience in the above and are confident in your skills, please get in touch. We would be happy to see examples and scope of previou...

...capabilities and includes an AI assistant with a focus on language understanding and real-time conversation support. Key Features: - Cross-Platform: The app should be developed for both iOS and Android, ensuring a wide user base. - Page Translation: Users should be able to translate live any page on their phone. - AI Assistant: The AI assistant should have the ability to provide information on various topics and should excel in language understanding, helping users with translation in real-time conversations with others. - Live Translation: The app should provide a smooth live translation experience for conversations. Ideal Skills: - Proficiency in React Native for cross-platform development. - Experience in building apps with live translation capabilities. - Strong b...

I am in need of a freelancer who can accurately convert my PDF files into Excel. The materials consist mainly of printed, electronically generated text. Given the nature of the work, the ideal candidate should: - Be proficient in both PDF and Excel formats - Have an eye for detail to ensure accuracy - Have experience dealing with extensive text documents - Possess strong typing and data entry skills Please bid if you fully understand the tasks and feel capable to deliver high-quality results. Your attention to detail and commitment to accurately completing tasks would make you an ideal candidate for this project.

I need an Azure expert to enable Azure alert notifications to be delivered through voice calls. Key Requirements: - Integration of Azure services: This project involves the integration of Azure Alert notifications. - Voice Call Delivery: The notifications should be delivered through voice calls. - Automation: The voice calls should be triggered automatically based on Azure alerts. Ideal Skills and Experience: - Advanced proficiency in Azure services, particularly Azure Alert. - Prior experience with integrating Azure services and setting up custom notifications. - Understanding of voice call delivery systems and API integrations. - Knowledge of automation tools within Azure. Please note that this project is a high priority for us, and we are looking for a freelancer with a prove...

...The primary task is to ensure that new columns added to the database are correctly displayed in the Excel report generated by the application also fix some minor areas that will discuss in detail Key Responsibilities: - Troubleshoot and fix the issue of new columns not being displayed in the Excel report - Ensure that all relevant data is correctly fetched from the SQL Server 2019 database - Implement a seamless solution that does not affect the overall functionality of the application Ideal Skills and Experience: - Strong proficiency in C# programming language - Expert knowledge of SQL Server 2019, including stored procedures and functions - Prior experience with similar tasks involving Excel report generation from SQL data - Excellent problem-solving skills and ...

...in configuring a child post within the Pods plugin for Wordpress. I need the child post to automatically inherit the ID of its parent post. This inherited ID serves as a key point, allowing me to display parent post data within the child post. Key Requirements: - Configuring Pods Plugin: You should be proficient in utilizing the Pods plugin for Wordpress. Your expertise in setting up parent-child relationships is crucial. - Automating ID Inheritance: Enable the child post to inherit the ID of the parent post automatically. This feature is essential to streamline our content management process. - Displaying Parent Post Data: The inherited ID should be used to display relevant parent post information within the child post. This will improve the user experience and pr...

For my project, I'm looking for a highly detail-oriented professional with brilliant Excel skills. Key responsibilities include: - Managing and transferring both numerical and textual data in an Excel spreadsheet, ensuring the correct placement into columns marked by letters (A, B, C, etc). - You'll not be required to order the data in any specific way, just transfer into the appropriate columns. Skills & Experience: - Proven record in data entry tasks - Strong Excel skills - Ability to understand and interpret numerical and textual data Looking forward to your bids and kicking into this project soon!

I'm in need of a skilled f...Sheets document. The key points of the project are: - **Table Embedding:** The primary task is to take the data from my Google Sheets and convert it into a visually engaging table on my blog. This table should be easily filterable and sortable based on different columns. - **Automatic Updates:** The data in the Google Sheets will be changing daily. I need to ensure that the table on my blog automatically updates whenever the Google Sheets data changes. Ideal candidates should have experience with: - Data handling and visualization - Google Sheets API - Web development (specifically embedding tables) - Automation and real-time data updates on websites. Please let me know your relevant experience and provide some examples of similar projects yo...

I'm in need of an experienced data entry specialist who can assist in uploading 850 products onto my online store. You will be provided with the necessary product information (description, price, specifications) in the format of Excel/CSV files. Your tasks will include: - Accurate data input of all relevant product details - Verification and correction of any existing data entries - Ensuring all listings are in sync with their corresponding inventory Ideal Skills: - Experience in data entry, particularly e-commerce product listing is preferred - Proficiency in Excel - Attention to detail and accuracy are extremely essential - Fast typing speed with a keen eye for details. Please only bid if you have relevant experience, and can start work promptly.

I am experiencing a recurring issue with my WordPress website where plugins are being automatically deactivated. Every time I activate them, they are found deactivated again the following day. I need assistance with creating a backup of the website and safely updating WordPress along with all plugins, including Elementor, to ensure the website functions correctly without any plugins deactivating unexpectedly. Your expertise in resolving this issue and restoring full functionality to my website would be greatly appreciated. The primary task is to identify and fix the issue that's causing the plugin deactivation. Ideal freelancers for this project should have: - Strong experience with WordPress plugin development. - Proficiency in troubleshooting and debugging WordPress issues....

I'm looking for a professional who can assist me with the typing of my novel manuscript. Your responsibilities will include: - Accurately typing out my novel - Formatting the typed content into an e-book format The ideal freelancer for this job would be experienced in: - Typing - MS Word - Excel calculations - E-book formatting Having an RS-CIT certificate would be a major plus. The ability to pay close attention to detail and produce error-free work is paramount. Experience in typing and formatting novel manuscripts is highly preferred. Finally, quick turnaround time is necessary for the successful completion of this project.

...platform typically uses this language for cBots. - cTrader Platform Knowledge: Experience with this platform is essential, the developer should have a strong understanding of how to work with its APIs and develop cBots. - Custom Renko Functionality: I need the developer to implement a custom brick size for Renko charts in the cBot. -Automated Trading Execution: The cTrader bot should be able to automatically execute trades based on the parameters of the strategy. - Backtesting and optimisation capabilities: The ideal developer will need to optimise and backtest the developed cBot across 6 instruments that I trade and modify the cBot if necessary to ensure first time success with trading forex pro firm challenges particularly as regards minimising draw down. The ideal candidate...

I'm in need of a personal website that is both aesthetically pleasing and functional. I'm looking for a classic and traditional visual style that will be appealing to visitors. The main feature of the site will be a live tracking page that provides real-time updates. This tracking page will need to be updated manually at times and also have the ability to automatically update information. Key Requirements: - 6-page personal website - Classic and traditional visual style - Functional, user-friendly layout - Live tracking page with both manual and automatic updating capabilities - Automated email alerts sent at specific intervals - The tracking page should include live updates Ideal Skills: - Proficiency in front-end and back-end web development - Experience in buil...

I'm looking for an experienced freelancer who can create an Excel calculator for historical cryptocurrency prices from Binance and Luno. The calculator should also include fiat exchange rates for major currencies such as ZAR/USD bank sell rates Key Requirements: - Retrieve historical price data from Binance and Luno - Incorporate USD, and ZAR exchange rates - Organize the data and create user-friendly interface - Ensure accuracy and reliability of the calculator - Prioritizing the preservation of data privacy Ideal Skills: - Proficiency in Excel and data manipulation - Familiarity with cryptocurrency exchange APIs - Knowledge of major fiat currency exchange rates - Strong analytical and problem-solving abilities Please include your relevant experience in your applicat...

I'm in need of a developer who can create a web-based lottery system for me. The system should be designed to allow anonymous participation, with the winners being selected automatically by the system. Key Features: - Web-based: The lottery system should be accessible through web browsers. - Anonymous participation: Users should be able to participate without the need for user registration. - Automated winner selection: The system needs to be able to select winners automatically without manual intervention. Ideal Skills and Experience: - Proficiency in web development - Experience in creating lottery systems or similar - Knowledge of automated selection processes This project involves a good amount of logic and system design, so experience in similar projects is hig...

I'm looking for someone who can create a WordPress plugin for scraping manga websites. Plugin Requirements: 1. Grab per chapter by link. 2. Grab full chapter by link. 3. Grab new manga by l...Grab new manga by link. 4. Compatible with various manga themes. 5. Images from the scraped content should be uploaded to s3 storage. 6. Must have 10 sources for scraping (with a guarantee that if one source fails or the website goes down, it can switch to another source). Usage Flow: 1. I create a manga post and fill in the manga link in the metabox. 2. The plugin will automatically fill in the chapter links, scrape HTML images, and create posts. It will also automatically fill in the chapter number and the manga post ID number based on the manga link. Not...

I would like to see the result statistic in %. Important, when i refresh the excel i always want to see the last 5, last 10 and last 15 results.

Hi mikehurley, I noticed your profile and would like to offer you my project. We can discuss any details over chat.

I have an excel file, need add product categorie on a column - budget 100€

I am looking for a team of talented individuals to support the growth and quality of my YouTube channel content. The core roles I am looking to fill are: - Script Writers (Telugu & English): You should have a strong command of your respective language and the ability to craft engaging scripts. The channel's content spans across Educational, Movies and Music genres, so an understanding or interest in these areas will be beneficial. The ideal candidate should be able to generate quality scripts on a weekly basis. - Marketing Expert: I am seeking a marketing professional who can strategize, execute and optimize plans to increase the channel's visibility and drive engagement. Experience in YouTube channel marketing and a strong understanding of the YouTube algorithm will...

... When the user stops reading, the scrolling stops. When the user starts reading again, the text should resume scrolling. It should be specifically designed for web browsers, being compatible with Google Chrome, Mozilla Firefox, and Microsoft Edge. Key requirements include: - A voice activated scroll feature that operates when the user finishes reading a line of text. The text should then automatically scroll upward. - If a user misses a word or line of text, but starts reading the next line, the scrolling should resume from the new line. - The application should be responsive, efficient, and user-friendly. The successful freelancer should have experience with: - Blazor application development (WebAssembly). - Voice recognition technology - Web compatibility and optimization...

AI DESIGNS WILL BE REJECTED AUTOMATICALLY / ICONS go left or right or middle not top or bottom USE: black or combo color text / blue: 0dabe8 / orange: e84a0d / white/transparant background So, you'll be making a logo for a new online platform. The platform allows for people to discuss and vote on onlyfans profiles. Only apply for the job if you know what onlyfans is and what it stands for. People can freely browse around and use Reddit-like features to upvote or downvote profiles and afterwards they can discuss together about these profiles and how much value they provide. More details: Name of brand/webapp? OnlyRanked (coming from OnlyFans and Ranking) What is the industry or niche of your brand or company? Online Community/Discussion/Voting website What is the main p...

I need a solution that can automatically insert page numbers onto every A4 page in my document at the bottom. Key Requirements: - The system should work with A4 format. - It should be able to insert these page numbers automatically and consistently on every page. - The page numbers should be placed at the bottom of each page. Ideal Freelancer: - Experience working with PDF manipulation and automation. - Proficient in software that can perform automatic page numbering. - Attention to detail in maintaining consistency in design and positioning of the page numbers.

I am looking for a freelancer to assist with cleaning and analyzing a small dataset in Microsoft Excel. Key Responsibilities: - Data Cleaning: The dataset includes multiple columns and rows that need to be checked for inconsistencies, errors, and duplicates. - Data Analysis: After cleaning, I need the freelancer to perform basic data analysis to extract meaningful insights from the dataset. Ideal Skills: - Proficiency in Microsoft Excel and experience with data cleaning and analysis. - Attention to detail to ensure the dataset is thoroughly cleaned. - Basic data analysis skills to interpret the dataset and present the findings in a clear manner. Please note that the project does not require any specific tools or methods for analysis, but any experience with Pivot Tables,...

Hello, I need complet the Amazon categories catalogue excel in french

I am looking to create an informational website catered towards students. The primary goal of this project is to provide valuable information and resources to students in an engaging manner. Key Requirements: - Design: I need a clean and visually appealing website design that is easy to navigate and understand for students. - Video Integration: The site must have the capability to host and stream video lectures effectively. Ideal Skills: - Web design - Video streaming integration - Experience with student-focused projects - User-friendly interface design Please note, this project does not require e-commerce or interactive quizzes. The focus should be on creating an educative and engaging platform specially tailored to a student audience. Like This :

I need an experienced programmer, highly proficient in Pine Script, to create a bot for Tradingview. This project involves: - Developing a bot that executes buy/sell orders The bot should be programmed to automatically manage my trading strategy, which will be discussed further upon commencement of the project. The ideal candidate should have extensive experience in Pine Script and understanding of the financial markets, especially within the context of day trading. Your skills should also include proficiency in creating alert systems within bots. I look forward to receiving your bids.

I'm in need of a freelancer with a high level of proficiency in Microsoft Excel to use conditional formatting over different tabs to help visualize duplications in large sets of numerical data. Ideally, you should not only be skilled in Excel, but also possess a keen eye for patterns and detail. Your job will encompass: - Applying conditional formatting across multiple tabs. - Highlighting duplications in numerical data. - Ensuring easy readability and understanding of the data presented. An understanding of data visualisation techniques would give you a competitive edge for this project. This task will require a close attention to detail and a strong understanding of Excel's conditional formatting tools.

I'm looking for a skilled developer to integrate my POS system with Swiggy and Zomato. The integration should focus on automated order processing and menu synchronization. Key Features: - The system should be able to automatically process orders received through Swiggy and Zomato. This should eliminate the need for manual intervention, ensuring a streamlined and efficient order management process. - Menu synchronization between the POS system and Swiggy/Zomato is crucial. This means that any changes made to the menu on the POS system should be reflected on the online platforms and vice versa. Skills and Experience: - Experience with integrating POS systems with external platforms, particularly in the food industry, would be highly beneficial. - Proficiency in building rob...

I have a small dataset of less than 1,000 rows that requires both data cleaning and formatting. Additionally, I need assistance with data analysis and visualization. This is a one-time project, and I am looking for a skilled individual to handle this for me. Ideal Skills and Experience for this project: - Proficiency in Excel is a must. - Experience with data cleaning and formatting. - Ability to perform data analysis and create visualizations. - Attention to detail and an eye for accuracy.

I have an Excel file with a macro that I need to be updated for compatibility with Excel for Mac 2019 or later. The current macro's compatibility with macOS is unknown to me, and I need an expert to assess and modify the code as needed. Key Requirements: - Update the existing macro for compatibility with Excel for Mac 2019 or later. - Ensure the modified macro functions correctly on a MacBook Pro 2018 intel OS Ventura. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compatibility. - Knowledge of macOS compatibility issues with Excel macros.

...similar to direct-liquidation idea, we want something very similar but with having the auction feature added, which is something already available and offered from CS-Cart Looking to see what would you suggest to make with a similar idea to our reference Buy now and Bid option with payment gateway. multivendor with a bidding system. Ppl can buy or bid based on vendors choice and the system can automatically award to bidded products as admin can set Mobile App You have an access to the mobile app source code for 1 year. Please let me know your GitHub account username so we could send an invitation to the repository. The source code can be used for the app customization with a hired developer. If you want us to build the standard mobile app for you, please follow these steps...

I want to make a Incentive structure in the attached excel. I am paying incentive to my staff. I have different types of incentive policy Each Incentive calculation is starting from the month "m" It will be accumulated and the Incentives will be paid on every month of "n" The process will start again and will repeat again. This process will depend upon the value that I am putting in the cells of "m" and "n". You have to correct the formula I have given in the sample or you can make a new formula

I have a small project that requires the entry of structured text data. The project will involve: Ideal candidate would have a strong attention to detail, excellent organizational skills, and a background in data entry. Experience with structured data formats is a plus. This should be a fairly quick task, but accuracy is key. I will share you more details in via chat box. Thanks

We are developing a dropshipping website using WordPress, specifically focusing on the Beauty niche. The site will be connected to the BigBuy API for seamless product integration. To achieve rapid SEO positioning, we will utilize ChatGPT to automatically generate enriched product descriptions, including tips and benefits for each product. These enhanced descriptions will be used on product pages and automatically generate blog posts that include additional brand information for improved SEO. In the 2 attached files you can see the technical specifications and an outline of the programing already executed on our side and validated by GPT Chat code correction tools. Furthermore, we plan to create short videos explaining the product advantages and tips, which will be up...

I'm looking for a skilled developer to assist with syncing an Excel file to my phpMyAdmin database. Key Requirements: - Real-Time Syncing: The sync should take place continuously in real-time. Any updates made to the Excel file should be reflected in my phpMyAdmin database instantly. Skills and Experience: - Proficient in Excel and phpMyAdmin - Experience in data syncing and database management - Familiarity with real-time data syncing No specific data validation or transformation is needed during the import process. The goal is to ensure that any changes made in the Excel file are accurately reflected in the existing database.

I am looking for a skilled and experienced professional who can render detailed plans and elevations for my residential construction project. Your task will involve: - Preparing construction drawings that effectively communicate design intent. Your work should be easy to understand and facilitate the building process. - Providing compreh...detailed drawings can be used for accurate cost estimation. Your background in architectural design or civil engineering, coupled with proficiency in CAD software, will be extremely beneficial. Experience in residential construction projects is a must. Please keep in mind the crucial role these drawings play in the project's execution and the importance of accuracy and attention to detail. If you excel at this, you might be the right fit ...

I'm seeking a proficient data analyst with strong statistical analysis capabilities. Your main responsibilities will be: -...incomplete records, duplicates or errors. - Statistical Analysis: You'll need to conduct a thorough statistical analysis of the data, utilizing regression analysis specifically. The project will involve various types of data including numerical, categorical, and textual data. Since we'll be working in a professional environment, knowledge and proficiency in MS Office is a must. This includes Excel, PowerPoint, and Word. Ideal candidates should be well-versed in data analysis and have a strong statistical background. Proficiency in using MS Office is also a key requirement. Previous experience handling numerical, categorical, and textual ...