Excel macro import data export datapráce

...comprehensive wedding website and app that will serve as a one-stop solution for all my wedding-related needs. Key Features: - RSVP Management: The app should be able to track and manage RSVPs from all invitees. - Wedding Countdown: A countdown feature to the wedding date. - Photo Gallery: A place to store and showcase the couple's photos and memories. - Guest Management: The app should have two excel sheets, one for the bride's guests and one for the groom's guests. - Dietary Preferences: A feature to collect and manage dietary preferences of guests. - Seating Charts: Ability to create and manage seating arrangements. - Communication: Integration with WhatsApp to create a community for confirmed guests. - Create an app for it so can log in via website or app. I...

I work for a security company. We needed a spreadsheet to track security units and track what they're doing. I have the code almost perfect, but it's buggy enough that it's hard to use. There's quite a bit of backend code and intermittent problems with it. I need someone who is great at project code to look at it, troubleshoot it and make it more user friendly.

...vending project. This one-time task involves analyzing various metrics, such as conversion rates, visitor traffic, and other relevant data to forecast the profitability and feasibility of the project. Responsibilities: - Create a financial model based on the specific requirements of the vending project - Analyze conversion rates, visitor traffic, and other key metrics to predict profit margins - Utilize advanced spreadsheet techniques to organize and present data effectively - Provide recommendations and insights based on the financial analysis Requirements: - Proven experience with financial modeling, preferably in the vending industry - Proficiency in Excel, Google Sheets, or other financial modeling software - Strong analytical and problem-solving skills - Abil...

...these programming languages, your main focus will be to develop an efficient, user-friendly UI for my machine learning application. Key Responsibilities: - Code the frontend of the application using React - Write backend code using Python - Liaise with me for regular updates and iterations Although not specifically detailed, the development may require real-time data visualization, user authentication, and the ability to export data in different formats. Ideal Skills: - Proven experience with React and Python - Previous experience crafting UI for Machine Learning applications The timeline for completion wasn't specified, allowing you to focus on quality rather than rush to meet a deadline. However, regular progress updates are expected. This project is a...

We're looking for multiple competent native English editors to help us improve English language usage in a big batch of Excel-related tutorials. Starting with a paid trial. Please bid $20.

I'm in need of a master in Excel. Your task will include: - Inputting both textual and numerical data into Excel. - The data to be entered is categorized, meaning that you'll need to pay close attention to how and where the data is entered. Ideal candidates have extensive experience with Excel and a sharp eye for detail. Familiarity with categorized data entry is a plus. Please apply if you think you've got these skills.

We're looking for multiple competent native English editors to help us improve English language usage in a big batch of Excel-related tutorials. Starting with a paid trial. Please bid $20.

I want to improve the search function of a webshop. I want to do this by adding extra data to the products (in the form of tags). I have a list of 11,000 product names in Dutch. These product names consist of a piece of proper name, noun and then sometimes some content information. For example: Orange Cleaner degreaser 5L c We are looking for a quick way to see the noun plural in the column next to it. Also, one or more synonyms in the column(s) next to it would be nice. Example: degreasers (=plural) I understand this can be done with a Python script that performs these tasks. This script uses the Natural Language Toolkit (NLTK) library to identify multiples and synonyms. This script assumes you have a list of product names and want to find the plurals and synonyms for each of t...

I am in need of an Excel expert who can assist me with data analysis. The level of complexity I am aiming for is basic sorting and filtering. Crucially, I would like the data analysis to be interactive for users. Key Requirements: - Data analysis in Excel - Proficiency in creating drop-down menus for sorting/filtering - Experience with basic Excel functions and formulas Ideal Skills: - Strong understanding of Excel and its data analysis functions - Ability to create intuitive and user-friendly interfaces with drop-down menus - Excellent communication skills to help with user instructions This project requires someone who can provide a clean, well-structured, and user-friendly Excel file.

Seeking sales enthusiasts ready to make money from the comfort of their homes selling physical products on a full e-commerce platform. Whether you are new to the field or have seasoned experience, join our team to help us broaden our company's online sales. While no experience is required, those with a background or interest in sales could excel in this role, as you will be responsible for maintaining a broad product knowledge of our inventory. Requirements and responsibilities: - Sell a variety of physical products online - Display strong communication skills - Maintain product knowledge - Be reliable and committed Being tech-savvy, having prior experience with eCommerce platforms, or proven sales experience are all a plus but not mandatory. Novices are also welcome to ap...

I'm looking for a skilled trainer to deliver a comprehensive Excel training targeted towards beginners. The training will cater to a larger group of participants, around 15-20 individuals. Key Learning Objectives: - Understanding of Excel formulas and functions - Mastery of data analysis and manipulation The ideal candidate for this project would have a strong command of the above topics, with a proven track record in delivering effective training to large groups. Experience in breaking down complex concepts for beginners is essential. Practical demonstrations and hands-on activities should be incorporated to ensure the understanding and application of the learnt skills. Please, when making a bid, provide a brief outline of how you plan to structure the cours...

I need a skilled python developer to create a JSON to Excel converter. Key Requirements: - You'll be working with Flat JSON data - How to handle missing data is up to you - Mapping of JSON fields to Excel columns is flexible Ideal Skills: - Proficient in Python - Experience with JSON parsing - Excel manipulation skills I'm open to suggestions on the best way to map the data, so please include your ideas in your bid. Let me know if you have any questions.

Hi, The task is to scrape a pdf that is downloaded on website. Steps: 1. Go to website 2. Enter code in search and click search. (We provide list code) 3. On the results page Click on pdf document and open or download it 4. Extract 14 pieces of data from the PDF and export into excel sheet. There are about 150.000. Some codes do not have any data then skip. I have attached a word document with pictures and flow for you to review. Thanks!

I am looking for an expert who can create MIS reports encompassing sales, financial, and inventory data. The frequency of these reports will be based on my requirements which can vary. Those equipped with excellent skills in data analysis, report generation, and detail orientation will be ideal for this role. Knowledge in handling Excel is a must as the reports need to be delivered in this format. Here's what is expected: - Data compilation and report generation as per my request - Proficiency in Excel for creating and delivering reports - Adherence to strict timelines for report submission - Maintain confidentiality of all the data involved If you have prior experience in creating MIS reports of these types, I would be very interested in ...

For this project, I require a meticulous freelancer with skills in data entry, and specifically in converting images with somewhat legible handwriting into Excel data. Key Responsibilities: - Accurate conversion of handwritten text from images into digital format in Excel. - Ensuring the integrity of the data by carrying out data validation and verification. Required Skills: - Proven experience in data entry, particularly involving handwritten text. - An eye for detail for data accuracy. - Proficiency with Excel is mandatory. - Ability to decipher and transcribe somewhat legible handwritten text. This project suits someone with patience and diligence due to the level of legibility of the handwritten text.

...Dashboard template to fit the unique branding and functional requirements. Database Integration: Configuring and linking an external Airtable database to import and regularly update a directory of funding opportunities. User Authentication and Profile Setup: Developing secure login/logout capabilities and user profile management. AI Chatbot Development: Integrating OpenAI’s ChatGPT API to create an interactive chatbot that conducts a business background quiz and uses responses to tailor funding recommendations. Opportunity Matching System: Implementing algorithms to match users with funding opportunities based on quiz results and profile data. Subscription and Payment Processing: Integrating Stripe for handling subscriptions and payments, including setting up di...

I am in need of a skilled professional who can assist me in setting up the Odoo Books system for my invo...invoicing processes. Requirements: - Configure the system to enable the creation of goods and service invoices in USD. - Implement moderate customization to the invoice templates, focusing on layout changes and adding custom fields. - Import all of my product information from an Excel sheet. This includes product names and their respective cost prices (which are in INR). Ideal Candidate: - Proficient in working with Odoo Books and setting up invoicing processes. - Experience with customizing invoice templates within Odoo. - Skilled in data import from Excel sheets to Odoo. I look forward to working with a professional who can deliver these req...

I'm seeking guidance and support to excel in the AI certification, emphasizing on concepts and theories. - The primary focus of this project is on improving my understanding of AI principles, concepts, and theories. - As I'm aiming to complete the certification, I need a mentor who can explain complex AI concepts in a clear, concise, and readily understandable manner. - Given the current circumstances, I'm specifically looking for online resources to guide me through this journey. Ideal candidate for this project should have: - Proven experience in Machine Learning, ideally with certifications themselves. - Excellent teaching and mentoring skills, particularly in breaking down complex topics. - Good understanding of online learning platforms and resources, with the...

I'm seeking a developer to help me setup a simple PSD editing via API or similar. The task involve...This could be accomplished using : []() or the Photoshop API. or any other library you suggest. ---- One guy started working on this for me, but from all of a sudden just disappeared and stopped answering completely, so all I have is this video he sent me of making such function, to edit the text via a form, and to export the image, check it out here: He made this in less than 1 hour. So this. task itself should be easy for someone knowing this. If you do a good job, this task is just the start, it's just a small part of a very big project that I will need help with in the upcoming near future. Check the video:

...skilled freelancer to create a custom quoting template in Microsoft Excel for my business. The template should be intuitive, easy to use, and visually appealing. Key Features: - The template must be fully customizable in design, enabling me to adapt it according to my branding and specific needs. - I'd like the template to incorporate conditional formatting for data visualization. This feature will help better present the data, making it easier to understand and interpret. Ideal Skills and Experience: - Proficiency in Microsoft Excel, particularly in creating templates. - Experience in designing visually appealing and user-friendly templates. - A strong understanding of how to implement conditional formatting for effective data visualization. ...

...customizable resume templates to cater to different job industries and levels of experience. - **Resume Customization Options:** Incorporate AI-driven suggestions for resume customization, helping users to tailor their resumes to specific job postings or industries. - **Import/Export Resume:** Enable users to easily import their existing resumes and export the newly created ones in various formats (e.g., PDF, Word). - **LinkedIn Integration:** Implement functionality allowing users to link their LinkedIn profiles for easy import of professional achievements, experiences, and network endorsements. - **Cover Letter Builder:** Develop an AI-based cover letter builder that guides users in creating compelling cover letters tailored to specific jobs. ...

Job Description: As a Software Auditor, you will be crucial in conducting thorough assessments of software usage within client organizations. You will analyze software licenses, usage patterns, and deployment data to ensure compliance with licensing agreements and identify potential areas of risk or non-compliance. Roles and Responsibilities: • Conduct software audits for client organizations to assess compliance with software licensing agreements. • Analyze software deployment data, license entitlements, and usage metrics. • Verify the accuracy of software license records and documentation. • Identify discrepancies, unauthorized software usage, or potential non-compliance issues. • Prepare detailed audit reports outlining findings and recommendati...

I am in need of a skilled professional who can assist me in setting up the Odoo Books system for my invo...invoicing processes. Requirements: - Configure the system to enable the creation of goods and service invoices in USD. - Implement moderate customization to the invoice templates, focusing on layout changes and adding custom fields. - Import all of my product information from an Excel sheet. This includes product names and their respective cost prices (which are in INR). Ideal Candidate: - Proficient in working with Odoo Books and setting up invoicing processes. - Experience with customizing invoice templates within Odoo. - Skilled in data import from Excel sheets to Odoo. I look forward to working with a professional who can deliver these req...

I am in need of a proficient excel wizard who can simplify my day to day tasks. While the specifics aren't in place, ideally I'm looking for someone who can efficiently perform data entry, come up with efficient formulas and functions, and provide comprehensive data analysis. Proper data formatting is key, for which I don't have a specific preference, however, creating simple tables, color coding cells, or using pivot tables and charts are all strong possibilities for this recurring project. Since no specific criteria was given, please do include your past work, experience, and a detailed project proposal when you apply. Skills and experience preferred: - Familiarity with advanced Excel functions and formulas. - Experience with data...

I need an expert data analyst to clean and integrate data from excel files into a Power BI dashboard. Key Project Details: - The primary data source is excel files. It's crucial that the freelancer is proficient in Excel for extracting, cleaning, and transforming the data. - Dataset is farmers data including demographics and crop details. - The main focus of this project is on data visualization. I need the dashboard to present the data in a clear, visually engaging way. - The dashboard will be updated quarterly. Ideally, the freelancer should set up a process for this to be done efficiently and accurately. The task involves: - Understanding the data and the requirements for visualization - Cleaning the ...

Bonjour, je suis archéologue. J'ai du texte, des photos, des images, un document Excel a insérer dans un seul rapport paginé. Il faut faire la mise en page et transformer en PDF.

Whilst the world patiently goes about its mundane existence, deep in the bowls of PyCharm there exists a codebase held hostage from migrating to the land of PostgreSQL where it belongs. Its captor - the evil Djangosaurus, has armed itself and is baying for binary bloodshed. Chat GPT has fl...Gummy-shark has driven a Porsche than Apollo 11 potentially didn't land on the moon. This is the real thing, this is what you've been trained for. There is no task sheet even envisioned for this unprecedented event. Your mission if you chose to accept it is to go where no supercomputer can - into the HQ of DjangoTown - and seek out the energy source powering the Djangosaurs with circular import energy cubes and shut it down so this codebase can get to its docker and sail away before...

I'm looking for an Excel expert to create a costing sheet for a product. Key details for the job include: - It's mainly a costing sheet that will help me calculate the final price of my product based on material costs. Ideal Skills and Experience: - Proficiency in Excel - Solid understanding of financial calculations - Previous experience in creating costing sheets for products Looking forward to receiving your bids.

We are seeking a skilled Blender Artist to adapt and rig a character for us! Your mission: - Import FBX base models we provide from our Maya sources - Combine and adapt existing models, and create new models needed to fit our provided design page. - Adapt provided textures (or create new ones) to match our design page. - Fully Rig the character and their outfit for easy animating, including Shape Keys. (Exisitng shape keys will be included in the original FBX files.) Ideal Skills: - Proficient in Blender - Experience in 3D character modeling & rigging - Able to work from sketches and existing models - Knowledge of generating character movements While this project is for a single character, we have more that will need work done in a similar manner. Good performance and qual...

I require a detailed, easy-to-use Excel invoice template. The main features needed include: - Line items for products or services delivered: It's crucial that you add functionality for categorizing and detailing all the products or services delivered within the invoice. - Contact Information of both parties: The invoice must have dedicated sections to clearly present contact information of both the issuing and receiving party. - 1 page invoice in A4 size (fixed) with calculations based on user input amount. It's beneficial if you have profound knowledge of Excel and understand accounting principles to design the template in a highly organized and straightforward manner for ease of accounting tasks. Prior experience with invoice template design will be a great ad...

I'm looking to engage a freelancer skilled in data entry and Microsoft Excel to help type significant amounts of text data into an Excel sheet. Your responsibility will include: - Typing text data into an Excel sheet in an accurate and efficient manner. - Maintaining a consistent style and format throughout the entirety of the data entry. - Reviewing and proofreading your work to ensure absolute accuracy. You should display proficiency in Excel, attention to detail, and commitment to maintaining a consistent, professional style across all data. Please submit your bids along with an estimate of timeframe. Though the project completion timeframe was not specified, a timely delivery will still be appreciated.

...need of a skilled Python expert to transform a raw excel report into a final template version of excel. The project requires two main tasks: Formatting and re-arranging of columns along with calculation updates for one column. Key Points; - Need 3 open reports to pull the information and split the reports at the end. - Formatting Changes: The report needs specific columns to have pre-defined blank values for certain columns: Col B, E, J, R, W, AB, AE, AJ, AV, BG, BI, BJ, BQ, BU, BV, BW, BX, BY, BZ. - Calculation Updates: The calculation layer within the excel report needs to be updated and finalized. The ideal freelancer for this project should have a profound understanding of Python and extensive experience in manipulating and formatting excel reports. I ...

Hello and Thank you for being here Please see below code to read USERS from Keycloak using the api task: - Need to get REALM data for each user - Need to get GROUP data for each user We can do a 2nd Milestone if you like and we can talk about that together ----------------------------------------------------------------------------------------------- WORKING CODE TO READ USERS cat from keycloak import KeycloakAdmin admin = KeycloakAdmin( server_url="serverURL:port", username='admin', password='password', realm_name="master") print("current realm",admin.get_current_realm()) users = admin.get_users({}) if len(users) > 0: print("-------------------------------------") ...

Hello and Thank you for being here Please see below code to read USERS from Keycloak using the api task: - Need to get REALM data for each user - Need to get GROUP data for each user We can do a 2nd Milestone if you like and we can talk about that together ----------------------------------------------------------------------------------------------- WORKING CODE TO READ USERS cat from keycloak import KeycloakAdmin admin = KeycloakAdmin( server_url="serverURL:port", username='admin', password='password', realm_name="master") print("current realm",admin.get_current_realm()) users = admin.get_users({}) if len(users) > 0: print("-------------------------------------") ...

I have marble quarries with good grades in Turkey. I export these marble blocks to all over the world. I am looking for experts to work together on a commission basis (win-win). You will sell my marbles based on tons and earn commission.

Everyday I have to extract some datas from around 100 invoices (PDF files) and copy it to an Excel file. I do it manually (copy/paste), but I need a tool to have it done automatically. These invoices have a consistent format structure, and the fields I need to copy to Excel are always the same. They are informations like: invoice number, date, customer's name, product code, price, etc. All the fields that need to be on Excel are highlighted in color red on the 2 files I'm providing as an example. Any other info not highlighted in red, doesn't need to be on Excel file. The automation process must execute without fail, ensuring that the location of highlighted fields - which are always the same in every file - does not affect the extraction. The o...

I am urgently seeking a proficient macro developer to create a small, efficient macro capable of identifying and removing rows based on specific phrases present in multiple columns. Key Project Requirements: - The developed macro must target multiple columns in the sheet. - Deleted row criteria: rows with specific text present. - Must complete as soon as possible. Ideal Freelancer Skills and Experience: - Experience in macro development, particularly macros for Excel or similar programs. - Strong attention to detail and a proven ability to interpret and implement specific criteria. - An ability to work quickly and efficiently to deliver the project as soon as possible. Feel free to ask any questions that will assist you in accurately pricing your b...

I'm looking for a professional Excel user with a strong grasp of nutrition concepts to develop an advanced tool for me. Here's what I need: - A comprehensive Calorie Calculator - Macronutrient Calculator to recommend the optimal amounts based on three different goals: Weight loss, Muscle gain, and Maintenance - BMI Calculator - Be able to calculate these based off body weight, height, activity level, age and gender inputs The ideal candidate should not only be proficient in Excel, but also have a good understanding of nutrition principles. The faster this can be completed, the better.

I need an Excel 365 PowerQuery script that can fetch daily market data and handle potential data source interruptions or changes. I will be providing a URL that contains the market data, and you'll need to replicate the Google Sheets function =INDEX(IMPORTXML("" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). This function provides real-time data from the specified URL. Please note that the data is structured using HTML tags. Key requirements: - The PowerQuery should be able to be refreshed with the google sheet. - It needs to include robust error handling. If the data source is unavailable or the structure changes, the PowerQuery should not break but continue to function, ideally pr...

I'm searching for a talented full-stack developer to establish an e-commerce site akin to Shopify but entirely focused on the upload and download of digital files. Key Functionalities: - Implement user registration and login feature. - Develop robust file upload and download functionality for various types of files: documents such as PDF, Word, and Excel; images including JPEG, PNG, GIF formats; and media files such as audio and video. - Integrate a highly secure and user-friendly payment gateway for transactions. Ideal Skills for this Project: - Proficient in full-stack development. - Experience in building e-commerce platforms, particularly with user account management and file sharing features. - Strong understanding of payment gateway integration. - Ability t...

Need to import views, floor plans and cross sectons from Archicad 24 file. For some reason cannot get it in the program. Als oneedot save settings in the PLA file for a future use

As your client, I'm looking for an Excel VBA expert who can make my daily processes more efficient by creating an automated reporting solution for me. Key Tasks: - Design and implementation of a VBA macro in Excel to automate the generation of cost summary reports. - The automated reports should be populated by data from four different worksheets, namely Worksheet 1, Worksheet 2, Worksheet 3, and Worksheet 4. Ideal Skills and Experience: - Excel VBA Programming - Experience with automated reporting - Understanding of data manipulation in Excel. -Possible migration of Cost Summary data to Word contract. In your proposal, please share samples of previous automated reporting projects done with Excel VBA. Commitment to d...

As a textile exporter, I'm seeking a proficient lead generator who will assist me to accelerate my sales in the United States, United Kingdom, and Germany. Key Tasks: - Identify and generate leads specifically interested in importing fabric and home textiles. - Comprehensive understanding of textile industry is a plus. - Proven experience in lead generation, with emphasis on foreign markets. Desired Skills and Experience: - Strong research and strategic analysis skills. - Proficient in creating and maintaining client relationships. - Experience in international business development particularly in the textile field. - Strong fluency in English, knowledge of German language is a plus. Ultimately, the goal of this project is to boost my sales, extending my reach in the internati...

I am looking for a freelancer with expertise in PowerBi and Excel. The task will revolve around creating a one-time report/dashboard on PowerBi sourced from a single Excel spreadsheet. The ideal candidate should have: - Previous experience with PowerBi and Excel - Proven track record of data analysis - Attention to detail Please note that the Excel file won't be changing over time, so there is no requirement for the PowerBi report/dashboard to be updated. Content Description: I have statistics from every UFC fight and want basic visualizations made (I have a rubric)

I'm seeking a skilled developer to take my existing demo code and bring it to the next level. The application is web-based and is intended to automate the extraction of data from Word and Excel documents, and then compare the data for consistency. Key Responsibilities: - **Improved Data Extraction Accuracy:** The code should be enhanced to improve the accuracy of the data extraction process. The developer should implement robust methods to ensure that all necessary data is correctly captured. - **Enhanced Comparison Algorithm:** The comparison algorithm should be optimized to better handle the extracted data. The developer should ensure that the comparison is done accurately and efficiently. - **User-Friendly Interface:** The current d...

I'm seeking an Excel expert to create a user-friendly data entry workbook. The job is straightforward and requires the following: - **Data Entry:** The workbook should mostly focus on simple data, like names and dates. I am not looking for any intricate calculations, formulas, or pivot tables. The main focus is on creating an Excel workbook that streamlines the process of entering simple data in a structured and efficient way. Experience in creating user-friendly UX within Excel is a plus. No integration with external systems or services is needed - this is a standalone project. I look forward to collaborating with an experienced professional who can deliver an effective, easy-to-use data entry solution within Excel...

I require AutoCAD shop drawings for the intention of construction planning for a commercial building. The freelancer should include comprehensive architectural details. A strong background in creating accurate AutoCAD drawings detailing architectural specifics for commercial projects ...accurate AutoCAD drawings detailing architectural specifics for commercial projects is a must. The desired candidate will need a strong understanding of construction processes, especially within the commercial realm, to ensure every detail contributes to a seamless build. Your craftsmanship will directly influence our build strategy, so we expect precise and detailed work. Please only apply if you excel in AutoCAD and have direct experience in the realm of architecture and construction of commercial ...

I'm looking for a seasoned Excel expert to create a set of macros that can automate my data extraction process. Here's what I need: - Automate data extraction: The primary purpose of these macros is to enable automated data extraction from local files. The data in question is stock market data. The ideal candidate for this project would have: - Proficiency in Excel: You should have a strong grasp of Excel, particularly in designing and implementing macros. - Experience in data extraction: You should have a track record of successfully automating data extraction processes. Looking forward to hearing from you.

I am looking for an expert in Excel to design a dynamic spreadsheet for project tracking. This spreadsheet will focus on monitoring task progress and deadlines. Key Features: - Daily updates: I will be updating task progress and deadlines daily, and so I need the spreadsheet to be user-friendly and efficient. - Task highlighting: If a task is falling behind schedule, I need it to automatically become highlighted in red. This will help me prioritize tasks and ensure no deadlines are missed. - This will need to show throughput for every phase and also provide an average through in volume. Skills and Experience: - Proficient in Excel - Experience in creating dynamic spreadsheets - Understanding of project management principles. I look forward to working with a detail-orien...

For this task, I am specifically seeking a freelancer who is proficient at data entry and familiar with Excel spreadsheets. The project primarily involves numeric data, so accuracy is vital. Key Responsibilities: - Input numeric data into an Excel spreadsheet. - Maintain a minimum 98% accuracy level. Ideal Skills and Experience: - Proficient in Excel. - High attention to detail. - Experienced in numeric data entry. - Proven track record of maintaining high levels of accuracy. Please ensure you have the necessary skills and experience before placing your bid. I look forward to your detailed proposals.