Simple vba excel scriptspráce
...am seeking an advanced Excel expert to help with tasks such as data analysis, creation of complex formulas, and process automation. While the specific tasks are not defined yet, rest assured that the job involves deep knowledge of Excel and requires excellent analytical skills. Below are the ideal skills and experiences for the job: * Proficiency in Excel data manipulation and analysis * Knowledge and experience in generating complex formulas * Proven track of Excel-based process automation While applying, consider these: * Showcase of previous work involving advanced Excel projects * Detailed account of your Excel experience * Comprehensive proposal describing your approach to the project tasks at hand Lastly, the core purpose of this projec...
...experience in transferring data from Excel to Word. I have an excel file with 210 opponents of my football team, every opponent has it's own worksheet. In this file there is the name, city, maybe a remark about the name, the first season we played against them, the last season we played against them and the aggegare score (number of times played, won, drawn, lost, points, goals scored, goals conceded) both home and away. See the sample file as attached. The goal of this project is to have these 210 opponents in the Word file I attached. As you can see I have down the first two opponents already so you know what this project is about. Key Responsibilities: - Transfer data from one Excel file to Word meticulously Ideal Skills: - Excellent knowledge of Mic...
I'm looking for a freelancer who can create a simple, yet effective, VBA macro to combine a set of between 10 to 50 small CSV files. These files all share the same column headers, and the macro should merge the data in these CSVs while maintaining the column sequence as provided. This task is straightforward and should not take much time for an experienced freelancer. A successful completion of this task will certainly result in a 10-star rating from me. See the uploaded document that details what needs to be done. I will provide the coder that I choose with several sample small csv files to combine.
I'm in need of a skilled freelancer who can quickly extract data from scientific papers and input them into Excel spreadsheets. Key Responsibilities: - Extracting data from multiple scientific papers - Organizing the extracted data into Excel spreadsheets Key Requirements: - Experience with data extraction from scientific papers - Proficiency in working with Excel spreadsheets - Ability to work under tight deadlines The ideal candidate for this project would be someone who is detail-oriented, experienced with scientific data, and capable of working efficiently. The project is time-sensitive, with the need to have it completed as soon as possible.
I'm seeking a well-experienced Shopify developer to speed up my website's loading times. The current load time is between 2-5 seconds, specifically on the homepage. I believe the slow load times are caused by various scripts that run on my homepage. Your task will be: - Identify and optimize scripts causing slow load times - Ensure the homepage's load time is less than 2 seconds post optimization - Maintain or improve website functionality The ideal candidate must have a strong background in coding and an understanding of scripts, as well as a proven track record with improving Shopify website speeds. Prompt communication and a keen eye for detail will be greatly appreciated.
As an organization focused on understanding our customers better, we are in need of an Excel tool that is designed to handle customer data. Specific functions needed are: - Advanced calculation and formula functionality. You should be adept in creating and troubleshooting complex Excel formulas. - Data Visualization: Ideally, you should be skilled in creating efficient and easily interpretable Bar Graphs. This is how we'd prefer our data to be visualized. Key skills and experience: - High-level proficiency in Excel - Demonstration of designing efficient data visualizations in Excel - Ability to work with customer data effectively. A comprehensive understanding of Excel, including experience with customer data analysis, will position the chosen fr...
I have about 40 parcels of real estate that I need additional data retrieved on. (this parcel numbers are listed below) This is a web data retrieval project. Each parcel will be searched here: Produce an excel file that has one row for each of the parcels. You will retrieve the following data for each of the parcels: 0. County: (Will all be Galveston since search is Galveston CAD) 1. Parcel Number (This is the number you use to search) 2. Account: Property ID 3. Account: Type 4. Location: Situs Address 5. Location: Legal Description 5.5. Property Values: Homestead Cap Loss 6. Owner: Name 7. Owner: Mailing Address 8. Owner: % ownership. 9. Property Land: Acreage 10. Property Land: Sqft 11. Property Roll Value History 2024 Improvements 12. Property
I am looking for a talented designer to help me with illustrator. Design is already made, I need it in illustrator with details. Ideal Skills and Experience: - Previous experience in packaging design, particularly within the food industry. - A portfolio showcasing innovative design work. - Sound understanding of branding. - Ability to translate brand personality into the packaging design.
...in need of a real-time Excel sheet where 135 workers across 9 different squads can sign up for their work days by selecting their 3 top choices for the week to work overtime. Last column should be used to pick one day OUT OF THE MONTH where they would like to NOT be used for overtime. Key features include: - The ability for workers to select their workdays from a calendar interface. - The sheet should be able to automatically update in real time if they all can access the excel sheet. The information for each worker to be captured in the sign-up sheet should include: - Worker's name (We will input that information) 15 slots - Top 3 choices to work overtime for their respective week (calendar is provided to go by) Ideal skills and experience: - Proficiency in E...
I need an elegant, minimalist logo for my church, Simple Gospel Church. Key Requirements: - Colors: Sage Green, beige/sandy brown - Elements: Olive branch - Style: Minimalist Ideal Skills and Experience: - Proven experience in minimalist design, especially for brands with a spiritual or religious focus - Excellent grasp of color theory and the ability to create a harmonious palette with Sage Green and beige/sandy brown - Strong understanding of symbolism, particularly in relation to religious imagery - Excellent communication skills to ensure the design reflects the essence of our church, Simple Gospel Church.
I currently use ERP Bling and am looking for a freelancer who can help me create integrations for product registration. Main integration points: - The integration must include field...Main integration points: - The integration must include fields for ‘Name’, ‘Description’, ‘SKU’, ‘Price’, ‘Acquisition cost’, ‘measures’, ‘NCM’ and ‘categories’. - Data must be transferred effectively and accurately from Excel to ERP. Ideal Skills and Experience: - Proven experience in ERP systems, particularly with Bling. - Strong understanding of the product registration process. - Familiarity with e-commerce platforms, accounting software and CRM systems to ensure seamless integration. - Proficiency in ...
I recorded a rough Demo and would like to have a Bass line for it ? Are you a Bass Player?
I'm looking for a proficient Excel expert to help me set up and automate an inventory in Excel software. Key requirements: - I need to track between 100-500 different types of items. - The inventory should be able to update and transfer data to different worksheets automatically. - I'm also interested in adding automatic calculations, like the total value of the stock. Ideal Skills: - Proficiency in Excel and experience in setting up complex inventories. - Automation skills in Excel to ensure smooth and efficient data updates. - A good understanding of inventory management principles to ensure the system is effective and user-friendly. Please reach out if you have the right skills and are interested in tackling this project.
I'm in need of a freelancer with experience in using Crystal Reports - particularly with Excel, Google Sheets, and Web Services/APIs. Requirements: - Expertise in Crystal Reports: I require a freelancer who is somewhat familiar with Crystal Reports; this is non-negotiable as I need someone who can hit the ground running. - Data Sources: I need the reports to connect to both Spreadsheets (Excel, Google Sheets) and APIs/Web Services. - Report Quantity: The project includes less than 10 reports. Ideal Skills: - Proficiency with Crystal Reports. - Experience in connecting to Excel, Google Sheets, and Web Services.
We are in need of a virtual assistant to assist us with my daily job posting and messaging on LinkedIn. This role will support my recruitment efforts and improve the visibility of my job opportunities. Key Responsibilities: - Posting of new job advertisements on a daily basis - Managing and responding to job inquiries on Li...Managing and responding to job inquiries on LinkedIn by sending one time messages Qualifications: - Prior experience in administrative support and virtual assistance - Strong organizational skills and attention to detail - Ability to work well independently and meet daily deadlines This is a great opportunity for anyone who is starting as a freelancer and who is looking to get involved in the daily simple task process. We look forward to receiving your app...
I'm looking for a web developer to create a very simple hand-coded responsive web template for a sports event. One key requirement is that the site I will build using this template has to be as lightweight as possible. Therefore, no CMS template, no JS/CSS framework. I do not need you to deliver the actual website. It is perfectly fine for me if you provide demo content with lipsum text and random images. I will replace them with the actual content. For this reason, I want the code to be extra clean, so that it is easy for me to work on it and create web pages. There will be probably 4 to 6 different pages, but this is not relevant for the job I am submitting, because I only need a single template. The main content area has to include a top-of-page image, some text, links to...
I'm seeking an Excel Macro specialist to automate several repetitive tasks specific to engineering. The qualified individual needs to have: - Proven experience in creating efficient and complex macros - A solid grasp of engineering needs in relation to Excel functions - An ability to work with dense datasets and create tailored reports Tasks include, but are not limited to: - Automating repetitive engineering report creation - Streamlining data organization This project requires both expertise in Excel and understanding of engineering principles, hence any experience in the field can be a significant bonus. High efficiency and attention to details are of prime importance. Macro will need to be in word file and will change depending of the test - test A to J....
...our Street and Zipcode Database: We have a comprehensive database that should serve as the master template for the address checks. You'll need to integrate this into the API for accurate validation. - Handle incorrect addresses: It's crucial that the API is programmed to suggest corrections automatically when an incorrect address is identified. - Accept Excel and CSV files: The API should have the capacity to check addresses from both Excel and CSV files. We need an html frontend, to Upload files. The result shoud be added in the file The api should also react on soap requests and deliver the correct address back The request should be locked by costumer keys and the amount of requests per key should be logged in some table Ideal Skills: - Proficiency in API ...
I'm seeking native Spanish speakers to read out conversation scripts designed for AI service training. The primary focus will revolve around: - Technical Support - Business Meeting scenarios Your voice recordings will contribute to enhancing the quality and authenticity of our training material. Ideal candidates should have: - Proficiency in Spanish - Experience in customer service, especially in business meeting context - Previous experience in voice over or related audio recording tasks would be preferred, though not mandatory The ability to communicate emotions and tone, as described in the scripts, will be a critical skill for successful completion. We look forward to your proposals and samples of previous similar work.
...individually. b. Assume both CSI and forensics lab operations work 24/7. c. Model precisely ONE WEEK of sampling – any samples that are have not been completely processed by one week are not included in your analysis. d. The unit of time to use in the model is minutes. e. There is one Rapid DNA sequencer, which is only run once all eight spaces in the cartridge are filled with samples. f. You MUST use Excel to model the process. g. You MUST create, develop and save all your work in one file saved on your OneDrive account. There are no exceptions to this. See Saving and Sharing instructions on pages 10-12. 3. Results to find from your “average” model solution: a. To the nearest ten, how many samples will be processed by the end of the seven days? How many of thos...
I require a highly efficient individual ...efficient individual to complete a swift data entry project. Involving on-screen text extraction of phone numbers from a 10-minute video, the data needs to be meticulously transferred into Excel. It's a project needing completion as soon as possible, therefore excellent time-management skills are essential. SKILLS: - Data Entry - Proficiency in Excel - Video Data Extraction - Strong attention to detail - Proven time management capabilities EXPERIENCE: Prior experience in a similar role is greatly advantageous, although not a deal-breaker. Deadline adherence, a meticulous approach, and proficiency in Excel and video data extraction are crucial for this role. I look forward to hearing from you and working together on...
I'm in need of a custom Excel workbook that can handle RFQ (Request for Quotation) analysis and purchasing. The ideal candidate will be able to create this tool for me from scratch. Key Features: - Data Import/Export Functionality: The workbook should accommodate easy import and export of data from Excel spreadsheets. - Automated Data Analysis: The tool should be designed to perform automated analysis of data imported. This will involve calculation of vendor prices, comparison and evaluation. - Generation of Reports: The tool should be able to automatically generate reports or dashboards based on the imported data. Ideal Skills: - Proficient in Excel: Advanced knowledge of Excel functionalities and VBA is a must. - Experience in RFQ Analysis: A b...
Please only apply if you have experience in Power Pages development using WebAPI. I'm seeking a skilled developer to work with me to enable and build a simple example JavaScript function to run Power Pages WebAPI FetxXML on a custom entity. This is a very simple job to - enable the WebAPI feature for my custom entity in Power Pages - build a tiny Javascript function with a basic fetchXML call to dataverse using the WebAPI - host the app in a Power Pages website and show it working This is a very small, but urgent job. You will need to have experience doing this and know how to do it right away as I need it done immediately.
K zobrazení podrobností se zaregistrujte nebo přihlaste.
Need a excell sheet with a site with the total of all "contractor" that are set to the single projects. All contractors have thei own page, that u can upload a invoice who is saved on the web/sky. The single invoice that is uploaded is set by date, amount, billing nr, and are taget and subtaget with the right tag, that are selected from dropdowns. U can also leave a comment. Hi, Im interested. How long is it for you to finish this? I also wonder, how is your thoughts about the storing of the invoices/files that are uploaded. This should be on the web/sky. Also need a "scan" function, so we can compare a invoice towards a "offer from a supplier", so we can see if the price is corrext. So it needs to be possible to upload an offer/pdf that you get from a sup...
I am looking for someone experienced in integrating Telegram messages to Excel file. Consequently, I'd like you to help me complete the following tasks: - Extract specific details from the Telegram messages such as text content, the date and time the message was sent, and the sender's name - Integrate these details into an Excel files, putting the information in the correct cells - This work particularly involves dealing with text messages from Telegram Experience with Telegram API and advanced Excel capabilities will be beneficial for this task.
I am in need of an expert data professional to handle distinct tasks pertaining to Excel spreadsheets. Here is a rundown of what you'll be required to do: - Upload numerous Excel files - Expertise in Excel VBA, Macros and VB Capabilities - Analyze data professionally, using descriptive statistics The ideal candidate for the project would be well-versed in using Excel to analyze data and create descriptive statistics. Familiarity with data cleaning and visualization techniques would be a bonus. I look forward to your submissions.
I'm in need of a skilled professional for a simple yet precise data entry task. The job involves working with Word documents, with less than 500 entries in volume. Key Skills and Experience Required: - Proficient in Microsoft Word and data management. - Keen eye for detail, to ensure accuracy. - Ability to deliver on time. The freelancer should be able to demonstrate an understanding of handling and organizing data accurately, respecting deadlines. Prior experience in similar projects would be a plus.
Partnumber Generating Hello, we have Parts which we produce self with different options: Categorie - Modell - Length in cm - Warning Moduls - Design - option 1 - option 2 - option 3 - option 4 - option 5 ........... option 15 We work with ERP System, but it is diffcult, can you help us ? What is a solution for produce in excel or what is a solution for this problem to produce easy differenz part numbers but with structure ?
I am in urgent need of an expert Excel Macro developer who can generate a multidimensional tool for a restaurant setting. Key Responsibilities: - Design, build, and test a multifunctional Excel Macro that's compatible with Windows. - The macro should be able to generate sales reports, calculate inventory, and analyze customer data. Ideal Candidate: A successful candidate should have exceptional Excel Macro development skills, with an advanced understanding of restaurant operations. The candidate should be able to handle complex functionalities in Excel. This project is not suitable for beginners or intermediates; instead, an expert developer with proven experience in creating Excel Macros is required. Please provide evidence of similar past wo...
K zobrazení podrobností se zaregistrujte nebo přihlaste.
I'm looking for a skilled desktop application developer to create a Windows-based remote application. ...remote application. Key Features: - The primary function of the application will be to act as a remote app. This means it should provide a seamless user experience for remotely accessing certain functions or information. - The application should be designed for use on Windows operating systems. Ideal Skills: - Proficiency in Windows desktop application development. - Experienced in Rustdesk scripts - Prior experience with remote applications is a plus. - Strong understanding of user experience and interface design. - Ability to work independently and deliver a polished, bug-free final product. Please get in touch if you have the necessary skills and experience to take o...
...individually. b. Assume both CSI and forensics lab operations work 24/7. c. Model precisely ONE WEEK of sampling – any samples that are have not been completely processed by one week are not included in your analysis. d. The unit of time to use in the model is minutes. e. There is one Rapid DNA sequencer, which is only run once all eight spaces in the cartridge are filled with samples. f. You MUST use Excel to model the process. g. You MUST create, develop and save all your work in one file saved on your OneDrive account. There are no exceptions to this. See Saving and Sharing instructions. 3. Results to find from your “average” model solution: a. To the nearest ten, how many samples will be processed by the end of the seven days? How many of those samples will...
I'm looking for an expert in analytics to create a compelling dashboard that pulls data from Excel spreadsheets. You would be focussing primarily on reflecting operational stats in a clear and concise way. Key duties: • Integration of Excel spreadsheet data into the dashboard • Showcasing operational metrics, specifically focusing on account monitoring status on a daily basis like inspection due date Perfect for someone who: • Has experience with data integration from Excel spreadsheets • Understands operational metrics and how to present them effectively • Can deliver a user-friendly dashboard for easy understanding of data • Has a keen eye for details and accuracy.
I'm looking for a detail-oriented Excel expert to help with data entry. Your main task will be to enter text and dates into an Excel spreadsheet. Key Requirements: - You'll be working on a single column in the spreadsheet. - There are 1500 entries in total. - Prior experience in Excel data entry is highly preferred. - Attention to detail and accuracy is a must. The data needs to be entered following a specific format or template. I'll provide you with this guidance. If you're a skilled Excel user who can work efficiently and accurately, I'd like to hear from you.
THIS IS NOT YOUR USUAL 9 to 5 GRINDING TELEMARKETING GIG! This is Exciting, New, Diff...script, I will provide a specific one for you to use. This script will be a guide for the conversation and ensure consistency in the messages delivered to potential leads. Key Skills and Experience: - Proven experience in telemarketing, specifically with individual consumers - Strong appointment setting skills - Excellent communication and interpersonal abilities - Proficiency in using provided scripts to guide conversations - Prior experience in a similar role is a plus Please provide examples of your previous telemarketing projects, particularly those related to individual consumers and appointment setting. Your success in this role will be measured by the number of appointments you're ...
I'm in need of an expert to assist with crucial tasks for my project. You will be involved in: - Setting up a Nodejs server: We are creating a microservice that requires the configuration of a Nodejs server. Your familiar...experience in nginx reverse proxy configuration is therefore necessary. - Writing a bash script: Here, you will use your bash scripting skills to help in automating some of the tasks which we find repetitive and time-consuming. Ideal Skills and Experience: - Extensive knowledge in Nodejs server setup. - Proficiency in configuring nginx as a reverse proxy. - Strong experience in writing bash scripts. A pro in these three areas is what we need to complete our project successfully. If you think you have what it takes and you're up for a challenge, we ...
I'm looking for a professional who can assist me with organizing financial data in an Excel sheet. This organized data will be used for reporting purposes. Key Responsibilities: - Inputting and arranging financial data - Ensuring accuracy and consistency of data - Creating a well-structured Excel sheet for reporting Ideal Skills and Experience: - Proficiency in Excel and data entry - Attention to detail and accuracy - Understanding of financial data - Experience with creating reports from data The successful freelancer will need to have a keen eye for detail, as the accuracy and correctness of the data is crucial for its utilization in our reporting.
I’m needing an Android application developed that integrates Firebase. This app is purposed for simple exercise, so a knack for creating intuitive, user-friendly applications will be a definite plus. I will provide a detailed list of requirements that include aspects such as user authentication, push notifications, and real time database integration. As it stands, no specific exercises have been selected for inclusion, so flexibility in that area will be vital. Experience in developing Android apps will be ideal. $50 for this project
I need assistance with compiling a comprehensive database based on various online directories. Key Requirements: - You will be collecting data on the names and contact information of individuals. - Each entry should include the person's name, phone number, and email address. Skills & Experience: - Proficiency in Excel and data entry is crucial for this task. - Experience with online research and data gathering from various sources is a plus. I'm looking for a reliable and detail-oriented freelancer who can help ensure the accuracy and completeness of this database.
I'm in need of someone with access to the Australian Bureau of Statistics who can assist me in gathering specific data related to aged care planning within Melbourne. Key Deliverables in Excel: - Total population of each SA3 in Eastern and Southern Melbourne - High Income per week ($2,000 and $3,000+) of each SA3 - Age distribution within the following groups: 50+, 60+, 70+, 80+, 85+ Ideal Candidate: - Previous experience working with Australian Bureau of Statistics - Proficient in data collection and analysis - Excellent research skills - Strong communication and reporting abilities - Able to complete the project promptly, within a month - Access to ABS table builders This project is crucial for understanding the aged care market in Melbourne and will serve as a foundation ...
I'm in need of a proficient content writer who can craft a compelling and informative script for a radio broadcast. The main goal of this task is to inform the general public about a specific topic. Key Requirements: - Demonstrable Experience: In your application, please share samples of your past radio scripts or similar work that showcases your ability to inform and engage an audience. Ideal Candidate: - Strong Research Skills: The successful freelancer will be able to conduct thorough research on the topic and present the information in an engaging manner. - Effective Communication: The ability to distill complex information into easily understandable content is crucial for this project. - Creative Writing: Crafting a compelling script that holds the audience's atte...
I am in need of someone who can collect data on NFL Quarterbacks listed in the excel sheet I have attached. Many quarterbacks will appear multiple times because I am treating each season as its own entity. I need age (changes by season), weight (changes by season), height (stays same), wonderlic scores (stays same because its only taken one time). In summary, I need data for the quarterbacks listed in four areas: age, weight, height, and wonderlic scores.
I have an Excel file where the preventive and corrective maintenance services of some equipment are registered. It is divided by team in Excel sheets, in the example there are 2 teams BU-001 and BU-002. By pressing the finish button at the top of the sheet, the macro must copy the existing data from the selected sheet to the BDD sheet table, and also delete the elements found in the BDD sheet table. sheet in progress (BU-001 in the example), in addition to setting the "MAN HOURS IN CURRENT MAINTENANCE" and "DAYS OUT OF SERVICE" fields to 0's. It is necessary that the macro works on the selected sheet, since the sheet will be duplicated to have one sheet per team, and when the sheet is duplicated, the macro does not lose functionality or copy the dat...
I need an Excel macro to move records between two sheets in the same workbook. Here's the challenging part: records should be relocated based upon logical condition within a certain range of values in designated columns. Time isn't a constraint but proficiency in scripting Excel macros and strong grasp of logical functions is mandatory. Clean and efficient code is valuable. Understanding of data management in Excel is also desirable. Patience needed to iterate and perfect the code. Please apply if you meet these criteria.
...specifically Word & Excel, who can assist me in managing specific tasks. In Microsoft Word, the following tasks are needed: - Formatting Documents: Your skills should be top-notch in bringing out an excellent document format that is pleasing to the eyes and understandable. - Creating Templates: I need help in creating various templates for different types of documents. In Microsoft Excel, your tasks would include: - Data Analysis: I require someone with exceptional skills in analyzing data, to extract useful information that will guide my decisions. - Creating Formulas: You should be fluent in the use of various Excel formulas to facilitate swift and accurate calculations. The ideal candidate must have substantial experience in handling such tasks in Microso...
I'm looking for a skilled Excel professional to help create a spreadsheet that will serve as a route tracker for my delivery business. Key Requirements: - The primary purpose of the spreadsheet is to track the various routes that my delivery personnel drive. - I need the spreadsheet to detail the start and end points of each route, the distance traveled, and the time taken for each route. Skills and Experience: - Proficiency in Excel, particularly in creating complex but user-friendly spreadsheets. - Familiarity with data tracking and analysis, particularly in the context of logistics or similar fields, would be a significant advantage. - The ability to accurately incorporate the different data types and calculations required for route tracking.
Cuento con un archivo de Excel donde se dan de alta los servicios de mantenimiento preventivo y correctivo de algunos equipos. Se tiene dividido por equipo en hojas de Excel, en el ejemplo existen 2 equipos BU-001 Y BU-002. Al presionar el botón finalizar que se encuentra en la parte alta de la hoja, la macro debe copiar los datos existentes de la hoja que se encuentre seleccionada a la tabla de la hoja BDD, además eliminar los elementos que se encuentran en la tabla de la hoja en curso (BU-001 en el ejemplo), además de poner en 0´s los campos "HORAS HOMBRE EN MANTENIMIENTO ACTUAL" y "DIAS FUERA DE SERVICIO". Es necesario que la macro funcione en la hoja seleccionada, ya que la hoja se duplicara para tener una hoja por equipo...
i need 2 menus extracted from a webpage the most important columns (data points) will be category name product name, product price, product description. example: STARTERS - ONION BHAJI - 4.50 - Our own onion fritters with salad and sauce. Contains gluten. i have started the process for u to make life easier no time wasters if u do nice job i can give u more menus in the future
