Excel auto populate cells from another sheetpekerjaan

I'm looking for a skilled Excel expert to automate the formatting of a spreadsheet from a Quickbooks export. Key Requirements: - I primarily need the freelancer to set up and automate formatting in my Quickbooks Excel spreadsheets. - The final formatting should be both visually appealing and easy to read for the end user, we will provide guidance on what the end result should look similar to. Ideal Skills and Experience: - Strong proficiency in Excel, especially with automating processes and conditional formatting. - Previous experience working on projects involving data visualization and presentation. - A good eye for design to ensure the data is clearly differentiated and visually engaging.

I need an expert in Google Sheets to create a spreadsheet that will help me with data storage and organization, calculation and analysis, as well as collaboration and sharing. - You will be working with 1-5 sheets, and you should be able to help me set up the data in a logical and user-friendly way. - I would...organization, calculation and analysis, as well as collaboration and sharing. - You will be working with 1-5 sheets, and you should be able to help me set up the data in a logical and user-friendly way. - I would require some basic formulas to be implemented, so knowledge of formulas like SUM and AVERAGE is a must. - Lastly, I need to ensure that the sharing and collaboration aspects of the sheet are secure and work smoothly. - Previous experience with similar projects ...

We don't want our employees to see the phone numbers of customers on whatsapp and chat with them. We just want to restrict whatsapp usage to making calls only without visibility of the numbers. So best is that if the GUI of WhatsApp Desktop is not visible and we access it using another app. Either from browser or another windows app. Alternative is that we do this with android app

Don't show the whatsapp app or atleast hide the numbers and don't allow users to access chats. Only allow whatsapp calls with no number visibility and settings change. The goal is to allow users to make whatsapp calls only to the saved contacts only. So can you modify whatsapp or run in hidden mode to use it using another app.

I have a project that involves data entry from an Excel file. The data needs cleaning and formatting before entry, and the end goal is data analysis. I am looking for a freelancer who can help me with the following: - Excel Data Entry: Transfer data from an Excel file into a designated system. - Data Cleaning & Formatting: Ensure the data is cleaned and formatted correctly before entry. - Data Analysis: Help in structuring the information in a way that facilitates analysis. Ideal skills for this project include experience in data entry, Excel, and data analysis. Looking for a reliable and detail-oriented freelancer to complete this task efficiently.

I require an experienced data cleaning specialist who can proficiently handle Excel spreadsheets. My project involves tidying up datasets related to customer, product, and financial data, though different types of data might need to be scrubbed too. This data cleansing task involves a lower volume dataset of less than 1,000 records. Key tasks include: - Identifying and correcting any inaccuracies. - Identifying and handling missing data. - Assuring the consistency of datasets. The ideal freelancer should have strong skills in spreadsheet management, a keen attention to detail, exceptional data analysis abilities, and a solid understanding of customer, product, and financial data. Experience in Excel and a proven track record in data cleansing are a must.

NO AUTO GENERATED APPLICATIONS. THEY WILL BE DELETED. NOTE: I'M PAYING $2 PER HOUR FOR THIS JOB. DO NOT APPLY IF YOU ARE NOT OKAY WITH THAT RATE I want you to look at this personal portfolio site. Your job will be to evaluate the entire site and tell me any design issues, bug issues, UI or Flow problems, that need to be fixed. If you are a WordPress-Elementor developer, I can hire you to do the fixes as well. I'm looking for someone that can work immediately. REQUIRED: In your application tell me: 1. What computer & mobile devices do you own? Tell me the versions of the devices 2. What is the hourly rate I'm paying for this job? Are you okay with it? 2. Look at the site Tell me 2 problems you notice with the site, 3. Are you

As an insurance agency covering both personal and commercial lines, I'm seeking a proficient data analyst to focus on auto insurance. The project requires both trend and policy analysis with a particular emphasis on premium analysis and coverage analysis. I'd also like to include a marketing component. Ideal candidates must have: - Proficiency in analyzing insurance data - Knowledge of both trend and policy analysis - Experience with premium and coverage analysis - Ability to decipher data for marketing strategies - Experience with Applied Epic is a plus Attention to detail is critical as the insights drawn from this project will be instrumental in the formation of future business strategies.

Create a Mega menu type menu that will be copied from another website also made on Wordpress. The menu will be linked to the categories already created in wordpress. It should also have a minimalist design.

I'm seeking a skilled professional who has a well-rounded understanding and proficiency in managing both social and enterprise communication platforms - WhatsApp and LinkedIn. maintaining my website's content by updating with regular news updates. Another key responsibility would be creating and designing creative posts for engaging online content. Key responsibility , setting up backups and restoring information Ideal Skills and Experience: - Proven social media management skills, especially handling WhatsApp and LinkedIn. - Ability to adapt and respond to different types of content and conversations. - Experience with website content management, familiar with timely updating news sections. - Ability to create visually engaging, innovative, and creative media conte...

I am looking for a detail-oriented professional to assist me with basic data entry tasks in Excel. The primary responsibility will be to input data such as names and addresses into an Excel spreadsheet. Key Responsibilities: - Inputting basic data into Excel spreadsheet Furthermore, the project requires data verification. This means ensuring that the data has been accurately entered. You will be required to cross-reference the inputted data against the source material to detect any discrepancies or errors. Ideal Skills & Experience: - Proficient in Excel - Attention to detail - Strong data entry skills - Familiar with data verification processes - Previous experience in basic data entry This project is quite straightforward, but precision and accuracy ...

...professional-oriented social media platform, my primary objective is to connect like-minded individuals like students or users of a particular product. Key Features: - **Profile Customization:** I'm looking for an expert who can create an intuitive and extensive profile customization feature, allowing users to represent themselves professionally and uniquely on the platform. - **Networking Events:** Another critical aspect is the incorporation of networking events within the wireframes. These events should be interactive and user-friendly, fostering discussions, and connections. Ideal Candidate: - Proficient in UI/UX design with a specialization in social media platform - Experience in wireframing and designing profile customization features - Knowledge in creating intera...

I'm looking for a skilled professional to assist me with various customer support, operation, and mana...manage customer inquiries through phone calls, email, and live chat. - Managing Customer Databases: This project requires proficiency in maintaining databases across various platforms including CRM systems, Excel spreadsheets, and online database platforms. - Analyzing Customer Feedback: An ideal candidate will have experience in analyzing customer feedback to help our services grow. The ideal freelancer for this project should possess: - Proven experience in customer support and management - Excellent communication and interpersonal skills - Proficiency in using various CRM systems, Excel, and online database platforms - Familiarity with analyzing customer feedbac...

I have a large volume of numerical data that needs to be entered from multiple digital files. The files will be provided to you in a digital format. Key Requirements: - Data Entry: Accurately input numerical data from digital files into a specified format. - Efficiency: Handle a substantial quantity of data in a timely manner. Ideal Freelancer: - Proficient in data entry with experience in handling numerical data. - Attention to detail to ensure accuracy. - Previous experience with large-scale data entry projects is a plus.

...consistent business operations that my RCM enterprise adopts. 2. Include Key Components * Income Statement: A detailed income statement highlighting the revenue and expenses over a specific period. * Cash Flow: A cash flow statement displaying how changes in balance sheet accounts and income affect cash. * Balance Sheet: A report that summarizes my firm's financial standing in terms of assets, liabilities, and shareholders' equity. * Revenue Breakdown: Thorough analysis of different streams from where the business is generating its revenue. * Cost Breakdowns: An explanation of how much the firm is spending on its employees among other operational costs. Ideal freelancers for this project are those with a strong background in finan...

I'm seeking a google sheets expert to design and set up a customized sales and expense tracking system for my start-up smoothie/juice outlet. - The system will primarily track weekly sales - The expense tracking should be moderately detailed, breaking down expenses into categories such as ingredients and utilities. - The ideal sheet will include forecasting models, particularly incorporating seasonal adjustments and growth rate calculations for sales. The freelancer should have: - Proficiency in Google Sheets, particularly in setting up automated calculations and formatting for ease of use and understanding. - Experience in financial modeling and projection, with specific experience in the food/beverage sector being a plus. I'm looking for a system that can be easi...

I have a large volume of numerical data that needs to be entered from multiple digital files. The files will be provided to you in a digital format. Key Requirements: - Data Entry: Accurately input numerical data from digital files into a specified format. - Efficiency: Handle a substantial quantity of data in a timely manner. Ideal Freelancer: - Proficient in data entry with experience in handling numerical data. - Attention to detail to ensure accuracy. - Previous experience with large-scale data entry projects is a plus.

...Understanding of the process control automation industry - Proven track record in B2B appointment setting - Ability to work independently and efficiently - Must have your own tools to make it happen. The rate given here is arbitrary placeholder only, you must bid here a fixed price (no hourly work) for a qualified meeting that gets conducted. We shall pay the fixed agreed upon amount as an hourly rate. Another amount will be paid if we close the job with your follow-up. Please let us know how many hours /day you can devote and when to when, else we assume you will devote 10 hours daily at hours we shall specify. The target area to start will be north america. Respond only if you can take it up & do the job successfully as training & setting you up in our system will be a...

I'm establishing a personal website that's designed to retrieve a specific message from my Hotmail email account and display it. In the context of this, the "specific message" is a temporary code. Here's a brief insight into what I'm envisioning: - Email Targeting: The website should allow for the selection of any Hotmail email address. The purpose of this is to ensure that the site can pull messages from different accounts as needed. - Specific Message Retrieval: The core functionality will be to retrieve and display a specific message from the selected email account. That message is usually a temporary code from netflix. - Search Function: A search bar is necessary for sifting through emails quickly. - Auto-Refresh: I...

...capable of identifying any glitches or issues that may hamper the gameplay experience. They should ideally have a gaming background or extensive experience in testing game mechanics. - Graphics and Visuals: The scope of testing also includes checking the graphical output of the game. Testers with an eye for detail and a keen sense of aesthetics would be a great fit. - Multiplayer Functionality: Another key area for testing is the multiplayer functionality. The tester should be adept at inspecting the seamless connection and interaction between multiple players. Prospective testers should be proficient in cross-platform applications and have a solid track record in detecting and reporting issues that can affect end-user experience. Testing will be done in person in the Los An...

I'm looking for a skilled individual to erase logo watermarks from a collection of approximately 700 JPEG and PNG principally images. Each image contains a watermark of medium complexity that needs to be professionally and thoroughly removed without compromising the quality and integrity of the image. Key Requirements: - Keen eye for detail to ensure complete logo removal - Ability to maintain the quality and integrity of the JPEG images Prior experience with similar projects will be highly beneficial. We split the project in 7 pack of 100 images to finish fastly Bid per a pack of 100 images

I'm looking to hire someone who can create an Excel VBA workbook to seamlessly integrate with my Zoho Desk setup. This workbook should be specifically engineered to perform the following: - Retrieve the required information from Zoho Desk tickets upon pressing a button inside Excel. Specifically, I need someone skilled in Excel VBA programming and API integration work to: - Design a user-friendly interface in the workbook where one can press a button to initiate the retrieval of ticket information. You should be able to retrieve the latest ticket, and then have two more buttons to go to next & previous tickets. - Implement secure API connections to Zoho Desk to enable the retrieval of ticket information usuing oauth. The fields I need are: Subject A...

I need emails from these companies of CEO ot anyone else working in financials, sales, or partnerships. Data scraping from rocketreach of the emails of the people that you can find with relevance from these companies in the image. Excel sheet with company name in the rows and in the 3 columns full name, email and position in the company

Data entry operator and my work very clear

...the travel industry. To quote a great man, quality isn't an act - it's a habit. I'm entrusting that habit to you. The aim will be to: 1. Attract investors - we're not just talking general investors, we're talking stakeholders in the travel industry. They should walk away envisioning how KeptChain revolutionises the entire game. Key points include: - Financial Prospect - KeptChain isn't just another token. It's the safest, most transparent, and reliable cryptocurrency out there. That's a promise. - Technological Advantage - This doesn't just include it being the first crypto in the travel industry. Let's highlight how it sets the benchmark. Target Audience: - Potential investors - they want to see figures that impress. - Travel ...

I'm looking for an experienced professional in Excel to create a custom financial tracking template for me. Bonus if compatible with both google sheets and excel. Key Elements: - The template needs to include sections for tracking income and expenses. - Additionally, I need sections for debt repayment tracking and Year To Date (YTD) tracking. - The template should be designed in a way that it is easy to update monthly Ideal Skills: - Proficiency in Excel and experience in creating financial tracking templates. - Knowledge of financial principles and ability to design a user-friendly, visually appealing template. - Attention to detail and ability to customize the template to meet my specific requirements. Please include samples of similar work you've done ...

...proposition pitch deck. Here's what I'm looking for: - Background Design: The current backdrop looks bland. I want it changed to a professional and minimalistic design that can make the presentation more appealing without diverting too much attention away from the content. - Layout: The slide layout needs improvement. It looks cluttered and unorganized at the moment. It'd be great to have it arranged in a clear, straightforward manner to accentuate the important points and make it easy for the audience to follow from one point to another. Please import icons or logos to improve the presentation. Leave spaces where you think it would help to have my photo or other content. - Formatting: The text, graphs, and flow charts appear messy. I need them to ...

...Budget: $150 Project Deadline: Within one day Project Type: Custom WordPress Plugin Project Overview: Custom WordPress plugin required to allow a user to view data from a database table in a user friendly way. PHP Version: 8.2 and above Number of Shortcodes: 1 (we will be inserting the shortcode into various pages & posts to display the plugin functionality. Overview of plugin functionality: The purpose of this script is to retrieve a list of matching records from the db table & display this data in a clean and user friendly way. Process Flow: - Use shortcode attributes on the page/post to quickly retrieve matching records from the database table - If there are matching records display the data in a clean in-post widget - If the request returns NO d...

I'm looking to create a detailed list in Excel from the website AND filtered by clicking on 'Hardware' under 'Products' which is on the left side in the 'Filter' section. The list should have two columns - the first for the Company Name and the second for the Description available on the website. Key Requirements: - Copy the Company Name into Column 1 and the Description into Column 2 of the Excel sheet. - Description should be directly copied from the provided URL. Ideal Skills and Experience: - Proficient in Excel and web scraping. - Attention to detail to ensure accurate data transfer. - Previous experience with similar projects would be advantageous.

I need an immediate migration from GoDaddy to another hosting provider, most likely Hostinger, for my WordPress website. The primary reason for this migration is to tap into better performance capabilities that my current hosting provider is unable to deliver. Key Requirements: - Faster Loading Times: The new hosting provider should be able to significantly improve my website's loading speed. - Higher Uptime Guarantee: I need strong assurances that my website will be up and running almost constantly. - Improved Security Features: I require enhanced security measures to protect my website and its data from any potential threats. The ideal freelancer for this project should possess the following skills and experience: - Proficient in WordPress migrations - Experti...

Excel Chart Re-Design for University Work Allocation System We are looking for somebody to complete the development of an excel-based teaching allocation database for a relatively large university department (approx 100 teaching staff). We currently make use of an excel template that roughly cross-references university courses with teaching staff and allocated time commitments for specific tasks. This is quite a complex information array, however, with so many staff members and courses (approx. 120), especially where multiple staff members are co-teaching courses with different task responsibilities. While our current template achieves its desired information management purpose, in its present state its structure is relatively complex and not user-friendly or ...

Looking for an expert who can bring my educational content to life with vibrant, engaging 3D animations. The animations should be a blend of character-based and abstract to maintain viewer interest. Key Requirements: - Skilled storyteller through 3D animation. - Experience in character-based and abstract animation. - Excel in conveying complex information simply and clearly, ideally within an educational setting. - Ability to work collaboratively, ensuring your creations align with my vision. Enhance your bid with relevant work samples, especially animations used for educational purposes. I am excited to see your creativity at work!

...this should allow the customer who clicks onto the products or services to directly to go the vendor site using cookies which will then enable us to become or earn affiliate commissions. We need to be having the best update technology which can give us commissions from using affiliate services/ methods. 3. The website must earn revenue from affiliate marketing, each products we advertise should earn us revenues by allowing the cookies to deliver, we must use the best technology for our site. 4. The site must earn revenue from ads, using many updated technology for our site, you should implement the best Technology including Adsense and other services 5. The website should have banners so we can account for many impressions. These banners should be on the...

...through voice commands and assist in carrying out everyday tasks. My focus is to have a voice assistant that is both functional and easy to use, but I would be willing to work through the learning curve if needed. When the user opens the program, it should be possible to use it with/without an account. I will teach the program to do actions. It should be possible to memorize actions to send to another user by email as a computer file. I would change the names of buttons on settings. 7 days will be free to use it, but later it should be possible to use the program only after payment by card. Key Functionalities: - Set reminders: The voice assistant should be able to set reminders for the user based on voice commands. - Web search: The tool should be able to conduct web searches b...

Website on Wordpress License key generator with DB API for Excel Template connecting to DB for license key validation. Dashboard for administrator enter buyer/customer account credetials. The administrator must be able to enable and disablle accounts. Update Excel Template LicenseValidation code for connectiing to API/DB. I will privide this Excel Template code file.

Hello everyone! I would like to create a Youtube Channel with a list of Series of Bengali poems recitation for an individual. I have severa...free sketches, paintings and images which are fit to the poem sentences/situations 2. Each video should have background music according to the theme of the recitation. 3. Audio quality should be edited through different tools like Noise reduction, Auto duck, Decibel control and studio effects. But, original voice should not be tampered. 4. Error in the audio file should be removed and maintain the pitch I have 50+ Audio files to convert in to Professional Youtube Videos. There will be more similar work if you do good and I will need a sample from you to select one or two video creators. Newbies are welcome if you are exceptionally goo...

I need an Excel expert to update my spreadsheet. The main tasks include: - **Formulas and Calculations:** I require formulas to be implemented for various calculations. The freelancer should possess a strong understanding of Excel functions and be able to apply them accurately. - **Formatting:** The formatting of the spreadsheet needs to be updated. This includes: - **Font Styles and Sizes:** I need the text in the spreadsheet to be consistent and visually appealing. The freelancer should have a good sense of design and layout. - **Number Formats:** Incorrectly formatted numbers need to be corrected. The freelancer must be meticulous and detail-oriented in this aspect. - **Color Changes for Expired Dates:** An important part of the project is changing the color of ...

I'm looking for an experienced Excel and PineScript expert to create custom Excel formulas replicating my developed PineScript indicator. The indicator performs functions for Bollingerbands and Keltner Channels. The task will be to incorporate Open, High, Low, Close prices into the Excel formulas. Please note, data collection or data visualization is not required for this project. To give your best, you should possess an advanced understanding in: - PineScript - Creating complex Excel formulas Looking forward to your informed bid.

I need help with an Excel sheet that will be used for data analysis, specifically sales distribution. The sheet will include a mix of sales data, customer information, and product inventory. Key tasks: - Organizing and inputting the provided data correctly - Creating a system for sorting and analyzing the data - Developing a system for tracking sales distribution effectively - Potentially applying necessary calculations and formulas to enhance the data analysis Ideal Skills: - Proficient in Excel, including data analysis and financial functions - Experience with sales data and distribution analysis - Strong attention to detail and organizational skills - Ability to create formulas and calculations - Familiarity with customer information and product inventory m...

...fields into an Excel (.xls) file. The database consists of approximately 150,000 entries. Each record includes data such as name, business name, contact information, date of foundation, etc. Ideal Skills: - Strong experience in Web Scraping - Proficiency in transferring data into .xls format - Attention to detail to ensure all available fields are captured Purpose and Deliverable: - The objective of this project is to use this information for data analysis. - The final output will be an Excel (.xls) formatted file containing each scraped database entry. Operation Specifics: - You would be required to locate and scrape the database by Zip codes. - A full export of all accessible information per entry is needed. Your expertise in internet research, data mining, and...

I'm in search of a meticulous data entry specialist to help with a simple text data entry task. The job is quite straightforward, involving the transfer of information from digital files to a different format. The role strictly involves data entry without the need for any form of data analysis. Key responsibilities: - Accurately entering text data from digital files into a specified format. Ideal Skills and Experience: - Proven experience with data entry. - Attention to detail. - Proficiency in working with digital files and transferring data.

...tool will be to check if the numbers on my list are active on Whatssap. The end goal is to utilize these numbers for promoting my business. Key Features: - Bulk Phone Number Verification: The tool should be able to check multiple phone numbers at once. It should separate the active numbers from the inactive ones. - Whatssap Compatibility: The tool needs to connect with Whatssap API to confirm the activity of the numbers. Delivery: - Data Export: I require the verified numbers to be exported to an Excel spreadsheet for easy access and use or .txt file Skills & Experience: - Proven experience in API integration, specifically with Whatssap. - Strong programming and software development skills. - Experience in building phone number verification tools will be a plus. ...

... - The Skills Required: 1. Strong grasp of course development tools, methodologies, and practices. 2. Excellent understanding of PDF, PPT 3. Ability to add company branding to the material. You will need to copy and paste and format the material into a PDF and 5 PPT based on chapter. - The Project Scope: 1. Convert the provided PDFs into a consolidated PDF with just the required information from the specific pages of information provided. 2. Create a series of 5 PPTs to represent each chapter of the course. Your expertise in the field will help in creating a course for adult learners. You will be relied upon to transform the content of the static PDFs to help assist in the creation of the new course. This job needs to be completed no later than Friday, April 12th. All mater...

I need an experienced HTML developer to provide guidance on webpage code. The key goals are to add an auto-population feature and convert an existing Pop Up into a Modal. Key Requirements: - Provide the framework for an auto-population feature in the HTML code. Whether this is through regular html or implementing a DOM. Once you've shown what code works for more than 2 of the div ID's in the script I will duplicate across all other scripts. No need for your to do this yourself. Just provide the initial coding. - The auto-population should be activated based on two specific VAR (variable) included in the "Autopop ". The autopop will then open a specific Menu item based on the VAR and the Script AutoPop Matrix. - Take the existing birthday pop-up ...

I'm looking for a freelancer with excellent attention to detail and proficiency in Microsoft Excel and Word. As part of this project, you will be required to manually enter data from Excel files into a Word document. Key Requirements: - Strong Microsoft Excel and Word skills - Proven experience in accurate, manual data entry - Ability to work with robust data sets Deliverables: A Word document with the data accurately entered from the provided Excel files. Your ability to deliver clean, accurately transcribed data is essential for the success of this job. Attention to detail is paramount. I look forward to working with detailed and skilled freelancers.

I am seeking a proficient developer to create an advanced website data Reader The tool should Read the following information daily prices and another data That I would explain later. Ideal skills for this project consist of: - Extensive experience particularly with this task - Proficiency in data formatting. - StormProxies - PHP - Python - RocketSoruce API - Server Management The output format should be compatible with Magento 2 API. This project demands a high level of accuracy to ensure the scrapped data is both comprehensive and precise. Please bid only if you can fulfill these requirements.

I need an assistive hand in a data extraction task that requires sharp focus and meticulous attention to detail. The task involves: - Extracting email addresses from an Excel spreadsheet - Maintaining accuracy and precision during the data entry process, ensuring no data is missed or inaccurately entered Proficiency in Microsoft Excel is a must for this task. Previous experience in data extraction or data entry is highly desirable. You should be adept at handling large volumes of data, have a keen eye for detail, and are able to keep track of your progress systematically. Let me know your capacity per day/week as this can be an ongoing project. Please dont negotiate on the price beyond the Bid provided

For my company, I need an expert with extensive experience in data consolidation and import to QuickBooks. - The project involves the migration of the company's financial data for the years 2022 and 2023 which is stored in Excel spreadsheets currently. - The data needs to be consolidated into a single file before importing into a new Quickbooks instance. As an ideal candidate, you should have: - Experience with Quickbooks data import - Excellent understanding of data consolidation - Proficiency with Excel spreadsheets - A keen eye for detail and the ability to maintain the integrity of financial data during the import process.

I'm looking for an expert who can accurately create 3D models of buildings from drone images captured by DJI Mavic. The models should be ultra-precise, reflecting high details, complete with fixtures, textures, and shadows. Knowledge and experience in using advanced 3D modeling software such as pix4d or agisoft would be advantageous. Requirements - Prior experience in 3D modeling from drone images - Expertise in using advanced modeling software (pix4d, agisoft) - Attention to detail - Ability to interpret and work with high resolution images. This project requires a keen eye for detail and a strong understanding of architectural design elements. Please provide samples of previous similar work when bidding.

My colleague and I at Magner Occupational Therapy are looking to build an online educational platform for kids and teenagers with learning disabilities. We are currently looking for an animator to...for an animator to help us create short, step-by-step video models to teach essential daily living skills to people with autism and other disabilities. This is a niche market with a lot of room to grow. Our research shows that simple animations where a task is broken down into simple steps are the most effective method for audiences of young age to learn these skills. I have provided a link to another platform that offers a similar service to what we are aiming for. Pickle system offers educational animation clips that operates based on a monthly subscription model.