Vba excel import template jobs

I need a proficient freelancer who can develop a Google Sheets template for tracking various aspects of our plumbing jobs. This should be a versatile tool that factors in a range of data for workflow and invoicing. The contractor will need to consider: - Status of Job - Materials used - Labor hours - Job date - Contractor - Other job expenses - Invoicing issued (progress draws) - Estimate price - Estimated start date - Estimated completion date - Estimated hours on job - Change work order The expected categories for the job status should include: - Not started - In progress - Completed Billing Status: - Progress Draw - Invoiced The contractor will also need to incorporate a system for tracking job progress in terms of percentage completed, and status of invoicing. Therefore, a...

I have given Start time, Interval, End time in excel When i give start time(Ex:9:15), when that time reached E col data automatically copied in into G col, Next Interval is 10 Mins, When 9:25 reached E col data automatically copied in into H col, When 9:35 reached E col data automatically copied in into I col,When 9:45 reached E col data automatically copied in into J col, When 9:55 reached E col data automatically copied in into K col, When 10:05 reached E col data automatically copied in into L col, When 10:15 reached E col data automatically copied in into M col.(H col vale > G col, that cell is green, H col vale < G col, that cell is red, same process for all col) 9:15-9:25 is 1 10Mins during that time, how many time(count) E col value>G col value( Ascending not dece...

Please Sign Up or Login to see details.

I'm in need of a professional who can accurately convert scanned PDFs into Excel. 3 different sheet for each supplier. The PDFs are inventory sheets that need to be organized by item number. These sheets will be used for inventory management, so it's crucial that the data is correctly transposed. Key Requirements: - Convert scanned PDFs to Excel - Organize data by item number - Implement conditional formatting to ensure data accuracy Ideal Skills: - Proficiency in data entry and conversion from PDF - Advanced Excel skills, especially in organization and conditional formatting - Experience with inventory management or similar data handling is a plus I look forward to receiving bids from professionals who can guarantee quick and accurate work.

I'm looking buying existing template for my badminton club's website, need help install it and virus free. The template should include features such as, - Membership Registration: A simple and user-friendly registration process for new members. - Photo Gallery: A section where we can showcase images of our club's activities and events. - Testimony: An area to display testimonials from our current members, to attract potential new ones. - Social Media Integration: Buttons or feeds linking to our social media platforms. - Optional - Court Booking: If possible, the template should allow for court booking. I already have the domain name and web hosting sorted, so the focus is purely on the design and functionality of the website. The primary goal of this ...

In need of a skilled Microsoft Access VBA expert to establish various functionalities on an ongoing project. This will include, but not be limited to, creating data entry forms, generating reports, and maintaining the database. Ideal Skills: • Experience in MS Access and VBA is mandatory • Familiarity with creating user-friendly interfaces • Proficiency in designing and maintaining database structures • Expertise in automation of repetitive tasks and processes • Knowledge in data analysis using Access If you have any relevant past work or specific experience in the areas mentioned, feel free to include them in your application. In-depth project proposals are also welcome and will be beneficial in the selection process. The main purpose of the pro...

...API. The ideal candidate will have experience in API integration and database management. Key Project Requirements: - Implement a bulk upload feature for FNSku to ASIN conversion - Utilize Amazon API to extract the ASIN number from the given FNSku - Develop an API database to store and retrieve the ASIN number and the FNSku Additional Functionalities: - Ensure the system allows bulk upload of Excel files - Incorporate the ability for users to download the conversion results - It's essential that results can be downloaded in a specific format, and in this case, directly to an API database. Ideal Skills and Experience: - Prior experience with Amazon API integration and product data extraction - Proficiency in bulk data processing and manipulation - Strong understanding of d...

...updates and Special Offers to my gaming community on MafiaLords.com. A breakdown of the requirements, taking into account the preferences I have provided: - Template Design: a modern aesthetic, designed with readability and user engagement in mind. - Email Client: The email template should be compatible and visually appealing on Outlook. - Template Structure: It should feature areas/dividers for presenting News Updates and Special Offers, along with intuitive buttons for enhanced interactivity during email campaigns. Ideal candidates should have excellent graphic design skills and a portfolio demonstrating proficiency in email template design, especially on Outlook. Experience within the gaming industry would be a plus. Turn your creativity loose and he...

I nee da graphic designer to help with the creation and implementation of sales proposal templates on Panda Docs. There are 9 proposals that need updating, but the same style can be applied across all. Due Monday by close of business Key Points: - Tailoring the existing templates on Panda Docs to meet our brand guidelines, focusing on the color scheme, logo usage, and font styles. - Embed video into panda docs and make it interactive and engaging - Ensuring the finished proposal design is in line with our brand identity and ethos. - The project is time-sensitive and requires a quick turnaround, so efficiency and experience in this field would be highly valued. Ideal Skills and Experience: - Proficiency with graphic design tools and Panda Docs - Strong understanding of branding and gra...

I have a research paper in Word format which needs to be formatted promptly in the template's layout, requirement, and format. The original paper follows no particular citation style; instead, the formatting should be adjusted to match the template's requirements. The template and its requirements will be provided Key Requirements: - Transforming the content of an existing Word document into a template-required format. - Ensuring a consistent, professional appearance throughout the document. The ideal freelancer for this project should have: - Proficiency in MS Word and formatting tools. - Familiarity with different citation styles and their application. The project has a tight deadline, so quick and efficient work is essential. Please only apply if you can mee...

...containing text data. Post scanning, these QR codes should display the text information incorporated while creating the codes. Furthermore, the software needs to house an Excel Workbook, which should be updated through manual uploads. The Workbook will be responsible for printing the necessary details derived from the CSV file. In addition, the software should also be engineered to retrieve cellular data upon scanning the QR code. Ideal Skills: - Proficiency in developing web-based software - Extensive knowledge in handling CSV files - Expertise in QR code generation and functionality - Experience in managing Excel Workbooks - Able to incorporate manual uploads - Experience with cellular data retrieval from QR scans. This entails a complex task, requiring ...

I'm looking for a tool that can automate the process of listing Amazon products onto my eBay account. Me and other sellers, got a HUGE issue with posting the items manual and I WOULD like to be able to have something to make my job easier. Key Features: - Automatically import products from Amazon to eBay Ideal Skills: - Proficiency in Amazon and eBay APIs - Previous experience in developing automated listing tools - Strong understanding of inventory management systems Budget is £100, please don't bid if you can't do it for this price. The app reference for this job is: I want literally a tool with this options.

I'm in need of a versatile data scientist who can expertly navigate both Python and R. For this assignment, you should be proficient in various data analysis techniques including: - Predictive modeling - Data visualization - Statistical analysis The dataset I'll provide comes in Excel format. Your task will be to demonstrate these techniques in Python and R as accurately as possible. Please submit a bid if you're confident in your ability to efficiently illustrate professional-level data analysis in both languages. For now, I only need Part 1 and Part 3 to be done. Part 1 has multiple subparts and should be done in R language. While Part 3 should be done in Python

I want to have a webshop from germany proxied in a way that I have all the same options and articles but to use my own logo and name and be able to receive payments and create order emails on my own domain name. the idea is to use them but not as dropshipping (they build custom PCs) but I will then import their builds to my country ( I live lcose to the border), and sell them to the person which ordered myself.

I need a word document translated from English to Japanese as soon as possible. The file has 800 words. Need high quality human translation only. Google/AI or automatic software works are not allowed and will be rejected. Need the translation back in word document format maintaining the formatting and layout of the source file. I would also need an excel sheet prepared, with source texts in column A and translation column B. Need this to be done within 5-6 hours of awarding the project. Bid only if you are available to do it now. Price: 12 CAD fixed. Deadline: 5-6 hours max Don't bid if you don't agree the price and timeframe. Thanks!

I need a word document translated from English to Turkish as soon as possible. The file has 800 words. Need high quality human translation only. Google/AI or automatic software works are not allowed and will be rejected. Need the translation back in word document format maintaining the formatting and layout of the source file. I would also need an excel sheet prepared, with source texts in column A and translation column B. Need this to be done within 5-6 hours of awarding the project. Bid only if you are available to do it now. Price: 12 CAD fixed. Deadline: 5-6 hours max Don't bid if you don't agree the price and timeframe. Thanks!

I need a word document translated from English to Spanish as soon as possible. The file has 800 words. Need high quality human translation only. Google/AI or automatic software works are not allowed and will be rejected. Need the translation back in word document format maintaining the formatting and layout of the source file. I would also need an excel sheet prepared, with source texts in column A and translation column B. Need this to be done within 5-6 hours of awarding the project. Bid only if you are available to do it now. Price: 12 CAD fixed. Deadline: 5-6 hours max Don't bid if you don't agree the price and timeframe. Thanks!

I'm looking for an experienced graphic designer to create a professional estimate cover page template on Microsoft Word. This template exclusively has to be in the Letter format (8.5in x 11in). The created template must be easy-to-edit and should contain the following elements: • My company logo • Space for contact details • Space to include a project title • A designated location to place a project photo Ideally, the design should incorporate my company logo and colors to maintain brand consistency. Proficiency in Microsoft Word and graphic design are critical for this role. An understanding of design aesthetics would also be beneficial. The completed project should deliver a finished template file that is ready for use. Your creativi...

I'm in need of assistance for importing physical products to my WooCommerce store. The main requirements of the project are as follows: - **Product Import:** I have a feed of physical products that need to be imported into my WooCommerce store. - **Filtering:** These products should be filtered based on their category before being imported. - **Product Updates:** Once imported, the system should update product prices and stock regularly, and add any new products to the store. This process should be automated and occur every hour. I'm looking for a freelancer with the following skills: - Strong experience with WooCommerce, including product importing and updating - Proficiency in creating smart filters for product selection - Automation expertise to ensure product upda...

...develop a digital scorecard in Microsoft Excel. The ideal candidate will have experience in Excel data management, visualization, and automation functionalities. Key Requirements: - Microsoft Excel proficiency: The digital scorecard will be based on Microsoft Excel, and as such, the freelancer must be highly skilled in this software. - Data entry fields: The scorecard should have user-friendly data entry fields, allowing for the easy input of information. - Interactive charts and graphs: The scorecard should include interactive charts and graphs that visually represent the data. - Automated calculations and summaries: The scorecard should automate calculations and summaries based on the data entered. Skills/Experience: - Proficiency in Microsoft Excel...

I am in need of a skilled data entry freelancer to assist in inputting textual data from digital files into an Excel spreadsheet. Key Responsibilities: - Accurately inputting textual data into an Excel spreadsheet. Ideal Skills and Experience: - Proficiency in data entry, particularly with textual data. - Familiarity with Excel and the ability to work efficiently with spreadsheets.

Good day. Trust you're well. I have a project that I need to download multiple PDF documents from website and compile them into 1 excel spreadsheet. Would you be willing to help with this?

I need a custom code for a WordPress page template that generates a Google map with markers for each page on the website having an Advanced Custom Field of 'location'. The key features of this project include: - **Customization of Markers**: The map should have clickable markers with custom icons. The markers should also be clustered to avoid clutter in case of overlapping locations. - **Filter Dropdown**: I need a filter dropdown that allows users to filter the markers based on WordPress page categories. However, this filter should allow users to select only one category at a time. - **Pop-up Information**: When a user clicks on a marker, a pop-up should display showing the page's small featured image, title, categories, and a link to the page. Ideal Skills and E...

I am looking for an Excel VBA script coder to assist me with a project for generating tags for e-commerce products from the description. Products are car spare parts. Need to tag the products with names of make, model, variant. Specific requirements: - - Generate tags for e-commerce products in a excel sheet. The product description is saved in Column A and the tags should be generated by referring to the list of available tags. Please see the excel sheet attached here. _ One product can have multiple tags associated with it from the tags list, The VBA script should run and generate tags while referring to the data in other sheets for tag names. Please see the excel sheet attached. Ideal skills and experience: - Proficiency in Excel VB...

...details, but I need a more comprehensive, automated solution. The tracker will need to detail: - Crop type (specializing in fruits and vegetables) - Quantity harvested - The date of harvest - The sale price of each item - Purchaser name - Remaining stock (calculated by subtracting the amount sold from current inventory) Ideal skills and experience for this project would include Google Sheets or Excel expertise, incorporating automated calculations, and the ability to create a user-friendly layout. Knowledge of or experience with farming or agriculture would be a bonus but is not a requirement. The key for me is accuracy and simplicity. A system that is too complicated or prone to errors won't save me any time. I look forward to working with someone who can help streamline ...

I'm looking for a skilled professional to create an engaging, easy-to-use family meeting agenda template. This document will primarily serve to organize discussions, set goals, and allocate tasks. Key Specifics: - The meetings will be held on a weekly basis, requiring the template to be durable and reusable. - Ideally, the structure of the template should be a blend of both flexible and fixed elements. It must contain sections with consistent topics for every meeting while also providing space for variable elements to accommodate specific issues as they arise. - Some things I want on the template include: at the top a space for the "week of____" and "family meeting date_____"; space to list upcoming dates; space to list proposed expe...

I'm looking for a professional who specializes in cleaning text data to help me with my project. Key Responsibilities: - Identify and remove duplicates within the text data - Correcting typos, spelling mistakes, and grammatical errors - Standardize the data in terms of formats and consistency I need someone who can handle this project within a month. Ideal Skills: - Proven experience in data cleaning, specifically with text data - Proficiency in text mining and natural language processing - Attention to detail and accuracy - Effective communication skills to keep me updated on the progress of the project. If you have these skills and are available to start working on the project as soon as possible, I'd love to hear from you.

I'm seeking a specialist able to extract all job posts and associated data from an old MySQL database, and import them into another WordPress template. I only possess the database from the old site. Here are the specifics: - Database transfer: I need all my job posts and their related data transferred intact. - WordPress version: The new template is installed on WordPress 5.3 or older. - Formatting: Job posts should be formatted using the new template's default settings. Ideal freelancer should: - Possess strong WordPress and MySQL knowledge. - Have experience in data migration between different WordPress templates. - Understand the formatting styles of WordPress templates to apply the default settings effectively. - Handle legacy system constraints due to...

Excel to PDF Entry Work need to be done

I am in the market for a professional freelancer who can create a Word to Outlook email template for my newsletter. This isn't a run-of-the-mill template; I'm looking for something that can replicate a multiple column layout as per a provided Word document. Skills and Experience Required: - Experience in creating email templates, particularly for Outlook - Familiarity with Word’s formatting and layout tools - Detail orientation and creative eye These are specific features of the newsletter: - The template should be fitted for news and updates. - It must accommodate a multi-column layout. If you have the expertise to deliver this project, showcasing a harmonised blend of functionality and aesthetic appeal, then I’d love to hear from you.

...include several logo concepts for your consideration and refinement. Branding Elements: We will create a cohesive brand identity by designing a color palette, typography, and visual elements that complement the logo. Menu Design: We will design a visually appealing and informative menu card that showcases your food and coffee offerings. Marketing Materials: We will create a banner and flyer template incorporating the logo, color scheme, and key messaging to promote Monty's Raw Bar across various platforms. Mockup Templates: We will provide mockup templates demonstrating how the logo and branding elements can be used across various marketing materials (e.g., social media graphics, signage). Design Approach Our design team will work closely with you to understand your vis...

1- Convert the excel data to Sage300 GLGE entries: Help in converting data from the excel details data to Sage300 excel format to import them directly inside Sage 300 ERP to create the needed GLGE entries automatically. 2- Support Sage300 Integration (AM Acquisition app): The application you developed previously needs an update. In the current process of creating Acquisition Entries based on shipments, all items are being transferred to the Fixed Asset module, irrespective of the data. The necessary update involves ensuring that only records with relevant data are migrated automatically when shipments are loaded in the application. Specifically, records without asset details (Sage optional fields) should be flagged as ignored. This flag should provide the u...

I need a proficient data entry operator to assist a task involving typing handwritten documents into Excel spreadsheets. The ideal candidate would have previous experience in data entry, and a high speed typing ability. Accuracy is key in this project, as they'll be transcribing valuable information, it's critical every detail is correct. Time management skills are also important, as there's a specific deadline to complete the task. If you've done similar jobs in the past, please mention it in your proposal. I look forward to working together.

I need help populating an Excel sheet with 378 company websites. - The task involves searching the internet for the website of each company and entering it into the Excel sheet. - If a company doesn't have a website, please mark it as 'No Website'. - All URLs should be inserted in a new column in the existing Excel file. I would prefer the URLs to be in the format '' or ''. Ideal Skills: - Proficiency in Excel and web research. - Attention to detail to accurately populate the data. - Strong communication to flag issues or ask questions during the process.

Any one experienced with octoparse or any other web scrapping tool can easily complete this straight forward web scrapping project. Please see this google drive link for instruction and check attached excel where sample scrapping is done for you.

I am seeking a skilled professional who can expertly integrate Xero with KOST Quotation Software. The ideal candidate has a deep understanding of both platforms and their capabilities. This role will require the successful candidate to develop: - A system to import customer data from KOST Quotation Software into Xero - A feature to sync invoices between the two platforms - A function to create quotations using the integrated system These functions should sync automatically without manual intervention from me. Previous experience with Xero and KOST Quotation Software, and an understanding of the requirements of automatic data syncing for large scale accounting and financial data, would be highly beneficial for this project.

I need a .PSD template that's optimized for image content, where every aspect of the layout can be modified. Key Requirements: - The template must be designed such that it's most suitable for images. Visual appeal and ease of use for images is a priority. - Every aspect of the layout should be fully customizable. This includes but is not limited to the placement of elements on the page, the size of different sections, and the overall structure of the design. - The template should be designed for a 1 page setup. - Although the focus is on images, other content types like text and videos should still be able to be added with ease. Ideal Skills and Experience: - Proficiency in Adobe Photoshop to create a high-quality .PSD file. - Experience in designing temp...

...analyst to organize and create detailed furniture packages for various property types and customer segments. The goal is to systematically structure these packages in Excel, covering multiple styles and accommodating property sizes from studio apartments to 4-bedroom homes. Each style will cater to different client types: holiday homes, new homeowners, expats, and investors. ### Objectives - **Create Defined Furniture Packages**: Develop comprehensive lists of items included in each package tailored to specific client types and property sizes. - **Organize Data Efficiently**: Present the data in a clear, accessible format in Excel that allows our team to understand and utilize the information effectively for sales and marketing strategies. ### Scope of Work 1. **Data Org...

I'm in search of a talented and hard-working freelancer to help me with an Excel task. The job at hand is complex and demands someone with strong analytical skills and attention to detail. The primary objective of this project is to achieve a high level of accuracy and efficiency in the output. Thise means that the quality of work is paramount. To succeed in this role, you must have a good understanding of Excel, be able to think logically, and work meticulously. Key Skills & Experience: - Proven track record in Excel data management - Strong analytical and problem-solving abilities - Attention to detail - Ability to work autonomously I look forward to receiving your application, and I will be in touch with the successful candidate soon.

...streamline the process of time-stamp duration reporting in Excel. The solution I'm seeking should ideally have the following components: I have a report (excel-sheet) exported from a system that I use in a weekly basis, however in this report, the date and time of processing exported in a form of “timestamp” and in order to calculate elapsed time of each stage in cycle, every time I have to do the followings: - Fix the format issue in excel since system always export data in a form of “timestamp” and there is no to fix that. - Exclude non-working hours for each stage/ elapsed time. - Exclude Weekends (Friday & Saturday). - Sum up the total of elapsed times Do you have a solution that I can use the as tool either by creating exc...

As a user of Xibo Signage Version 3.0, I am in need of a skilled designer to create templates that can display interactive content on various screen sizes. This is a project that requires a deep understanding of the Xibo Signage platform, design principles, and interactivity. We will need a guideline to create our own and update in future. the templetes will must have differnt compnent, such as text, videos, pictures, weather, clock, news, news feed, .... etc. Attractive designs, easy to unstrand guide. Thanks

I'm looking for a freelancer who can provide me with the links to Facebook pages of specific public figures/politicians, total of 1215 (IMPORTANT! I need only pages, NOT private profiles). The links should be delivered in google sheets which I will provide, along with the names. Key Requirements: - Co...Facebook pages of specific public figures/politicians, total of 1215 (IMPORTANT! I need only pages, NOT private profiles). The links should be delivered in google sheets which I will provide, along with the names. Key Requirements: - Compile a list of specified Facebook pages - Deliver the links in google seets Ideal Skills and Experience: - Proficiency in Internet Research - Experience with Excel or Google Sheets - Strong attention to detail - Ability to follow instruct...

Develop VBA code to meet your requirements

...graphical elements of a plane. Key Requirements: -2d space program -button to create plane in the center with 4 vertices -two textboxes as array in x and y to duplicate the plane in x and y -import button to import video in mp4 /gif and assign it to the plane as matrial /texture - ability to zoom out and in and move in the scene with select all ability as box can be generated by lift click of mouse and drag -button to combine all planes together with having 4 vertices ( as new plane with same matrial) -text box to write a value that will expand the 2d space accordingly infinitly without limit -import/Export button in obj -ability to duplicate the plane with ctrl+d and move it -optimezed performence( can run and duplicate large times in 192 ram, 48 cpu super comp...

I'm in need of a proficient Excel and Word expert who can assist me with various tasks. Unfortunately, I did not specify the exact tasks nor provide a deadline for this project. However, I'm excited to review your proposal and discuss your experience in more detail. Please include your past work in Excel and Word with your proposal. This could be anything from template creation to complex data analysis and automation. The more detail you can provide about your past work, the better. In terms of my needs, I'll be looking for a flexible freelancer who can help out with a range of tasks. Experience in data analysis, formula creation, and automation in Excel would be particularly desirable, as would proficiency in creating and formatting templates...

I am in need of an experienced and knowledgeable professional to assist in the development of a comprehensive training program for individuals aspiring to become advanced pentesters. Key responsibilities: - Create a structured, in-depth training curriculum focused on web applications, networks, and mobile applications pentesting. - Design ...particularly in the areas of web applications, networks, and mobile applications. - Prior experience in designing and delivering training programs, workshops, or courses. - Strong communication skills and the ability to explain complex technical concepts in a clear and concise manner. The goal of this project is to equip participants with the necessary skills, knowledge, and practical experience to excel as advanced pentesters in a professiona...

I am looking for a skilled web designer to give my company website a fresh new look. I'm not looking for a complete overhaul, rather a modern redesign that will enhance the overall aesthetics of the site and better reflect my brand. ...incorporate this into your design. - Attention to detail and an eye for modern aesthetics. - Best if designer is able to read chinese, as a part of the website is in chinese, and we have plans to design the website so that it offers both english and chinese - However, we have our own wordpress technician who is fluent in chinese who can assist with putting up the translation as long as the template is done If you can help breathe new life into my website while maintaining our core offerings and enhancing our brand image, I would love to...

...menu data, which exceeds 500 entries, in Excel. My project primarily involves handling text data. Here's what you would focus on: - Categorizing different types of food items. - Ensuring accuracy and consistency in data entry. While not a firm requirement, familiarity with culinary vocabulary could be beneficial. Additionally, someone proficient in MS Excel and particularly experienced in data categorization would be ideal. I appreciate your consideration and look forward to potentially working with you. Paid project: remote work  Seeking Assistance: Categorizing Online Menu Data in Excel Hey guys, I hope you're doing well! I'm reaching out because I could use your expertise for a project I'm working on involving categorizing online me...

I have a highly encrypted XLSM file that I urgently need help with. This specific project involves making VBA in the file visible. I need someone with advanced VBA skills and experience in cracking down highly encrypted XLSM files. Key requirements: - Expertise in VBA for Excel - Experience with highly encrypted XLSM files - Ability to make VBA visible in such files Please only apply if you have previous experience in this area and can start immediately. BID NOW!!! Serious freelancers only with the skills since it is ASAP!!

...as a platform for data visualization and export. Key Functionalities for Admin User: - **User Management:** The admin should have the capability to manage user accounts, including setting access permissions. - **Graph Creation:** The admin needs to be able to create visual representations of data. - **Data Viewing and Exporting:** The admin should be able to view all the data and export it to Excel for further analysis. Graphs Per Department: - **Data Points:** The graphs should focus on data from Sales, Expenses, Profit, and Number of Employees, using a rolling average approach for accuracy. - **Rolling Average Calculation:** The rolling average for the graphs should be calculated based on Manual Entered Data, per department. Additional Requirement: - **Formula Calculation...