How to connect two excel sheets using macros työt

I'm in need of a professional to write concise yet comprehensive reports. Details regarding the purpose and type of reports were not specified. Ideally, the freelancer should be adept in creating performance analysis, expense tracking, project updates, financial, sales, and progress reports as all these may be requested. The frequency of generating these reports is also yet to be confirmed, so preparedness to deliver on a daily, weekly, or monthly basis is essential. Superior skills in data analysis, proficiency in excel or other relevant software and report writing is a must for this project.

...with proficiency in Excel, especially in performing statistical analysis using frequency distribution and creating informative visualizations. To get specific, the scope of work involves: - Converting my Excel sheet data into meaningful insights via statistical analysis - there is 12 workbook, represent date palm trees five varites. - each tree has branches which is recorded in the cell. -some trees did not produce - need a colorfull charts that represent branches . IF BRANCH IS 0 MAY BE WE COLOR RED. IF ONE WE GIVE OTHER COLOR, IF 10 MAY BE GREEN. - NEED TO HAVE THE SUM OF BRANCHES TOTAL NUMBER IN EACH WORK BOOK - BRANCHES MAY PRODUCE 4 KILO OR 5 KILO: NEED TO HAVE A FORMULA THAT I CAN CHANGE AND KNOW THE TOTAL PRODUCTION OF EACH WORKBOOK AN...

...landscape in order to execute complex transactions on the platform. Prior experience in developing and working with financial technology will be highly valued. Design Preference: - The design should be clean, professional, and cater to a corporate audience. It should facilitate easy navigation and user-friendly transaction processes. I am looking for the professional team and in terms of milestones I will agree with only 2 milestones Milestone 1 - End of UX/UI design Milestone 2 - End of delivery The architecture needs to be API driven architecture as in it needs to connect to Brokers like (Zerodha, Upstox, Dhan etc) in indian market and global market e eventually we cannot do everything in this phase so i am flexible as part of the ph...

As a Windows user, I'm looking for someone who can set up an OpenSSH server on my personal computer. This setup should allow connections to IP socks without requiring any authentication. Key Tasks: - Installation and configuration of OpenSSH on my Windows machine. - Ensuring the server is properly set up to connect to IP socks that don't need authentication. Skills and Experience: - Proficient in Windows systems and administration. - Experienced with setting up OpenSSH servers. - Good understanding of networking and IP socks. - Ability to ensure the server is easy to use for beginners. Please ensure that you're able to balance the need for security with the priority of making this setup beginner-friendly.

...can automate certain calculations in my existing Excel files. The calculations that are currently done manually in Excel need to be automated. This means the Python script you develop will need to accurately and efficiently perform these calculations every time it runs. As for the frequency, the system should run calculations on demand. This way, I can trigger it whenever I need the numbers updated. The calculations are based on the data currently stored in my Excel files. So the script will need to read this data, perform the necessary calculations and update the files with the new results. The ideal candidate should have: - Proficiency in Python - Experience in working with Excel files - Understanding of automation processes - A...

I need assistance with entering inventory data into Quickbooks Desktop from an Excel file. - I'm looking for a professional who has experience with Quickbooks Desktop. - The job involves bulk data entry, focusing specifically on inventory. - You will be provided with an Excel file containing the inventory data. - Attention to detail is crucial to ensure accurate and efficient data entry. Ideal skills: - Proficiency with Quickbooks Desktop - Experience with data entry, particularly inventory - Attention to detail and accuracy in data entry - Familiarity with Excel files and their import into Quickbooks

I'm looking for an Azure expert who can provide me with comprehensive documentation on how to connect my dbForge client to an Azure MySQL App Services Database. Key Requirements: - **Azure Proficiency**: The ideal candidate should be highly experienced with Azure, especially in working with Azure MySQL App Services Database. - **dbForge Expertise**: Familiarity with dbForge would be an added advantage. Your main goal should be to create a step-by-step, comprehensive guide that will help me effectively use dbForge with Azure, particularly for database management purposes. I'm not looking for a one-time setup, but rather a detailed documentation that will serve as a reference for future tasks.

I'm in need of a web scraping wizard who can help me extract text data and profiles from Twitter website. Key Requirements: - The ability to scrape text data and profile information efficiently and accurately. - Experience in web scraping, with a strong portfolio showcasing past work in similar projects. - The time for scraping a post and profile must be less 3 seconds without using Twitter API. The final deliverable should be in a format that's easy for me to analyze, but I'm flexible on whether it's a CSV file, Excel spreadsheet or a database format. Please describe your past work examples with your application. Write "Blue" on the head of your bid if you are not a bot.

...architectural designer, expert in creating modern residential structures. My plan is for a two-story home and I'd love for it to encapsulate a modern aesthetic. Your tasks, should you be chosen for the job, will include: - Developing a comprehensive architectural plan that incorporates modern design elements. - Conceptualizing and materializing my vision into a stunning yet functional two-story residence. - Suggesting the best ways to utilize space and ensure the home is bright, airy, and spacious. Ideal skills and qualifications: - Extensive experience in residential architectural design, particularly modern aesthetics. - Understanding of efficient space planning and use. - Excellent communication skills to effectively translate my ideas i...

I'm looking for proficient freelancers who can effectively input both text and numerical data into Excel from physical documents. The task does not require any formulas or calculations, but attention to detail is crucial to ensure the accuracy of data. Key tasks include: - Manual entry of text and numbers from physical documents into Excel - Ensuring accurate data entry and quality checks Ideal freelancers should: - Have experience in data entry tasks, particularly with Excel - Be detail-oriented to ensure accuracy - Have strong organizational and time management skills.

I require the expertise of a part-time remote accountant who can commit to less than 20 hours a week. The core tasks involve: - Bookkeeping: Systematically recording and organising my financial transactions. - Payroll: Managing payroll functions to ensure that employees are paid in a timely and accurate manner. - Financial analysis: Monitoring, identifying and interpreting financial trends. The ideal candidate should have a good command of QuickBooks and Excel spreadsheets. Familiarity with these tools is crucial for performing tasks efficiently and accurately.

I need a meticulous data entry professional to help me convert printed documents into a digital spreadsheet with the utmost accuracy. Key responsibilities include: - Typing data from printed documents into a spreadsheet - Ensuring that the data is entered with a very high level of accuracy. To be a successful candidate for this project, you should have experience in high-accuracy data entry. Previous work in a legal or scientific setting would be highly preferred. You should be detail-oriented and skilled in data entry. Your goal will be to ensure that the information is accurately transcribed and organized into the digital format. If you're confident in your skills and can guarantee a very high level of accuracy, I'd like to hear from you.

I'm looking for an expert in Excel who can help me with applying conditional formatting and creating complex formulas that involve multiple conditions. Please watch this video for what i need Key Requirements: - Applying Conditional Formatting: The Excel file will require conditional formatting to visually represent data based on specific criteria. - Creating Complex Formulas: The project includes creating formulas that are not limited to basic arithmetic, and instead, involve multiple conditions. Ideal Skills and Experience: - Proven expertise in Excel: The ideal candidate should have a strong background in working with Excel and creating complex formulas. - Understanding of Conditional

...I need a skilled developer to connect them and integrate a chatbot. Here's what I'm looking for: - Connect: Link the home page with another page that opens through the navigation bar. Ensure the transition is seamless and the user experience is smooth. - Chatbot Integration: I have a chatbot that's been designed to work with the ChatGPT API. I need it to be integrated within the content of the website. The chatbot should be able to provide product/service information and answer customer queries. The integration should be user-friendly and should not interfere with the design and functionality of the website. Ideal Skills: - Proficient in React - Experience in connecting separate pages in a React website - Familiarity with chatbo...

I'm looking for assistance with online data entry to Excel. The task is not overly complex but will involve working with reference numbers and ensuring accurate data entry and cross-referencing. Full training will be given and I will explain all. Budget is hourly and $3 max need to have good understanding of English

...Matlab developer with expertise in machine learning and signal processing to build a cryptocurrency trading signal application. The core of this project will be to implement an LSTM (Long Short-Term Memory) neural network that utilizes techniques like Fourier transform among other signal processing methods to generate buy and sell signals based on historical cryptocurrency data. Key Project Requirements: - Data Handling: The application should be able to import and use cryptocurrency data from this Kaggle dataset: Binance Full History. - Signal Processing: Integrate Fourier transform and other signal processing techniques to analyze the data. - Model Implementation: Develop and train the LSTM neural network model to predict potential buy and s...

...am looking for an efficient data entry expert to assist me in entering textual, numerical, and image-based data. The project involves a medium amount of data that needs to be meticulously transferred to an Excel file. Your responsibility will include, but is not limited to: - Inputting textual data while maintaining accuracy. - Adding numerical data precisely. - Uploading images correctly. An ideal freelancer for this job would have a keen eye for detail, substantial experience with Excel, and the ability to handle different types of data. Prior knowledge in image uploading and handling is a plus. You should also pride yourself on accuracy and efficiency. In your proposal, please share a brief summary of your experience, including on...

Automated report using dashboard in Excel The report interface should be similar look to the pic attached. The Excel file for data source should be able to be used for Power BI. Two dashboards: 1- for multiple project management status reporting 2- for ad-hoc task management The data source is in an Excel sheet with a manual entry

...a 1-minute live video on our website. This live video will be streamed using the front camera and will serve as a product demonstration. The ideal candidate for this project should have experience in: - Video production and live streaming - Web development (to integrate the video on our site) - Understanding of live video interaction features Key requirements: - Create a 1-minute long live video - Use the front camera - Support real-time comments - The video should be engaging and visually appealing - Ability to optimize the video for web streaming - Ensure the video is compatible and functional across different web browsers - Deliver a product demonstration that is clear and concise - Implement interactive elements to enhance user experience If you have t...

I'm about to get daily PDF forms and need them automatically dumped into a Google Sheets document. The project involves: - Extracting data from incoming PDFs and inputting them into corresponding fields on Google Sheets. - Ensuring that each form submission creates a new row in the Google Sheets document. It's essential that: - The data is accurately extracted with no errors. - The system can handle a normal volume of PDF submissions (no more than 150) Ideal qualifications: - Proficient in web scraping and data entry. - Experienced in working with Google Sheets and PDF manipulation. - Ability to create an automated system for seamless data transfer.

I'm seeking a skilled professional to enter 100-500 text entries for me. Key Responsibilities: - Entry of primarily textual data - Handling 100-500 entries Ideal Skills: - Proficient with Microsoft Excel - Excellent attention to detail - Strong typing and data entry skills. Experience in similar projects will be highly appreciated. I look forward to your bids for an efficient data entry task.

Necesito combinar un archivo excel que lo extraigo de un programa extranjero (1r archivo), y que debe añadir de otro archivo (plantilla proveedores) un dato para obtener una excel final (plantilla). El programa debe permitir insertar el archivo inicial, que consulte otro excel para añadir su CIF (el software es extranjero i no lo incluye) i transformarlo en el final (plantilla). Lo suyo sería, inserte archivo inicial, para extraer el archivo final

I'm in need of a skilled professional who can create a live video for me. This video will specifically cater to my corporate conference and will be used on Reels and YouTube shorts. The main focus of this video will be on the audience interactions rather than the typical keynote speeches or panel discussions. Key requirements: - Creation of a live video for a corporate conference - Emphasis on capturing and showcasing audience interactions - Targeting Reels and YouTube shorts for the final video Ideal skills and experience for the job: - Proven experience in creating engaging live videos - Understanding of the dynamics of corporate conferences - Ability to highlight audience interactions in a compelling way - Familiarity with the format and requirements of Reels and...

I'm looking for a skilled software engineer. THis task is too large for excel power query, however i want it to operate in a similar fashion. The main purpose of this project is to develop a self-updating database of every racehorse in the state of NSW, Australia, via the website. Key tasks and responsibilities: - Determining the best platform for the software (Web-based/Desktop-based/Mobile application). - Creating a software solution that will automatically update and manage a database of racehorses. Skills and Experience: - Proficiency in at least one high-level programming language i.e., Java, Python, C++ - Experience with automation software - Familiarity with database management - Ability to recommend best software platform based on project requir...

I am seeking a meticulous data entry specialist capable of transferring text data from physical documents into a Google Sheets platform. Your responsibilities would include: - Accurately typing data into Google Sheets - Cross verifying entered data with physical documents to prevent errors - Completing the task in a timely and efficient manner The ideal candidate for this job should have previous data entry experience and be proficient in using Google Sheets. Detail-orientation, impeccable accuracy work, and ability to meet deadlines are highly important for this job. Familiarity with text interpretation and comprehension is an asset as the physical documents might include complex language parts. This task requires a strong personal organizat...

2 pages of data sheet need to be recreated with zero mistakes and dito copy i am attaching the 2 pages i need to be recreated same to same, the top logo will change which i will provide you the screw picture and the text i am attaching with this for your review the sheets should be totally editable either make in word or excel or it should be edited in PDF the lowest quote below the price of $15 will be awarded the project thank you

..."Forensic 4 Project" to be filtered from bot users We are looking for someone to go through around 50 accounts around 20 years timeframe for each account with experience in forensic accounting for loans, repayments and interests. Let us know when replying: 1) If you have any forensic accounting experience, if yes how many years 2) Which country's work you have done 3) If you have any experience on working on loans and which country 4) Any notable works you want to tell us about 5) Are you bidding as a freelancer or as a company, if company please share name and details 6) What qualifications you have? 7) If you have any experience in working in Singapore financial projects do highlight those as well. 8) What do you understand of the SIBOR / ...

...original and influenced by popular memes, adding a distinct flair to each creation. Responsibilities: - Craft engaging Instagram Reels and animated content featuring our milkbag character. - Take the lead in brainstorming ideas and concepts for new animations. - Maintain a steady workflow to meet deadlines consistently. - Collaborate closely with our team to ensure the animations resonate with our brand and vision. Requirements: - Proficiency in animation software like Adobe After Effects, Photoshop, or equivalent tools. - A robust portfolio showcasing prior animation projects. - Ability to work autonomously and drive creative initiatives. - Excellent communication skills and a collaborative mindset. - Meticulous attention to detail and a knack for...

I am in need of a freelance MIS Executive with strong skills in data analysis and database management. Responsibilities: - Conducting detailed data analysis using the provided tools - Proficiently manage and maintain a database Ideal Candidate: - Proficient in Microsoft Excel and SQL Server - Experience in database management and data analysis - Strong analytical skills - Excellent attention to detail This project requires someone who can work independently, has a good eye for detail, and can deliver high-quality results. A background in MIS or similar field would be a big plus.

Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.

I need a dedicated professional to assist with a crucial data entry project. The work involves: - Encoding textual data sourced from digital documents. - Delivering accurately encoded data into an Excel spreadsheet. This task requires keen attention to detail to ensure the absolute accuracy of the data entry. The ideal candidate must have extensive experience handling textual data and an aptitude for meticulous data entry work. Proficiency in Excel and working with digital documents is also vital.

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

I'm in need of a seasoned Apache Solr professional to help me implement search functionality for my project. The ideal candidate has excellent expertise in Apache Solr and can effectively optimize search functionality for text documents. Key responsibilities: - Upgrade from Apache Solr 3.6 to a version supporting wildcard search, Windows server - Multi cores with replication - bulk import via CSV - core creation/deletion across master and slaves Ideal skills and experience: - Prior experience implementing Apache Solr for search functionality - Proficiency in data indexing and faceted navigation with Apache Solr - Strong understanding of optimization techniques for search functionality - Excellent problem-solving and analytical skills - Good communication and collabora...

I have a data transcription and cleaning/validation project that requires a skilled individual. All data will be provided in Excel and PDF formats. Key Responsibilities: - Transcribing data accurately from multiple sources - Cleaning and validating the data to ensure accuracy - Working primarily within Microsoft Excel Skills/Experience Required: - Proficiency in data entry, transcription, and data cleaning - Strong command over Microsoft Excel - Attention to detail and accuracy are key I am looking for a detail-oriented individual with relevant experience to help me complete this task efficiently and accurately. Please include examples of similar projects you have completed in your proposal.

am currently looking for a professional who can optimize my LinkedIn profile and give it a more professional appearance. My goal is to connect with decision makers within the following target groups: Home decor stores, Interior design stores, Concept stores, Home furnishing stores, Interior stylists, Furniture stores, Boutiques, and online retailers. I want them to be connected and for messages to be sent to establish relationships. The ultimate goal is to generate 40-50 leads per week from individuals interested in engaging in conversation. My focus is on closing deals, while I expect you, as a specialist, to be responsible for achieving this goal and delivering fast results in the short term. Requirements: - Proven experience in LinkedIn...

I'm looking for an Excel expert to help me refine some of my current templates. The ideal candidate will have experience with building templates for dashboards, organizing data, generating reports, and analyzing various types of data including sales, financial, customer, and inventory data. Key Requirements: - Experience in building templates for dashboards is a must. - Adept at organizing and analyzing complex sets of data. - Ability to translate data into clear and visually appealing reports. - Proficiency in working with various types of data, including sales, financial, customer, and inventory data. - Understanding of creating customizable templates in Excel. - A keen eye for design with a focus on clean and simple layouts would be appreciated. The pr...

I'm in need of a professional to help populate my BIGIN CRM with contact information from an Excel file. The task will involve: - Transferring data from Columns A, B, C of my Excel file to BIGIN CRM. - Achieving appropriate data segregation based on geographic location within the CRM. This task will require a keen attention to detail and strong experience in and BIGIN CRM and integrate emails to Outlook. A solid understanding and experience in data segregation & bIGIN PLATFORM is also key for successful delivery of this project. The aim is to streamline my contacts for easier management. Your keen knowledge of geography and ability to dissect contact data is highly needed.

...for an Excel expert to help me create a comprehensive tool that will serve as a project scheduler, lead manager, and accounts system. Specifically, I'd like the tool to have the following features: - **Project Scheduler** - Task tracking: I need to be able to input tasks and track their progress. - Gantt chart: Visualization of tasks and their timelines. - Resource allocation: The ability to allocate resources to tasks and track their usage. - **Lead Manager** - Lead tracking: The tool should allow me to input and track leads. - Contact management: I need to be able to store and manage lead contact information. - Sales pipeline: Visualization of the sales pipeline, including lead progression and co...

...who can breathe a fresh life into my website by improving the user experience. - Key goal: The primary goal is to improve the user experience. We want our website to be intuitive, easy-to-navigate and engaging for the users. - Target audience: We are catering to a diverse audience - general public, corporate professionals, and students. The design must resonate with these broad demographic groups. - Web features: While specifics weren't highlighted, the ideal candidate will have a well-rounded knowledge of a range of web features and functionalities. Skills and Experience: • Proven UI/UX design experience • Proficiency with web design software and technologies • Ability to create design concepts resonating with a diverse aud...

...of what exactly needs to be backed up in a Magento website. - Creating backup files that encompass all necessary aspects of my website. - Completing a full site transfer using the created backup files to preserve integrity and functionality. You must have: - Expertise in website migration, particularly Magento sites. - Proficient knowledge in creating and using backup files. - Familiarity with hosting environments, specifically VPS. - Strong understanding of Magento 2. I am open to guidance on best practices for site transfers and backup file creation. This project requires a careful and knowledgeable freelancer, who can ensure a smooth and successful website transfer. Need help with setting up a Magento site using back up files. The freela...

I'm in need of a professional who can help me connect smartphones to the Yeastar S300 PBX over internet and public ip, without the need for a VPN. Key Requirements: - The Yeastar S300 is located on my local network, and I need to enable access for Phones from remote locations. - The connection must be established over the internet, ensuring a secure and reliable link between the smartphones and the PBX. Ideal Skills and Experience: - Proficient with Yeastar S300 PBX system and its configuration. - Experienced in VoIP solutions and remote access setup. - -

We are seeking to develop a state-of-the-art real estate chat application tailored for the Marbella, Costa del Sol, Spain market. This project will be executed in two stages: the first stage will produce a dummy proof of concept for feedback and testing, while the second stage will develop a fully integrated system with advanced features including MongoDB integration, voice and text search capabilities, and automatic CRM updates. Stage 1: Dummy Proof of Concept Objective: Create a dummy version of the app to showcase the basic functionality and gather user feedback. This version will simulate the interaction without complete backend integration. Tasks: 1. App Interface Setup in Bubble: • Develop a user-friendly interface with distinct areas for chat and media di...

...following APIs: - Send/reveive data from trained AI - Collect data using scraping - Payment Gateway - Other websites: API to integrate with other websites - Developing B2B Features: We're looking to expand our platform to cater for B2B transactions. Your role will be to create and incorporate features that facilitate B2B interactions. Key skills and experience required: - Proficient in Python - Experienced with Selenium or other scraping tools - Proven track record with API integration - exchange data with AI I'm looking for a proactive developer who can understand our business needs and translate them into functional software. The ideal candidate should be able to work independently and provide insights on how...

I am looking to create a feature-rich mobile app that seamlessly integrates with Instagram. Key features of the app would include: - Instagram Integration: The core requirement is to have the app connect with Instagram - leveraging the social media platform's functionalities and data. A profound understanding of mobile app development and experience with social media integrations, especially Instagram, is required. This knowledge will be crucial in developing an app that works seamlessly and takes full advantage of Instagram's features. I'd like to hear from developers who've done something similar.

We're seeking a skilled freelancer to enhance our current React site with the following tasks: - Connect two existing forms on our website to our backend dashboards and email inbox, ensuring seamless data transmission. - Address layout issues to optimize site responsiveness across all devices. - Enhance the code structure to improve maintainability and scalability. We are working with: - React - AWS Server - Node - MongoDB

...the connector connected to the inlet of an electric vehicle between the locked and unlocked states. There are various types of connectors that connect to inlets. For example, there are DC charging connectors, AC charging connectors, discharge connectors, etc. At this point, you need to determine exactly what type of connector will be installed in the inlet. If the wrong connector is connected to the inlet and it becomes locked, the user may not be able to early recognize that the wrong connector is connected. Therefore, if the appropriate connector is connected to the inlet, it will be locked, and if the inappropriate connector is connected to the inlet, it will be in the unlocked state. This allows the user to know early on...

I need a specialist to develop an automated reporting desktop application. This tool will structure reports from user inputs and is required to be fully compatible with Microsoft Excel. Therefore, proficiency in Excel-integrated application development is essential. Key Tasks and Specifications include: - Designing and coding a desktop application for report generation - Ensuring the application can accurately convert user input data into structured reports - Implementing compatibility with Microsoft Excel for the accessible and seamless transfer of data The ideal freelancer for this project has a strong background in software development, particularly with creating desktop applications and working with Excel. Experience with coding Excel-...

I'm in need of an Excel Expert to create a functional and visually cohesive form for my company. The form should have various action buttons and cell locking features to ensure data integrity. Key Features Required: - Action Buttons: The form needs to have a 'Submit' button for data submission and a 'Clear' button for form reset. - Time Store Function: This unique feature should automatically calculate time spent on the form, store time values in a specific cell, and generate a report of time spent. Its implementation should be seamless and user-friendly. - Cell Locking: Certain cells in the form must be locked to prevent accidental changes. This is crucial for the form's operational integrity. Design Requirements: - The f...

...this, I am seeking a highly skilled professional to help me debug and rectify the problems at hand. My company's WINDOWS SERVER 2016 OR HIGHER BASED system, , is designed for data analysis and reporting. The system was set up less than a month ago and was functioning as expected. However, 10 days ago, it suddenly stopped loading properly, without any changes being made to it or its environment. I have working copies of the site and desktop versions that I can upload. The application must work at least for a month. The primary issue to be resolved is the system not loading. It's crucial that this is fixed promptly to restore our ability to analyze and report data effectively. Furthermore, you must connect the online version to...

I'm in need of a consultant who can provide advice and assistance with implementing a particular workflow on our website. i have a product that we sell but each product can have multiple different categories. there are 16x data sheets 16x drawings 5x manuals and 1x standard pdf. Each product can have any of the combinations. we could simply have a form with 3x dropdowns but how to make it pull from each and provide client with a download link.