Import msp project data excel macro vba jobs

...YNAB system for me that will allow for both personal and professional budget management. Key Requirements: 1. Complete YNAB Setup: - Incorporate my 3 personal accounts and 1 joint account with my wife. - Create budget categories for all personal and professional expenses, particularly for setup costs and ongoing costs. 2. Transaction Import Setup: - Convert my 3 months of bank statements from PDFs into YNAB-compatible CSV files. - Import all transactions and demonstrate how to do this for future statements. 3. Automation for Recurring Expenses: - Categorize recurring transactions (like rent and utilities) so YNAB learns them for future imports. - Provide recommendations for any other useful software. I'd like my expenses categorized by function...

...descriptions and statuses. - Assign tasks and track offline. 6. Document Management: - Attach documents to properties and tenants (e.g., lease agreements). - Enable offline access to documents. 7. Inspection Logs: - Record inspections with notes and photos. - Offline storage for inspection data. 8. Dashboard: - Overview of total properties, occupancy rates, rent collected, and tasks. - Quick-action shortcuts (e.g., Add Property, Record Payment). 9. Data Export/Import: - Export data as CSV/Excel files. - Import data into the app. 10. Alerts and Notifications: - Offline reminders for key dates (rent due, lease renewals, inspections). 2.2 Advanced Offline Features (Phase 2) 1. Work Order Management: - Create, assign, and update work orders. ...

I'm looking for someone to create a Microsoft Word document with a table based on the data I will provide. The table will have 4 columns and 50 rows, titled as follows: "", "name of the product", "name of the drug", "mrp", and "rate". - Data Provision: I will be supplying the data in an Excel spreadsheet. - Ideal Skills: Proficiency in MS Word is essential, as well as familiarity with Excel for data handling. Attention to detail is crucial to ensure all data is accurately transferred and formatted.

I have a project requiring the extraction of latitude and longitude data for addresses contained in an MS Excel file. The addresses are tabular data containing States, Districts, Cities etc. and the job encompasses geocoding 3000 addresses. Ideal Skills and Experience: - Proficient in data extraction and geocoding - Familiarity with MS Excel - Knowledge of geocoding services and tools - Ability to deliver timely results with 100% accuracy.

I'm looking for a VBA expert to create an automation script for me. The script needs to perform the following tasks: - Open a SharePoint Excel file (Excel1) from online and copy a specific Excel sheet to my local drive. - In a local file (Excel2), delete 3 specified columns and copy all rows except the header row to the clipboard. - Open another SharePoint Excel file (Excel3) from online and paste the clipboard information. This project requires a deep understanding of VBA and experience with SharePoint PnP PowerShell. Familiarity with Office 365 is also essential since that's the version of Excel I'm using. Please, bid only if you can meet these requirements.

I'm seeking a skilled data entry professional for categorizing product data. This involves managing product descriptions, prices, and inventory. Ideal Skills: - Native Spanish speaker - Proficient in data categorization - Experience with product data - Highly attentive to detail - Excel and spreadsheet management skills

As discussed will proceed for those 5 images

I'm looking for someone to assist me with data entry from PDF files into an Excel spreadsheet. The data is a mixture of both text and numbers, and primarily, the converted Excel file will be used for record keeping. Ideal Skills and Experience: - Proficient in Excel and familiar with data entry processes - Attention to detail to ensure accuracy in data transfer - Ability to handle mixed data (text and numbers) - Prior experience with data entry from PDF files is a plus Please note that specific formatting or organization in the Excel file may be required, but this will be clarified during the project.

I need assistance with importing user custom fields into a migrated Joomla project. The custom fields are associated with user profiles and contain text data. The fields are standard text fields, with no specific formats or validation rules. Ideal Skills: - Proficiency in Joomla - Experience with data migration - Understanding of user profile components in Joomla - Ability to handle text data Your expertise will ensure a smooth integration of these custom fields into the user profiles of the migrated Joomla project.

I'm seeking a data entry operator with hands-on experience in managing inventory on both eBay and Amazon. Proficiency in Excel or Google Sheets is a must. Key Responsibilities: - Oversee and manage inventory across both eBay and Amazon - Utilize Excel or Google Sheets for inventory tracking, updates and reports Ideal Candidate: - Proven experience with eBay and Amazon inventory management - Exceptional skills in Excel or Google Sheets - Detail-oriented and able to work independently - Knowledge of eBay and Amazon product upload processes would be a plus

I'm in need of a proficient SQL expert to help me with some data manipulation tasks using SQL queries. The main focus will be on performing calculations with columns and modifying the structure of my tables. Key Requirements: - Experience with SQL, particularly in manipulating data - Ability to perform calculations with columns - Skills in adding or removing columns from tables Please note, this project does not involve inserting, updating or deleting records, nor does it require changing data types of existing columns or reorganizing table indexes.

I would like a formula inserted in Column J to rank the data in Column F "Rating" and start a new ranking each time the time changes in Column B. I would like 3 sheets ranked I used a formula that worked for 100 rows. After row 101, it gives a div error, and the rest. I have 7k rows in one sheet. check the attached worksheet. Budget: $5 (fixed price) Post service support is needed.

...tasks. Conduct online research or any other ad-hoc tasks as required. Requirements: Proven experience in CV distribution or as a Virtual Assistant/Personal Assistant. Strong organizational skills and attention to detail. Excellent written and verbal communication skills in English. Familiarity with job application platforms (e.g., LinkedIn, Indeed) and basic office tools (e.g., Google Workspace, Excel). Ability to work independently and meet deadlines....

For 3 sheets, create a formula that ranks values as mentioned in chat. Must be done in 30 usd budget.

I'm seeking a Virtual Assistant primarily focused on data entry tasks, specifically inputting job information, tracking jobs, lead volumes, and prices of quotes sent into spreadsheets. Ideal Skills Include: - Proficiency in spreadsheet software (Excel, Google Sheets) - Detail-oriented and able to maintain high accuracy - Good understanding of data confidentiality and integrity - Experience in data entry and virtual assistance - List all jobs on job sheet - List Email Jobs - Clean Email Folder - How Many Leads we had per Day - All Leads Quoted - All Quotes Sent - Notify Google Chats

I need a freelancer with exceptional data entry skills to assist me in typing data into Excel. I have a general idea of how I want the data formatted, but I will need your expertise and assistance to create a comprehensive and effective template. Ideal Skills: - Proficient in Excel - Strong attention to detail - Excellent typing skills - Good understanding of data entry and formatting Experience: - Previous work with data entry and Excel is crucial. - Experience in creating Excel templates will be highly beneficial. I am looking for someone who is reliable, can work independently and can deliver quality work on time. If you believe you fit this description, I would be happy to discuss this project further with you....

Project Description: We need a web scraping and comparison tool to gather competitor pricing data for approximately 100,000 products that we sell. The goal is to collect and save competitor sell prices to a database for future analysis. Competitor pricing will come from two main sources: Shortlist of specific competitor websites (sites we will provide). Top results from Google Search for the exact product name or SKU. Product Input: We give the Input of all product data (e.g., product name, SKU, and our sell price). Support for bulk upload of product data in formats like CSV/Excel. Competitor Price Collection: Scrape pricing information for each product: From a shortlist of predefined competitor websites. From Google search results that sell the same...

I need assistance comparing 3-4 structured Excel files. This task involves verifying data matches, specifically contract titles and numbers. We are talking about 3-4 columns only in total. Key requirements: - Expertise in data match verification - Proficiency in working with structured Excel files with headers - Ability to provide accurate analysis within an hour If you can commit to this task and deliver accurate results promptly, please place your bid. Please place your bid if you can dedicate the 1 hour of your time now

I've been having issues with the Suremembers plugin. Currently, the downloads for an access group are showing, but they are not 'live' and can't be downloaded. The content in question consists of documents, excel files, and pdfs all packed in Zip files. Despite the downloads being visible, there are no error messages when attempting to download these files. I suspect that the problem might stem from recent changes made to the plugin's settings. Ideal Skills: - WordPress plugin troubleshooting - Specifically with Suremembers plugin - Configuration and settings adjustment I'm looking for someone who can help me fix this issue promptly.

Please Sign Up or Login to see details.

I'm looking for a skilled Excel expert who can create a comprehensive spreadsheet for tracking project deadlines. This spreadsheet should be able to monitor: - Start date and end date of each task - Days elapsed since the task started - Days remaining until the task is due In addition to these tracking capabilities, I also need the spreadsheet to have pop-up reminders for upcoming due dates. Ideal candidates for this project should have: - Strong proficiency in Excel - Experience with creating complex spreadsheets - Good understanding of project management principles.

...file from an upkoaded data file. This part works well by itself. I had the code working with a fixed path for the data file and config file on the local drive but I want to make the code fully functional online. I struggle with data upload and keeping the files throughout the use with the help of session states. The app loses track of the session state of the two files when changing pages or going back to the config page. I need your help to create me code for this: 1. The user must be able to upload on the "Config page" an .xlsx data file and a .json config file (that contains the information which data gets shown on which page) 2. The user must be able to select different pages (select box in the sidebar) then graphs get drawn with the d...

I'm looking for an Excel expert who can help me consolidate data from multiple sheets. The primary goal of this project is data consolidation, specifically focusing on pricing and labor costs. Want to pull information from different tabs on same workbook to use as base pricing model. This is URGENT to be done by noon Thursday CST. Key Requirements: - extremely Proficient in Excel formulas - Experienced in linking data across multiple sheets - Ability to organize data effectively by information from different sheets into main. I can share document to look at if you feel confident.

I am looking for a freelancer who can create an Excel pivot table and generate a statistics report from a CSV file spanning the past 10 years. The specific statistics that need to be included in the report user profile analysis Chart Type: I would like the pivot table to be presented in a bar chart format and line chart to show trending. Time Period: The data should be broken down annually. Ideal Skills and Experience: - Proficiency in Excel and pivot table creation - Strong understanding of statistics and data analysis - Experience in generating reports from CSV files - Knowledge of creating bar charts in Excel - Attention to detail and ability to accurately present data in a clear and concise manner. example data: firstName LastName P...

I'm facing issues with circular references in my annual budget Excel file. These errors are found on the Revenue sheet, the Summary sheet, and the Annual Budget sheet. I need a professional who can resolve these circular references by adeptly using iterative calculation.

Looking for a full stake of developer to complete the project . 1. The landing page ( 6landing pages will be given once you are awarded) should have a corporate and professional aesthetic. Includes: • Registration form: Allows users to sign up for the event. • Event details section: Provides comprehensive information about the event. . 2. Email and messager Bursting System • After a user signs up: • They should automatically receive reminders for the event email and other messager . • Automation tools like Power Automate or other free solutions should be used (NO paid 3rd party integrations allowed). Allow upload xcel and blast together with the sign up . Allow grouping of database list. scheduling options for reminders. Option for allowing unsubscrible...

I have an Excel spreadsheet that contains data on my portfolio's performance. I need a freelancer to help create a chart that visualizes this data in an effective way. Key Responsibilities: - Create a visualized chart that displays the yearly performance of my portfolio mgmt for resale and rent based on purchase price. - Incorporate relevant trendlines into the chart to help illustrate performance patterns. Ideal Skills: - Proficient in Excel with a strong understanding of creating and manipulating charts. - Ability to analyze data and identify key trends for visualization. - Attention to detail to ensure the chart is accurate and easy to understand. With the data already in the columns, this task should be straightforward for someone with...

I'm facing a challenge with my mail merge process from MS Word to Outlook. I can successfully send emails to single email addresses, but I encounter an error when attempting to send to cells containing multiple email addresses, separated by semicolons. The error message I receive states "Microsoft Outlook d...these attempts have not resolved the issue. What I need is for assistance in being able to send emails to multiple addresses contained within a single cell, as a single email. PLEASE BE SURE TO SEND A CUSTOMIZED RESPONSE AND NOT AN AUTOMATED RESPONSE! COOKIE CUTTER RESPONSES WILL BE IGNORED. Skills Needed: - Proficiency in Microsoft Word, Excel, Access, and Outlook - Experience with Mail Merge - Strong troubleshooting skills - Good understanding of data valid...

I'm looking for a proficient WordPress developer to import a specific WordPress template for a business website. The template needs to be customized to include several key features and plugins. Key Features & Specific Needs: - Contact Form: A simple and functional contact form is a must. - Scheduler & Calendar - Service Pages: The website should include multiple pages detailing the services we offer. - Portfolio or Gallery: There should be a section showcasing our portfolio or gallery of past works. - Communication SMS/Email - Payment Method - Subscription Windows - Estimates/Invoices/Work Orders - Accounting ….and more! Specific Needs: - Multiple Plugins: The website needs to be integrated with various plugins for different features. I've identified spec...

I need a freelancer to categorize approximately 2500 items into one main category and at least 1 or 2 subcategories. You'll also assign an expense center based on written instructions I will provide. The items list will be supplied in a spreadsheet. Ideal Skills & Experience: - Attention to detail - Experience in data categorization - Proficiency in spreadsheet software (Excel, Google Sheets) - Ability to follow written instructions accurately

Job Title: Online Tutor for IT & Non-IT Courses Job Type: Part-Time/Contract (Remote) Courses: IT : C, C++, Python, Java, Android development, Graphic Designer, UI/UX developer, Angular Js, Node Js. Non-IT: Digital Marketing, Cloud Computing, Cybersecurity, Advanced Excel, MATLAB, Tally, CAD (CATIA, AutoCAD), HR Operations. Responsibilities: - Deliver engaging online classes. - Customize teaching materials. - Guide students on real-world projects. - Monitor progress and provide feedback. Requirements: - 3+ years of experience in the domain. - Strong communication and teaching skills. - Reliable internet and tools for online classes. Documentation Needed: Updated resume/CV. A sample recorded session (Mandatory). List of topics/courses you can teach. P...

I will Make High DA, Spam Free Dofollow Backlinks for Your Business, My backlinks will be Google-friendly and spam-free, which will help to better improve yo...Directory Submission → Profile Link Creation → Blog Promotion → PDF File Submission → Local Citation Backlinks → Business Listing Submission → Press Release Submission Service Features: 100% indexing in Google 100% Boost up In Google Ranking Up To DA 50 to 90+ Back-links Low Spam Score 100% Manual Work No Bots or Software Contextual & Mixed Back-Links Increase Domain Authority Detailed Excel Delivery Report Please Open chat Box and send message So I can Share backlinks Sample. You can optimized Our backlinks Quality via check our Sample MY First priority “Client Satisfaction...

I need a proficient Excel expert who can modify an Excel sheet with macros created by a previous employee. The job entails adding new features, correcting existing issues, and updating the data. Key tasks: - Add new calculations and formulas - Set up automated reports - Fix incorrect calculations - Troubleshoot and rectify data updating issues Ideal skills and experience: - Strong proficiency in Excel and VBA - Experience in creating and modifying Excel macros - Ability to set up automated reports - Aptitude for accurate calculations - Problem-solving skills for troubleshooting data issues

Hello Hafizshouaibali. I'm interested in your excel template. Would it be for sale? I can put in my own data?

I'm seeking a professional developer with experience in audio engineering ...experience in audio engineering and AI to build an online platform. This platform will use artificial intelligence to mix and master audio tracks, specifically tailored for the heavy metal genre - think distorted guitars, extreme vocals, and fast-paced drums. Key Aspects: - The focus should be on achieving an industry-standard quality of mixing and mastering. - The platform should particularly excel in ensuring the overall mix quality, with clear and powerful instrument separation. - iZotope should be the primary tool used for mixing and mastering. Ideal Skills: - Expertise in AI and audio engineering. - Experience with heavy metal music production. - Proficiency in using iZotope for mixing...

I'm looking for a freelancer skilled in Excel to help consolidate market data from 20-25 spreadsheets. Each spreadsheet has 6 tabs, but all are uniform in format. The task involves: - Manually consolidating the data into one tab of a new Excel file - Sorting the data by specific dates Please note, all source spreadsheets follow the same consistent format. The ideal candidate for this task should possess: - Strong proficiency in Microsoft Excel - Excellent attention to detail - Ability to adhere to timelines This project is perfect for someone who enjoys data work and is looking for a straightforward task.

I need assistance in importing product data from CJ Dropshipping into Google Sheets. Specifically, I need product descriptions and images. Requirements: - Import product descriptions and images from 10 pages of products on CJ Dropshipping into Google Sheets. - Format the product descriptions in plain text. - Knowledge of Google Sheets is essential for this task

I need a program that can manage to print a single label from an Excel spreadsheet. The label is 1.1 x 3.5 single labels. The printer is a Brother QL-1100C. Attached is the spreadsheet and what needs to be printed on the label. I need something that I can just click print and it prints that information from that line. Key Requirements: - Ability to handle queue management, job scheduling and job prioritization. - Specifically designed to print from an Excel spreadsheet onto custom 1.1 x 3.5 labels. - Allow creation and saving of custom label templates for reuse. Ideal Skills and Experience: - Prior experience in developing printer management software. - Strong knowledge of Excel and label printing. - Excellent problem-solving skills and attention to detail. Th...

I'm seeking an experienced data analyst or business intelligence expert to develop a comprehensive Power BI dashboard for me. The dashboard should track sales performance, and it should be updated daily. Key Responsibilities: - Develop the necessary data from Excel spreadsheets to create a compelling narrative within the dashboard. - Design and implement the dashboard to monitor key sales metrics. Ideal Skills and Experience: - Proficiency in Power BI is a must. - Strong data analysis and visualization skills. - Experience with Excel and creating dashboards. - Understanding of sales performance metrics will be an advantage.

Looking for a full stake of developer to complete the project before 1 Jan 2025 . 1. The landing page ( 6landing pages will be given once you are awarded) should have a corporate and professional aesthetic. Includes: • Registration form: Allows users to sign up for the event. • Event details section: Provides comprehensive information about the event. . 2. Email and messager Bursting System • After a user signs up: • They should automatically receive reminders for the event email and other messager . • Automation tools like Power Automate or other free solutions should be used (NO paid 3rd party integrations allowed). 3. Backend Dashboard for Admin • The admin should: • Able to upload an Excel file containing a list of attendees to be ...

I need assistance with descriptive data analysis using Excel. The data for this task will be sourced from various databases. Ideal candidates should have extensive experience working with Excel, particularly in data analysis. Skills in identifying trends, patterns, and insights from data are crucial.

I'm looking for a data analyst to partner with on client projects. Our primary focus will be on creating insightful dashboards in Power BI, conducting comprehensive data analyses, and generating detailed reports. As I have a foundational knowledge of Power BI, this role is perfect for someone who enjoys teaching and can work collaboratively. Key Responsibilities: - Work alongside me to create interactive dashboards - Conduct data analysis - Generate reports Skills and Experience Required: - Proficiency in Power BI, SQL, and Excel - Strong problem-solving skills - Excellent communication skills - Ability to complete project requests within 3-5 days Ideal Candidate: The ideal candidate will not only have technical expertise but also a passion for ...

I'm seeking a proficient web scraper to gather data on news analysis YouTube channels. The task involves collecting and verifying contact details, primarily email addresses and social media handles, and organizing this information into a clean Excel spreadsheet. Key Requirements: - Experience in web scraping and data extraction - Ability to compile a list of YouTube channels based on specific criteria - Skills in data organization and ensuring accuracy - Proficiency in Excel Your role will be pivotal in assisting with outreach and marketing efforts, making this a significant opportunity for those with the right skills.

I need a 3-4 page website to display company data, sourced from a database (likely an Excel sheet). The site should have the following pages: - Home - About Us - Search instruments - Indices Ideal skills and experience for the job include web development, data management and Excel. The primary goal of the site is to showcase information, so a clean, user-friendly design is essential.

I need a Power ...scrapes product information from electronics suppliers and imports it to two different websites via a WiX template, with two different prices. Key Requirements: - The workflow should be able to scrape comprehensive product data including the name, description, price, stock availability, and product images - The scraped data needs to be formatted for import via a WiX template - The workflow should allow for the setting of two different prices for the same product Ideal Skills and Experience: - Proficiency in Microsoft Power Automate - Experience in web scraping and data handling - Familiarity with WiX and e-commerce platforms - Understanding of electronics product specifications and market pricing - Ability to create a workflow that is effic...

I'm looking for a skilled Excel expert who can create our quotation format/template on excel/sheets so that it can be easily modified by us when required. We also need it to be styled a bit and make it attractive.

I need a comprehensive financia...comprehensive financial plan for my startup. This will involve creating around 13 different sheets in Excel covering various aspects of our finances. Key Components: - Revenue forecasts: Estimating our sales and income over the next few years. - Expense tracking: Keeping tabs on our costs and expenditures. - Cash flow management: Ensuring we have enough liquidity to sustain our operations. I would like the plan to include visual representations of our finances. Specifically, I need: - Bar charts: To compare different revenue streams and expenses - Pie charts: To show the breakdown of our costs and profits Experience with creating financial plans and proficiency in Excel is crucial for this project. Please include your relevant expe...

...produced? • What are the average production costs and expected profit margins? • How long is the estimated payback period for the investment? ________________________________________ 5. Regulatory and Legal Considerations • Licensing and permits required for setting up and operating the lab/factory. • Compliance with environmental standards and trade laws. Key Questions: • What permits are needed to import and operate HPHT machinery in Saudi Arabia? • Are there any specific Saudi regulations on diamond production and exports? ________________________________________ 6. Location and Infrastructure • Analysis of potential sites in Saudi Arabia for the lab/factory. • Utility requirements for operating HPHT equipment (electricity, water, etc.)....

DONT ASK BEFORE READING THIS DOCUMENT ----PLEASE----- Creation and import of custom fields and shortcodes for WP events Manager plugin: Warning: please if you don't know the architecture of wp events manager don't accept this job. We will not be able to tell you how to solve your doubts with the plugin. This job requires an expert programmer, do not bid if you are not, it is better for you because you will not have a bad review of the work and for us because we will not waste time :) thanks! The job consists in creating custom fields and adapting the wp events plugin templates. 1- To perform this work we must copy the site to an offline staging enviroment of our own, as we have tried with another freelancer with little experience in the plugin our whole

I need help with understanding and analyzing my data. My data is in an Excel/CSV format. I am not sure what specific descriptive statistics I might need, but I would appreciate your expertise in guiding me through it.