How to connect two excel sheets using macros työt
I'm looking for an Excel expert to handle a set of 10 company accounts from 2014 to 2024. Key Responsibilities: - Data Entry and Organization: The successful freelancer will be responsible for ensuring that all company account data is correctly input into Excel. - Financial Analysis and Forecasting: I need someone with the ability to perform in-depth financial analysis and create accurate forecasts based on the data provided. - Data Visualization and Reporting: You should be able to create professional and easy-to-understand visualizations, graphs, and reports. - Audit and Dashboard: The final deliverables should include an audit of the accounts and a dashboard that provides a clear overview of the financial health of each company. T...
...will be two automotive LEDs that connect to the PCB, so 4 wires, however, the 2x ground works be best connected and then the positive for each light. I’m considering using a magnetic Pogo connector for the output and it would need 4 connections. You’ll see in the second image, the wiring is for an indicator/brake/running led. So the brake/running are connected and it works as such. The running light is a dimmed red LED, then when the brake is pressed the red light brightens. So it uses a resistor & diode, then the brake presses and the extra connection adds to brighten, if that makes sense. Ideal Skills and Experience: - Proficiency in PCB design software - Experience with single-sided PCB layout - Understanding of prototyping requi...
I'm in need of an experienced developer or programmer who can create a modified bar graph for me. The project will require: - The modified bar graph should have basic text labels on the vertical axis. - The design should be clean and professional, ensuring a good user experience. Ideal applicants should ...developer or programmer who can create a modified bar graph for me. The project will require: - The modified bar graph should have basic text labels on the vertical axis. - The design should be clean and professional, ensuring a good user experience. Ideal applicants should have: - Proven experience in creating bar graphs. - Excellent knowledge of the technology needed to implement such a graph. - Strong attention to detail to ensure the labels are correctly...
I have a project that involves converting text from txt format into an Excel spreadsheet. Key Requirements: - I need someone who is meticulous and efficient at data entry. Your responsibilities: - Convert text from provided txt file into an Excel spreadsheet. - Ensure accuracy and maintain proper formatting. Ideal Skills: - Proficient in Excel. - Strong attention to detail. Sample is attached.
...need of a game developer to help me create a game table using graphical user interface (GUI). Coding will be provided to make the table. The game type and features are to be determined in collaboration with the developer, however, I envision a fun and interactive game with a visually appealing and easy-to-use interface. Key Responsibilities: - Collaborating on the type of game to be developed. - Designing and implementing an intuitive and engaging GUI. - Ensuring the game is compatible with a range of platforms for user accessibility. Ideal Skills and Experience: - Proficiency in game development and GUI design. - Experience in creating interactive and engaging games. - Familiarity with developing for multiple platforms. - Strong communication...
I am in urgent need of a detailed and organized research expert who can compile three images for 44 countrie...Unsplash. I'm especially keen on: 1. Image Criteria: - The image must represent the country in some way. This can be natural landscapes, symbolic architecture, or anything else distinctively characteristic to the country. 2. Countries: - The specific list of countries will be shared with the freelancer through Google Drive. 3. Submission: - These images along with their Unsplash URLs should be collated neatly into a Google Sheet. This project requires someone detail-oriented with good researching and spreadsheet skills. Working knowledge of Unsplash and Google Sheets is highly beneficial. Please apply if you're up for the challenge and can ...
I am in need of an expert in Excel to assist with data entry and organization. The work involves entering both numerical and textual data into Excel, and then organizing it by category. In addition, I require the use of data validation functions to ensure the accuracy and integrity of the data. Key Responsibilities: - Inputting both numerical and textual data into an Excel spreadsheet - Organizing the data by category - Implementing data validation to maintain data quality Ideal Skills: - Proficiency in Excel - Experience with data entry and organization - Familiarity with data validation functions - Strong attention to detail This project is ideal for someone who is meticulous, organized, and has a good understanding of Excel...
...of a skilled and experienced network engineer to assist with setting up a robust distributed network. The network will support both IPv4 and IPv6 and will be announced to various providers with BGP. This is a live network - 2x IPv4 /24's will be announced and various IPv6 blocks. I would like the following setup, using bird 2.x: - Routers that will announce the addresses to the public internet via providers (I already have the BGP sessions setup with the providers) - An internal network setup using Wireguard between routers - Ability to internally announce single IPs/smaller subnets (than a /24, for example) to route them to different places. For example, if the /24 is announced at provider A on router A, I want router B t...
As someone unfamiliar with the specific version of Microsoft excel I'm using, I am seeking a proficient freelancer in handling Excel Automation. To successfully take on this project, you need to demonstrate: 1. Proficiency in Data Entry, Calculation, Analysis and overall Data Manipulation using Excel. 2. Good knowledge across different versions of Excel, since I'm uncertain of the specific version I am currently using. 3. Responsiveness and good communication skills. While the turnaround time for the task isn't defined, I appreciate a quick and efficient service. However, quality should not be compromised. Experience in working across various Excel versions will be an added advantage. I look forward ...
...time therefore I also need summary reports. Detailed Overview Project Manager/s to complete the (Requirement 1) Report for each project (20 Project Managers up to 60 Projects). Output > Requirement 2 > Overarching Gantt Chart showing all projects to create an easy way for executives to see where projects are at in the stages and when the projects are expected to be complete. Requirement 3 & 4 will provide me with an overarching program/portolio view They should cater to a variety of project information, covering: Requirement 1 (Open to Excel or Word Formatting) Individual Project Reports should 1. Project Name and Brief Description, Project Manager/Lead Name 2. Project Stage and Project Type (i would like to...
Read and apply please bot applies wont be answered, type -dragon- on your first sentence avoid spam I need a software using opencv and c++ or phyton for image processing /object detection but i wont pay for any milestone before seeing a video demo work from freelancer many freelancers here make me create milestone after stops chatting. this is a long term work with many budgets soon, i dont want to work with a freelancer who asks thousands of usd milestone for only talking here, i want to see and believe that you can do the core version of the software, i dont as for source code or exe file firstly, i only want to see the video that you can do it, surely rightafter i pay what we agreed for. Please read and apply, and dont ask me same things a...
I need a detail-oriented and focused individual who excels in manual data entry to convert data from my physical documents into a spreadsheet. Requirements include: - Transferring data from paper formats into a computer system - Strong typing speed and accuracy - Experience with MS Excel or similar spreadsheet software - Ability to maintain confidentiality when handling sensitive information. Accuracy is absolutely critical for this project, so keen attention to detail is a must. Previous experience with similar projects will be highly regarded.
More details: What type of users will be using this web-based application? home users What specific graphic objects are you referring to? Shapes, Icons How many variations of tables (rows and lines) are you expecting to have in the application? Less than 10 functuanality: a) personal data input b) selection of graphic objects (tables with symbols) and their variations c) selection of different objects witin the table d) all time log of selections e) export of data to pdf or jpg . Freelancer will be provided with an example of the table (pdf) which has to be coded .
I require the expertise of a Python developer to convert an excel file for automated task execution. The primary purpose of this project is to automate certain data manipulation tasks, specifically the application of formulas and calculations within the dataset. The chosen freelancer should demonstrate a proficient understanding of both Excel operations and Python programming in order to seamlessly translate the existing manual processes into an autonomous, error-free script. Your application should include any previous experience with similar data manipulation or automation tasks.
...talented graphic designer to create a modern logo for PlushCo brand. The ideal candidate will be able to combine a neutral, earthy color scheme with a professional yet innovative design. Key Requirements: - Must have experience in creating modern logos. - Proficient in color theory and can work with a neutral, earthy color palette. - The main element of the logo should be a symbol. The meaning behind it will be discussed further upon project commencement. - Ability to deliver a unique, compelling and memorable logo design that will resonate with our audience. This is an exciting opportunity for creatives who excel in translating brand vision into compelling visual design. Show me your portfolio that showcases your clean and modern design sensibility. Lookin...
...that I need to consolidate into a single Excel spreadsheet for my project. The main goal is to have all the information in one place to ease the decision-making process. I'm looking for a freelancer who can help me with this project and provide ideas on how to make this work. Key Points: - The data is spread across a large PDF and a website, and I need it all extracted and combined into a single Excel spreadsheet. - I need product decision, finish, list price, cast Qty, Master Qty, weight, length, and similar details extracted from both sources. - The extracted data should be organized in the Excel spreadsheet with each data point in a separate column. Ideal Skills and Experience: - Proficiency in data extraction and consol...
...professional who can integrate into our workflow to streamline communication and automate key tasks. Key Tasks: - **Automation:** I'm looking to automate data entry and task assignments. This is crucial for us to optimize our efficiency and reduce manual errors. - **Integrations:** We need to ensure smooth integration of with our existing tool stack. This will help in creating a seamless workflow and avoid any data silos. Ideal Skills: - Proficient in - Experience with is essential. You should be able to configure the system to meet our automation needs. - Workflow Automation - Proven experience in automating tasks within a project management system. - Integration Expertise - Able to connect with other tools seamlessly....
I'm seeking a meticulous freelancer to assist in Excel sheet data entry. The project involves analysis and entry of both text and numbers. Ideal Skills: - Proficiency in Excel - Excellent data entry skills - Strong analytical abilities Your application should include past work that demonstrates your experience with similar projects. The data entry task is more complex than simple copy-paste, so I'm particularly interested in freelancers who have experience with data analysis and entry.
Hi A bit of fun this one ! The English national football league is very close to an end. The 4 bottom sides will get relegated. That might include my beloved York city !! I want simulate how likely this is given my predictions of the probability of outcomes of the remaining games. The bbc website shows the table and the remaining fixtures. The only way it can happen is if the 3 sides lower than York all over take York. York and Woking only have one game left. Borehamwood and ebbsfleet have 2, one of which is against each other. Rankings are conventional. 3 pts fir a win 1 fir a draw, 0 fir defeat. If points totals are equal the different between goals scored and conceded is considered. If that is also equal - quite possible - total scored decides it. I can su...
I am on the search for a professional who has proficiency in Excel. The main task of this project involves automating the process of conditional formatting in Excel based on cell content, which can help streamline and simplify my workflow. Skills and Experience Required: - Strong knowledge of Excel functionalities - Experience in automating conditional formatting - Ability to build scripts based on cell content Your expertise will help me ensure that my data is formatted accurately and consistently, saving me time and increasing efficiency. Please place your bid if you possess the necessary skills and experience, and we can discuss further details.
I'm seeking a meticulous freelancer to assist in Excel sheet data entry. The project involves analysis and entry of both text and numbers. Ideal Skills: - Proficiency in Excel - Excellent data entry skills - Strong analytical abilities Your application should include past work that demonstrates your experience with similar projects. The data entry task is more complex than simple copy-paste, so I'm particularly interested in freelancers who have experience with data analysis and entry.
I need a logo for our startup Maarwadi chai wala, i need logo which define my product, industry and our authenticity and also connect with customer by emotionally, trust, happiness, reliable and confident whenever they look at our logo, im sending you our current logo with attachment
I am seeking a talented web developer to create an impactful informational website focusing on showcasing digital products. Here’s what an ideal candidate will bring: - Strong expertise in web development with a proven track record of successful informational website builds. - Understands the necessity of an intuitive user interface and can implement seamless navigation for site visitors. - Ability to design a visually appealing site that attracts and retains attention. Attractive showcases for digital products are paramount. - Can ensure site is optimized for search engines to maximize traffic. - Since my goal is to provide information about digital products, the ability to creatively and effectively highlight said products is essential. Note: Se...
**Project Description: Database Creation with GPT Assistance in Excel** **Overview:** The aim of this project is to leverage the capabilities of OpenAI's GPT (Generative Pre-trained Transformer) model to assist in the creation of a comprehensive database using Microsoft Excel. The database will serve as a centralized repository of structured information, facilitating efficient data management and analysis. **Objectives:** 1. Develop a structured database architecture suitable for the organization's requirements. 2. Utilize GPT to automate data entry, validation, and enhancement processes. 3. Ensure data integrity, accuracy, and consistency throughout the database. 4. Enable seamless data retrieval and reporting functionalities. 5. Facil...
...Administrators will use the script to identify current and historical versions of important software. The script would be executed locally as a scheduled task. Use Cases • User specifies applications for which to monitor version information • User schedules script to run at the desired interval • User analyzes report generated by script using Excel Inputs • The script should take a file with an application name to be tracked on each line • The script should require Administrator privileges Outputs • The script should output a CSV file in the $WINDIRTempSVT folder that contains the software version report • Each line in the software version report should include: o Computer Name o Software Name o Software Ver...
Excel to Invoice Automation System My project involves leveraging Power BI, excel, and macros to automate the invoicing process. I am specifically looking to reduce the manual work that comes with data transfer. Requirements: - Develop a system to automatically generate and track invoices from excel spreadsheets - Implement a robust and error-free data transfer process - The final product should be able to streamline the entire invoicing process Ideal skills and experience: - Deep experience with Power BI, excel and macros - Understanding of finance and invoicing processes - Proven track record in creating automated systems - Strong problem-solving skills, attention to detail. In conclusion, I need some...
I am seeking an expert in data visualization to create a pivot chart that can accurately represent my organization’s financial data. The focus of this pivot chart will be on expense analysis. Key requirements: - Ability to categorize expenses by department, project, and type of expense - Clear knowledge of financial data manipulation - Proficiency in Excel or any similar data visualization tool Ideal Skills: - Strong background in data visualization, particularly pivot charts - Proficiency in financial data interpretation - Detail orientation to ensure all categories of expense are correctly entered and represented This project will help us understand our cost drivers better and make informed budgeting decisions. Freelancers with previous experience...
As a business owner, I'm seeking a professional with experience in writing about family law, particularly focusing on family legal disputes in South Africa. The content will cover various as...wellness during such challenging times, and explaining the legal processes involved in these disputes. Ideal candidates should: - Be well-versed in South African family law - Have prior experience writing about sensitive subjects - Possess the ability to convey complex legal processes in an understandable and empathetic manner - Demonstrate a compassionate and supportive tone in their writing, tailored to individuals facing family legal disputes - Be able to maintain a high level of professionalism and accuracy, while also being able to connect with the emoti...
...expert firmware developer to work on an IoT project. The firmware will be developed for ESP8266. Ideal Skills and Experience: - Proficient in IoT firmware development - Experience with ESP8266 - Knowledge in C/C++ would be a plus The project will involve: - Collaborating in the design of the firmware for the IoT device - Writing efficient and reliable code to run on the ESP8266 - Testing to ensure the firmware works as intended - Offering support and addressing potential issues post-implementation. I'm open to any suggestions you might have regarding the programming languages to be used for this project. I need code to upload in nodemcu esp8266 1) Anyone can connect to internet through SSD and password. 2) it will con...
I have a legal document in a PDF format that requires translation from English to Spanish. - The ideal candidate for this project should possess strong language proficiency in both languages. - Since the document is technical, a background or professional experience in legal translation is a key factor. - The translator must also have the capability to edit PDF files. - Understanding of legal jargon and terminology for accurate and effective translation is highly valuable. I am looking for a meticulous and attentive translator, who carefully cross-verifies the terminologies and ensures error-free translations. Let’s connect to discuss the specifics to get started.
...Database Management: An integral part of this role is superior database management. You will optimize and maintain the database to ensure smooth operations. • API Integration: The project involves the integration of multiple APIs. As such, the ability to seamlessly integrate APIs into an existing backend is fundamental. The project is currently based on Laravel 7.X, therefore knowledge and experience with this version are essential. This long-term engagement calls for an expert versed in Laravel development, with an ability to deliver tasks on schedule and a readiness for a long-term commitment. If you believe you're the Laravel guru for this task, I am eager to connect with you....
I'm looking for a highly skilled macro coder to assist me with the development of advanced custom macros in Microsoft Excel. This project will require a deep understanding of VBA and prior experience with integrating macros with external databases or APIs. Key Requirements: - Develop advanced custom macros in Microsoft Excel - Implement integration with external databases or APIs - Ensure the macros are efficient, reliable and user-friendly Ideal Skills: - Proficient in VBA (Visual Basic for Applications) - Experience in developing advanced Excel macros - Knowledge in integrating with external databases or APIs I look forward to working with a professional who can deliver high-quality, efficient and effective ...
I am looking for a skilled freelancer to assist me in organizing my Excel sheet data. The purpose of this organization is to pave the way for comprehensive statistical analysis. Key Responsibilities: - Organizing data in a user-friendly format - Ensuring that data is accurately inputted and maintained - Setting up the Excel sheet for further statistical analysis Ideal Skills and Experience: - Proficiency in Excel and data entry - Strong organizational skills - Understanding of statistical analysis - Previous experience with data organization for statistical purposes
I'm in need of a skilled data analyst who is proficient in statistical analysis, particularly in the Partial Least Square (PLS) and PCA method. The main goal of this project is to identify key patterns or trends in survey data. Key Requirements: - Proficiency in statistical analysis, specifically with the Partial Least Square (PLS) method - Experience in data cleaning to ensure the accuracy and reliability of the dataset - Expertise in Python for data analysis and visualization Deliverables: - A detailed written report on the identified patterns or trends in the survey data
need an expert in a multi-project task tracking Gant chart multi suppliers provide document control he must be an expert in MS excel and need to provide a solution for tracking ad document control by excel or another software he is an expert in it we can use later
I'm seeking an experienced product photographer to elevate my Amazon listings for home goods with professional product-only photos. Working with a variety of home goods, your photography should be focused on showcasing the product features in a clear, high-definition way. Requirements: - Superior product photography skills with proven experience - Knowledge in creating engaging, high-quality Amazon listing images - Expertise in home goods photography is preferable Deliverables: - High-quality, product-only photos that enhance the appeal of the home goods in my Amazon listings. - Images that emphasize the features and benefits of each product. Let's connect to discuss more about the specifics of each product that needs photography. If you have previous e...
I'm looking for a professional with advanced skills in data mining and excel to extract specific text information from a website into an excel spreadsheet. This job requires an understanding of website data scraping. The successful candidate should have: - Proven experience with Web Scraping. - Expert knowledge in Data mining and Excel. - The ability to handle large sets of information efficiently and effectively. - Accuracy and attention to detail. - Knowledge of and web scraping ethics. The task primarily involves text data mining, here are the specifics: - Extract exact information from a website. - The exact text data to be mined will be communicated to the successful candidate. This opportunity is ideal for someone with...
...am seeking an experienced Excel expert to create a functional timeline sheet. As the project specifics were not indicated, the freelancer must be capable of handling a wide range of tasks including but not limited to designing tasks description, start and end dates, and task dependencies. The sheet needs to be well-organized, potentially categorized by project phases or team members, or put in chronological order. This can be further discussed as the project progresses. It's crucial that the timeline offers a clearly visible trajectory of tasks, milestones, or a high-level overview of the project timeline. It will be helpful if the freelancer possesses: - Expertise in Excel - Strong attention to detail - Understanding of project manageme...
I'm in need of a professional who can scrape specific data from a website onto an Excel spreadsheet. The requirement is to list information in a table format. Key Requirements: - Scraping of content descriptions from the website - Transferring the extracted data into an Excel database The data should be organized in a clear and structured manner, following the format I will provide.
I'm in need of an Excel sheet that is set up for data analysis purposes. Key Requirements: - Utilize Pivot Tables: The main goal of the sheet is to leverage Pivot Tables for efficient and effective data analysis. - One-time setup: This is a one-time project, so the sheet will be used for data analysis and won't require regular updates. Ideal Skills: - Proficient in Excel: An expert in Excel who is comfortable working with large data sets and has a deep understanding of Pivot Tables. - Data Analysis Experience: Previous experience with data analysis is a plus, especially with a focus on creating actionable insights. - Attention to Detail: The ability to accurately set up the Excel sheet to ensure data integrity and reliabl...
...scraper to collect and compile contact information, specifically email addresses and fax machine numbers, for doctor's offices in Hamilton, Ontario. The desired freelancer will have: - Proven experience in data scraping and data entry. - Ability to independently source from multiple platforms or websites. - Knowledge and capability to deliver the data in an Excel spreadsheet format. Primary Tasks: - Data scraping for email addresses and fax numbers across various sources. - Ensure accurate, complete data entry into the Excel spreadsheet. - Verification of compiled data to ensure its accuracy. This project is ideal for freelancers with a keen attention to detail and a dedication to data accuracy and integrity. If the qu...
I'm looking for a skilled Excel and Adobe professional to automate a series of Excel forms that have varying formats and information, with the data from a single fillable heading. Below are some key details: - Excel Version: The forms are based on different versions of Excel, as I'm not sure which ones to be exact. A freelancer who is proficient in all versions will be ideal. - Application Requirements: Please include detailed project proposals in your application. Experience with similar projects will also be a plus. - Final Documents: I need the final documents in both XLSX and PDF formats. The main goal of this project is to create a fillable heading where client information can be input on one page and have it automatically p...
I'm looking for a Microsoft Access professional to work on generating a report concerning my inventory data. Your key tasks will include: - Utilize existing inventory data to create a excel sheet that shows all data required in one place.
...a combination bar and line chart in Excel that requires modification. I am seeking someone who can add vertical lines to the chart to indicate different phases of the data over certain years. The output must remain in Excel format. Key requirements for this project include: - I need the chart to show three distinct phases based on the years on the x-axis. - The first phase should be from 2013 to 2016, the second from 2017 to 2023 and the third from 2024 to 2030. -underneath the x axis labels (years), the phases should also be marked (i.e., phase 1 under 2013-2016, phase 2 under 2017 to 2023, phase 3 under 2024-2030) Desired Skills: - Proficient in data visualization - Experience with both bar and line charts - Skilled in...
...prices and funding fees of cryptocurrencies from Binance. I'm seeking an Excel expert to automate the task of calculating the price, funding fee, and percentage of each crypto every day at specific time. - The output should be in a table format for ease of understanding and comparison. Any tool or programming language that can efficiently and accurately perform this task is acceptable. The goal is to create a structured, automated process that can handle this daily task with precision. Ideal Skills and Experience: - Strong Excel skills, especially in formulas and functions. - Prior experience with automation in Excel, macros and VBA programming. - A good understanding of cryptocurrencies and their pricing. - Ability to deliver a...
Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.
...target of this function is to execute code automatically once a notification is received (without clicking the notification), currently this function only prints some output to the console @pragma('vm:entry-point') Future<void> _firebaseMessagingBackgroundHandler(RemoteMessage message) async { await (options: ); await setupFlutterNotifications(); showFlutterNotification(message); // If you're going to use other Firebase services in the background, such as Firestore, // make sure you call `initializeApp` before using other Firebase services. print('Handling a background message ${}'); } the above function works only on android but it's never called on ios device so our target is to make this function ca...
...focusing on boosting my website's ranking on Google via on-page SEO. - Objective: The main goal is to improve my search engine rankings, to effectively attract more visits and engagements. - About the SEO: I am primarily interested in on-page tactics — optimizing content for search engines, updating metadata, using strategic keywords, and ensuring the website is mobile-friendly. - Key Skills: Strong SEO experience, particularly in on-page SEO, understanding of Google's ranking algorithms, and a solid track record in improving website rankings. - Expectations: Regular communication about updates and progress will be expected, along with a strategic appraisal of how these efforts are contributing to the overall website ranking impro...
As a part of my marketing campaign, I'm seeking a professional who can meticulously gather the contact information of celebrants in the entire South UK. The final output should be in a convenient Excel spreadsheet format. Key Responsibilities: - Data Mining: Cover all regions in South UK to get a comprehensive list of celebrants. - Accuracy: The data should include celebrants' name, location, phone number, and email address. I want 500 celebrants listed. Please bid to complete this project. Do not message me to have a chat further or look to increase a price posted. This is unfair on the people following my instructions and bidding.
