How to link two excel files in sharepoint 2013 jobs
I have multiple Excel files that contain customer details such as name, address, suburb, postcode, and telephone number as part of delivery manifests for a freight provider. I'm looking for an Excel expert who can help me consolidate these files into a single, clean customer database. There are approximately 75 separate excel files and about 600 customers. Key Tasks: - Extract contact details from all files - Merge all files into one without duplications - Count and record how many times each customer appears across the separate freight manifests The final merged file should be in Excel format and include the contact details along with an appearance count for each customer. Ideal Skills & Experience: ...
I'm looking for an Excel wizard to craft a reconciliation tool for two payment datasets - our Genie Ledger and Payment Gateway Data. Key Tasks: - Identify critical data fields for reconciliation, focusing on Transaction ID, Amount, Date, Payer Information, Payment Method, and Bank Details. - Develop a user-friendly tool that compares both datasets and displays all calculations on a dedicated front cover sheet. - Spot any discrepancies and highlight them in red on the front cover sheet. Ideal Candidate Should Have: - Extensive experience with Microsoft Excel, particularly with macros and VLOOKUP. - Strong analytical skills and attention to detail. - Ability to present data clearly and in a list format. I need a straightforwar...
I'm looking for a web interface to help soccer coaches and parents track player training progress. This platform will monitor multiple soccer and kinesiology metrics, providing a comprehensive view of each player's development. The dashboard will need KPI summaries, time-series trend analysis, peer comparison charts, and gamification widgets. The goal is to deliver a storytelling-driven experience that cleanly displays each player's progress, compares them to peers or bio groups, and helps parents and coaches quickly get actionable insights. Key Features: - Tracking of various soccer and kinesiology metrics - User-friendly interface for coaches and parents Ideal Skills: - Figma Design - Web Development - Data Integration - User Interface Design Your d...
I will migrate blogs from the old website to the new website, add the AdSense feature to WordPress, and change a link.
Features 1. Announcement Broadcasting • The bot will allow admins to send announcements with text, images, or videos. • Admin Command: /send • After using the command, the bot will: 1. Prompt the admin to input the message and attach any media (optional). 2. Ask if the message should be sent immediately or scheduled for later. • For scheduled messages, the admin specifies the date and time. • Once the broadcast is sent: • The bot generates an Excel report showing: • Total number of recipients. • Names and usernames of users the message was delivered to. 2. User Management • The bot will keep a record of all users who activate it. • Admin Command: /users • Generates an...
We have an existing Google Sheet that we want to turn into an Excel Sheet, but when we download it and open in excel the formulas to not come with it properly. Wanted to see if y'all could help us with it?
...assistance in collecting and organizing product information for a new online store. I have a spreadsheet with 2475 product lines distributed across five suppliers. Each product line includes a direct URL to the supplier's product (search) page. Your task will be to extract product images, descriptions, and any relevant details from these pages. If a product is no longer available, it should be skipped, and this should be noted in the spreadsheet. Supplier Breakdown: Casu: 136 products DCT: 327 products Kama: 294 products Max Fritid: 1169 products Movera: 545 products Deliverables: Structured Data: Use the provided Excel sheet and fill in the designated columns with extracted information, including: 1) Product Name 2) Description 3) Produ...
I need an expert in Microsoft Power Automate and C# to help me automate my weekly email process. Currently, I manually prepare emails in MS-Word, pulling customer data from MS-Excel, and sending through MS-Outlook using mail merge. I utilize 25 different email accounts, sending 2000 emails from each account to my customers, with the content being a price list with images. I want a system that automates this process. The emails should be sent from the 25 accounts to the customers from the Excel file automatically, with each account sending out 2000 emails. Skills and experience required: - Proficiency in Microsoft Power Automate - Experience with C# for custom scripting - Familiarity with mail merge in MS-Word, MS-Excel...
I need a SharePoint site designed as an Intranet portal primarily for external partners. The site should incorporate functionalities such as file sharing and project management tools. Key Requirements: - Design a SharePoint Intranet portal - Implement file sharing capabilities - Integrate project management tools into the portal Ideal Skills and Experience: - Proven experience in SharePoint site design - Strong understanding of project management tools - Ability to create user-friendly, secure, and efficient portals for external collaboration.
I'm seeking a Python developer proficient with the Deepgram API to create code that extracts VAD variables from WAV files. The extracted data should be displayed against the corresponding sound files. Key Requirements: - Implement using Python, as it's my preferred language for this project. - Use the Deepgram API to extract VAD variables. - Include Speech-to-text transcription in addition to the VAD variables. Ideal Skills: - Deepgram API experience - Python programming - Audio processing knowledge - Speech-to-text transcription skills Please note, I will be providing WAV sound files for this project.
I'm seeking a meticulous freelancer for manual data entry tasks. You'll be working with provided PDF files and inputting data into an Excel spreadsheet. Key Responsibilities: - Carefully extracting and entering data from PDF files into an Excel spreadsheet - Ensuring accuracy and attention to detail throughout the process Ideal Skills: - Proficient in Excel - Excellent attention to detail - Previous experience in manual data entry - Comfortable working with PDF files.
I can write more articles of the same kind for you.
I have a WooCommerce platform for selling registrations for sports events, and I need to create a conditional form during the checkout process to determine whether the person making the payment is the athlete or someone else paying on their behalf. This is crucial because I need to collect the athlete’s personal information, and often, the payer is not the athlete, making it difficult to identify who the competitor is. Key Requirements: Conditional Form Logic: At the beginning of the checkout process, the form should ask if the person filling out the form is the athlete or another person paying on their behalf. If the payer is someone else, an additional form must appear to collect the athlete’s personal information. If the payer is the athl...
I need a proficient developer specializing in Microsoft technologies to implement a system that syncs my emails between Outlook and SharePoint. We need a add-in to outlook, so we can see all sharepoint folders etc in outlook, so we easily can drag email, attachements both ways. Easy access
I'm an advanced user of Microsoft Excel, seeking assistance with some issues I'm encountering. You will need: - Extensive knowledge of Microsoft Excel - Experience with troubleshooting complex spreadsheet problems - Ability to communicate solutions clearly and effectively
Hi, I'm looking for someone to do online research to find pricing on equipment and make phone calls as needed to get quotes from equipment owners. I will pay you bonuses for finding better deals. Must have strong English. Must work between 9am-5pm Eastern Standard Time First job is to look for a used tanker truck. I'm going to use the truck to transport used cooking oil. Please find all vehicles from all of these sites and add one row per each vehicle into the attached Excel sheet. Fill out just the price, year, mileage, and link columns: 1. 2. 3. Facebook marketplace 4. https://www.ironplanet.com/Tanker+Trucks 5.
I need assistance with importing our sales leads from an Excel file into our CRM system, Recman. Key Requirements: - The Excel file is stored on Drive and needs to be accessed, processed and imported. - The specific data fields to be imported include: Contact information, Lead source, and Sales history. - No specific data transformation or mapping is required, the data can be imported as is. Ideal Skills: - Proficient in handling Excel files, particularly in a Drive environment. - Familiarity with Recman CRM is a plus. - Good attention to detail to ensure all relevant data fields are correctly imported.
I'm in need of a SharePoint expert to assist in enhancing my SharePoint site to help finish a project. The primary focus will be on improving the site's functionality and features. Key Requirements: - Expert in SharePoint with a focus on functionality and features - Experience in managing permissions - Skills in preparing the site for further expansion - Ability to troubleshoot and provide ongoing support This project is crucial for helping me complete my current task. Your proficiency in SharePoint and your availability is very important to me.
I need a comprehensive movies list exported into a CSV from IMDB. list should include key details like title and release year, director and cast, as well as genre and rating. Ideal skills and experience for the job include: - Proficiency in data management and export - Extensive knowledge of movies and film industry - Skilled in using Excel or CSV formatting.
... automated notifications, staff/vendor management, analytics, data import/export, and robust security measures. Initially, we’ll focus on a web-based solution using React (front-end) and Node.js + PostgreSQL (back-end). We also plan to future-proof the system for possible expansions to desktop and mobile platforms. If you have experience building complex, secure, and scalable SaaS/web apps, we’d love to see your proposal! Key Features & Modules 1. Property & Unit Management • Track properties, define units (rent amount, occupancy status). • Link units to tenants, show vacancy vs. occupied, manage lease details. 2. Tenant & Lease Tracking • Store tenant info (contact, lease agreements), set lease start/end d...
I'm looking for someone skilled in Excel to help me with a data transfer task. I need to pull information from one spreadsheet and add it to a column in another. Key Requirements: - Transfer of text data between two simple spreadsheets (comprising simple rows and columns) - Matching of data based on an exact match in a single column Ideal Skills and Experience: - Proficient in Excel - Attention to detail to ensure accurate data transfer - Experience in data handling tasks
EXCEL Manufacturing Product scheduler/run time tracker We are developing a means to schedule components in an integrated excel spreadsheet that includes various production steps: (Functions) Laser, shear, punch, bend, paint, assembly, weld, assembly 2, shipping. To be save on a network-share point so all can access same document. The idea is to have a laptop at each station (listed above) 1a,1st step: Manual enter/copy paste-from engineering Initial step-Enter data (component part number(description)) into the first sequence, list all items from the project that needs to be produced. once entered, you can filter material gauges, material types in order to consolidate production run on the LASER. When running the selected i...
I need help organizing confidential client data in an Excel spreadsheet. The data is currently in one column and needs to be split into appropriate columns for First Name, Last Name, Phone number, Email, Birthdate, Mortgage start date, mortgage term, and Client Birthday. - Required Skills: Intermediate level Excel proficiency, with experience in using formulas to manipulate data in Excel. - Platform: The session will take place on Microsoft Teams, where I will share my screen. - Data Format: The data is currently organized in an Excel Spreadsheet. Due to the confidential nature of this data, I am unable to share it via email. The ideal freelancer for this job would be able to work swiftly a...
I'm in need of a doors and windows-based software that can generate production drawings and quotations based on my cost estimations. I've laid out the algorithm in Excel files, which will be provided for this project. As a developer, your responsibilities will include: - Creating a user-friendly interface (UI) that allows easy access to the software's functions. - Implementing the cost estimation and production drawing generation features. The ideal candidate for this project should have robust experience in: - Java with JavaFX: This is my preferred programming language and framework for this project. - Software development for Windows: The software needs to be compatible with this platform. - UI design: The software should...
I have a small excel file. I need to convert in excel VBA. The project will be completed by Spanish language. The file and more details will be shared via chat box. Thanks!
...seeking a skilled Excel expert to create a reconciliation tool for comparing two payment datasets. The first dataset comes from our internal ledger (Genie Ledger), and the second from our payment provider (Payment Gateway Data). Key Tasks: - Identify important data fields for reconciliation, considering factors like Transaction ID, Amount, Date, Payer Information, Payment Method, and Bank Details. - Develop a tool that compares the two datasets, showing all workings on a dedicated front cover sheet. - Identify any reconciliation discrepancies and highlight them on the front cover sheet. The ideal candidate should have: - Extensive experience in using Microsoft Excel, particularly with macros - Strong analytical skills - Attention to de...
I'm looking for two, 15-30 second, 2D animated, casual tone, "how to" commercials for my company. The animations casual style but keep in mind that our company is a foundation giving to the elderly in the society, conveying the ease and fun of using our products or services. Ideal skills and experience for the job include: - Proficiency in 2D animation - Experience in creating casual content - Ability to deliver within the specified timeframe - Prior work with "how to" commercials is a plus.
...• Secure Login • Restrict login to authorized employees only (e.g., domain-like login or equivalent through Azure AD/Intune). • Implement MFA or a similar method to reinforce secure logins. • Usage Restrictions • Block social media, streaming sites, and any inappropriate or non-business-related websites. • Allow only business-critical apps and websites (primarily Microsoft 365 suite and any other approved tools). • HIPAA Folder Protection • Some employees need HIPAA compliance for certain folders in SharePoint; ensure access is locked down and logs are recorded appropriately. 2. Personal Devices (BYOD) • Limited Company Data Access • We do not plan to enforce full MDM or MAM policies, but we d...
I require assistance with developing a macro in Excel. The macro needs to interact with local Excel files and perform specific functionality. The details of the functionality will be provided after the initial discussion. Ideal skills and experience for the job include: - Proficiency in Excel, particularly in macro development - Experience with automating tasks in Excel - Ability to understand and implement specific instructions - Good communication skills for discussing project details
I'm looking to develop a multiuser website for collecting school ID card data and capturing photos. Key Features: - User Access: The website will be accessed by teachers and administrators. - Photo Capture: Users should be able to upload photos from their devices and also utilize real-time camera capture. The website should NOT include editing tools such as cropping. - Data Collection: ID card data will be uploaded via CSV/Excel files. Ideal Skills: - Full-stack web development - Experience with real-time photo capture integration - Proficiency in handling CSV/Excel uploads - Knowledge in developing multiuser platforms Please provide examples of similar projects you have completed.
We are looking for experienced freelance link builders to help us secure high-quality backlinks for our website, , through ABC link exchanges. The ideal candidate should have experience with outreach, strong negotiation skills, and a proven track record of securing authoritative backlinks. You will be responsible for finding relevant websites, reaching out to webmasters, and securing links in exchange for links from the websites we provide. Responsibilities: Identify niche-relevant websites for link exchange. Outreach to website owners, editors, or managers to negotiate ABC link exchanges. Provide regular reports on progress, including sites contacted, agreements made, and live links secured. Ensure high-quality and niche-rel...
I require a new feature for my mobile app that automatically sends GPS tracking links to both logged-in and guest users via email. This will allow them to track their shipments in real time. - Ideal Candidate: The ideal freelancer for this project should have extensive experience in mobile app development, particularly in implementing new features. - Skills: Proficiency in email integration, knowledge of GPS tracking systems, and a good understanding of user interface design for both logged-in and guest users are crucial.
I'm seeking a beginner-level assistant for my regular work. Your primary tasks will involve conducting research and creating simple PowerPoint presentations on given topics. Key Responsibilities: - Researching topics and creating simple PPTs - Hiring and interviewing team members - Managing existing team and content in excel Skills and Experience: - Strong communication skills English/Hindi - Proficiency in Excel and PPT Ideal Candidate: - A college student with a working computer - Looking for long-term work - Flexible with working hours Please note: - We will connect over a call on Saturdays or Sundays for planning and learning sessions.
I need an expert in Excel automation and API integration to help me in calculating GHG emissions, specifically Carbon dioxide (CO2). The primary data source for the calculations will be an API, so experience with API integration is crucial. The project involves: - Automating the process in Excel for GHG emissions calculation - Using API for manual data entry - Focusing on Carbon dioxide (CO2) emissions The final output of the project should be in the form of a dashboard visualization. Therefore, experience in creating dashboard visualizations is essential.
I'm looking for help with rewriting and transferring some Excel tables for financial reporting. The tasks are straightforward and primarily involve basic data transfer without the need for specific formulas or calculations. Standard formatting is acceptable, so no specific formatting guidelines need to be followed. Ideal skills for this project: - Proficiency in Excel - Attention to detail - Basic understanding of financial data - Good data transfer skills
I need my intricate Excel sheet transformed into a PHP web application, complete with a MySQL database. The Excel file consists of 10 interconnected tabs, filled with VBA functions and classes. Key Requirements: - Replicate data calculations and transformations in PHP - Create user input forms and validations - Implement user authentication system with multiple roles - User roles should include: - Admin: Full control and oversight - Editor: Able to modify content - Viewer: Restricted to observation only Ideal Skills: - Proficiency in PHP and MySQL - Extensive experience with Excel VBA - Strong understanding of user authentication systems - Ability to replicate complex data processes in web applications Please o...
...someone to help us enhance our existing dataset by adding publicly available email addresses. Source of Dataset: The dataset is provided in Excel format. Size: There are 11,817 entries requiring email addresses to be added. Data Type: The emails must be entered into the same spreadsheet. Important Guidelines: All email addresses must be sourced from publicly available information in compliance with GDPR and other applicable data protection regulations. The methodology used to locate these email addresses is at your discretion, provided it adheres to legal and ethical standards. Each email entry should be accompanied by a URL or source reference to verify its public availability. Ideal Candidate: Exp...
...Tweaks Project Description: I have installed a raw PHP survey script and require the following customizations to improve its functionality and user experience: Optimize CSV Import Performance: Currently, importing large CSV files takes too long and sometimes fails to provide a file for download. I need this process optimized for efficiency and reliability. Enhance Graph Display: The results include graphs, but the values aren't displayed on the graph bars. For better visualisation, I need the numerical values to appear inside the graph bars as text. Add Averages to Reports: In the report section, include an average of the survey results. This should be visible both on screen and in the exported .xlsx file. Skills Required: PHP M...
...20 30 60 80 100 10 Cork 25 35 65 85 105 10 Galway 22 32 62 82 102 10 ... (Repeat for all 26 counties but different pricing per county excel be provided) Fastway Note: If all items are Fastway-eligible, apply a flat €10 delivery rate. Product that this applies too already done (and live like this) SIte already has fastways setup done, plust there is enquiry only about products which can't be ordered on the site. We expanding the setup to have 5 weight classes with each state/county (26 of them) having their own pricing for each weight class. However the surcharges for extra items in the basket be same across the 26 counties Logic for Multiple Items in Basket Base Price: Use the highest-tier item's delivery price as the base. Additional ...
I'm looking for a web developer to create a five-page website that publishes data from Excel, specifically bond characteristics. The pages will include: Main, Bonds Selector, Indices, About Us, and an additional Bonds page. A Figma layout is provided and the task is to replicate it accurately. Key Features: - The website does not need to be responsive or mobile-friendly - Users will only view, not interact with or upload, Excel data Design Expectations: - A minimalistic and clean aesthetic, as opposed to modern or overly sleek designs - Corporate and professional styling is not required, but a clear understanding of minimalistic design is crucial Ideal skills for this project include: - Proficiency in front-end web development - Expe...
I'm looking for someone to help me with creating a data entry form . The Excel template is provided by me. This will be a simple form that I can add my projects data to a spreadsheet also I can edit the Data. The Excel rows should be added automatically once a new project has been added .
...professional to ensure the entry, processing and management of data in our systems. The ideal candidate will be proficient in office tools such as Word, Excel, Google Sheets, and will also have skills in data security and the use of Adobe InDesign. Responsibilities: - Enter, verify and update data accurately in databases or documents. - Organize and structure files and databases for optimal accessibility. - Use tools such as Microsoft Word, Excel, and Google Sheets for data management. - Respect data security protocols to guarantee the confidentiality and integrity of information. - Create or modify graphic documents and media using Adobe InDesign. - Produce detailed reports and share them with relev...
Looking for a detail-oriented data entry specialist for product catalog management. (~1,500 products) Key responsibilities: Manual data entry of product information into Excel/Google Sheets Accurately copying product image URLs from provided online sources Following provided guidelines for data organization Requirements: Strong attention to detail Proficiency in Excel/Google Sheets Reliable internet connection Ability to handle repetitive tasks with accuracy We provide full training and ongoing support throughout the project. Part-time/flexible hours available. Please share your relevant experience and availability to get started.
I'm looking for a freelancer to help me link my Excel file containing employee names and shifts to another file. The data is personal and related to roster information. Ideal skills for this job include: - Proficiency in Excel - Experience with data linking - Understanding of personal data handling and privacy - Attention to detail
I'm seeking an Excel specialist to help me create a sophisticated dashboard and tracking tool for compliance data. Key Responsibilities: - Automating processes with macros to streamline compliance tracking - Assisting in the design and development of a user-friendly dashboard - Automated email system which track the due dates and triggers the email to the respective email addresses. Ideal Skills: - Proficiency in Excel with a strong focus on automation - Experienced in complex formula creation and data analysis - Prior experience in designing dashboards and tracking tools - Familiarity with compliance tracking is a plus Please provide examples of previous Excel projects you've completed, particularly those ...
I'm looking for an expert in data management and Excel/CSV manipulation. The project involves merging multiple CSV files with custom combination rules. Key Responsibilities: - Analyze and understand the structure of the provided CSV files. - Implement custom rules to merge specific data from those files. Ideal Skills: - Proficiency in handling and merging CSV files. - Excellent understanding of Excel and its data manipulation capabilities. - Ability to understand and apply custom rules for data combination. - Strong attention to detail. Experience with data science or data analysis is a plus.
We are looking for a talented designer to create editable PSD files for a set of professional-looking website badges. These badges will be featured on our website and should have a sleek, modern design that conveys credibility and professionalism. Requirements: Deliverables: 3-4 unique badge designs, - each saved as a layered, fully editable PSD file; and - each pre-saved in different colors. Include all layers and elements intact to allow for easy modifications (e.g., text, colors, shapes). Design Style: Modern, clean, and professional. Incorporate visual elements commonly associated with awards, achievements, or recognitions. Designs should look credible and eye-catching, suitable for a business website. Creative Freedom: Research existing badge designs...
