Excel vba path sheet nameроботи
Необхідно розробити макрос з перетворенням 1 файлу excel "для обробки" у кілька файлів-шаблонів теж у excel. Суть заповнення всіх полів у цих шаблонах з даних файлу excel "для обробки" згідно з алгоритмом описаним у технічному завданні.
Створити таблицю Excel та внести в неї данні з касових чеків. Розбити по періодам та групам.
Hi, I need php script for Convert large svg (drawing) file to pdf-file For printing on A4 pages and a Tile sheet of paper with repeated pages. php script must split my svg (drawing) to A4 pages and give me printable pdf file You can use my svg file here and will see the result I need the same. You have a remember about the scale, if you have a ruler you can look at squares, each square must be 10x10mm, in the example, you can find nine pages. For testing, I attached svg file and result in PDF file.
Потрібно написати модуль (скрипт) для оновлення цін в інтернет магазині. Періодично висилають нові прайси, з яких потрібно підтягувати нові ціни. Вибірку робити по артикулу товару. На сайті поле артикула містить також назву фірми (для прикладу Nowodvorski 65441), а у прайсі просто 65441. Прайси приходять у Excel. Інтернет магазин створений на базі CMS Drupal 7.
Ввод информации в базу, возможно Excel либо другой редактор, могу работать непосредственно с онлайн информацией
Вносити дані до таблиці Excel. Це э дуже непогана робота яку можна виконувати дуже швидко, а головне чітко і без помилок.
I'm looking for a freelancer who can meticulously extract a large mixed data (numerical and text) table from a statistical website and transfer it into Excel without missing any details. The ideal candidate should ensure that the data is formatted in Excel in the exact same way as it appears on the website. Skills and Experience: - Proficient in data extraction and Excel - Attention to detail to ensure no information is missed - Ability to format data in Excel as per the client's request
...understand the intricacies of data processing and can help ease the burden of manual tasks. The goal is to streamline our operations and enhance productivity. -- Basically, we have a data processing project which is going to be presented into our new website. We need a backend Python Developer whom can process data in our Google sheet then be dumped into SQL, eventually going to be presented into our new website. Therefore, the Python developer needs to be familiar with Google sheet API, Django framework API, and scrapping for our data processing. Data synchronization should occur in real-time. Our budget is $3/hour for maintaining the codes and website $5/fix rate for replicating or making a new code, but for a specific code if it's not that easy since you need t...
I need a skilled Python programmer who can help in extracting table data from PDFs and converting it into an Excel file. The tables in the PDFs have varying structures, so your ability to handle different table layouts is essential. Key requirements: - Extract tables from multiple PDFs - Convert the data into a well-structured Excel file with 4 different formats across 2 sheets - Ensure the data is accurately represented as mixed data (both numeric and text) Ideal Skills: - Proficiency in Python, with experience in data manipulation using Pandas DataFrame - Excellent attention to detail for accurate data extraction and conversion - Prior experience in handling PDFs and Excel files With your expertise, I hope to streamline my data processing task and make it more ef...
I'm seeking a seasoned Business Analyst with 3-6 years of experience, particularly in the retail sector. This remote, 3-month project entails developing and implementing brand marketing strategies to boost our brand visibility. Key Responsibilitie...case studies - Monitor and assess the impact of marketing initiatives - Analyze competitors' operations and identify their strengths and weaknesses. Desired Skills: - Strong analytical capabilities - Excellent marketing knowledge - Superb communication skills - A touch of sales experience. Ideal candidates will possess a BCA, MCA, B.E. or a relevant degree. Experience with tools like Microsoft Excel, Google Analytics, and Salesforce is a plus. Though not mandatory, a primary objective of enhancing brand recognition would be ...
I need assistance in entering mixed data, which is currently stored in digital files, into MS Word. Requirements: - Proficient in MS Word and data entry - Able to work with mixed data (text and numeric) - Experience handling digital files, particularly text files The data is sourced from various digital files including Excel, PDF and text files. Your role would primarily involve transcribing this into MS Word, so attention to detail and accuracy is crucial.
I need a freelancer to help with data scraping and organizing the information into an Excel file. The data source will be various databases. - Scope of Work: - Scraping email addresses and names/contact information from databases. - Organizing the data into an Excel file with separate columns for each data type. Ideal Skills: - Proficient in data scraping techniques. - Excel expertise, specifically in organizing and formatting data into separate columns. - Attention to detail to ensure data accuracy. - Previous experience with data scraping from databases is a plus.
I need a multi-purpose chassis designed for a heavy-duty construction vehicle primarily intended for excavation in mountainous terrains. The vehicle will face challenging conditions, so the chassis must excel in durability and flexibility. Key Requirements: - Design a chassis that can withstand tough, mountainous terrains while being able to adapt to different conditions and tasks. - The design should not prioritize being lightweight, but rather focus on durability and flexibility. - Previous experience in designing vehicle chassis, particularly for construction or heavy-duty vehicles, is highly desirable. Ideal Skills: - Mechanical Engineering - CAD Design - Experience with heavy-duty vehicle design - Knowledge of materials for durability - Creativity for flexible design
Будь ласка, зареєструйтесь або увійдіть в систему для перегляду деталей.
Project Title: Data Entry and Administrative Support Needed Project Description: Update a large database with accuracy and efficiency. Use Google Sheets and Excel for data entry and management. Ensure all data entries are accurate and error-free. Submit daily progress reports. Required Skills: Proven experience in data entry. Proficiency in Google Sheets and Microsoft Excel. Ability to complete tasks within deadlines and maintain accuracy. --- If your project is related to Sales & Marketing or Translation & Languages, you can modify it accordingly. Example: Project Title: Content Writing for Marketing Campaigns Project Description: Create engaging and customer-attractive content for a new product launch. Write short yet impactful copy for social med...
...Management Display detailed project information: Name, description, start and end dates, assigned team, status. Edit project details inline. Milestones tracking and deadline management. 3. Task Management Create, assign, and update tasks. Task views: List View Kanban Board Gantt Chart Task filters (by status, priority, due date). Subtasks and recurring tasks support. 4. Risk and Budget Management Risk matrix (impact vs. probability). Mitigation plans and conditional formatting for high-risk items. Budget tracking: Total budget, expenses, and remaining funds. Visualizations for expenses and trends (charts). 5. Reporting and Analytics Real-time charts for: Task completion rates. Project delays. Resource utilization. Export options for reports (PDF, Excel, Word). Embedded ...
I need assistance with data entry. The data is mixed (text and numbers) and is currently in Excel/CSV format. The primary purpose of this data entry task is to populate a database. Ideal candidate should be proficient with: - Excel/CSV - Data entry - Attention to detail Experience with database management and data handling is a plus.
I’m looking to automate sending birthday promotion messages to a list of contacts via WhatsApp. Here’s what I need: What I Have: • An Excel sheet with nearly 2,000 contacts. o Each entry has: Name Contact number (with country code) Birthday date • I’ve also got 2 promotional images and a message I’d like to send. What I Need: 1. Send WhatsApp Messages (direct from excel) two images I provide. 2. Reusable for Future Months o For upcoming months, I want to just update the Excel sheet with new names, numbers, and birthdays, and then click something to send messages to the new list. 3. Extras I’d Like: o Skip duplicate numbers so no one gets spammed. o Log which messages were sent successfully and which...
Bullet Points: Copywriting Skills: I have extensive experience in writing articles, product descriptions, website copy, and other forms of content. SEO Copywriting: I am proficient in creating SEO-friendly content that helps improve search engine rankings. Engaging and Persuasive Writing: I excel in writing compelling content that connects with readers and enhances brand engagement. Client Communication: I understand client needs and can craft clear, persuasive copy tailored to their target audience. Portfolio Examples: I have a portfolio showcasing my work, including blog posts, website copy, and product descriptions. Full Description: I am a skilled copywriter with a passion for creating content that not only informs but also engages and motivates readers. With a strong background...
...between different screenshots. OCR Data Extraction and Excel Conversion: Use OCR tools (like Tesseract) to extract text from the cropped images. Convert the extracted data into a structured format, and save it into an Excel file, with each piece of data placed into corresponding columns. Requirements: Proficiency in Python (Pillow, OpenCV, pytesseract). Experience with OCR for text extraction from images. Ability to work with Excel files using Python (openpyxl, pandas). Experience with automating image processing tasks. Strong attention to detail and problem-solving skills. Project Details: This is a freelance task-focused project with flexible variations in screenshots. You’ll need to provide code for both cropping and conversion to Excel. So I can ...
We need an experienced data researcher with the following skills: 1) Experience in Internet Research 2) Good English skills 3) Knowledge of google sheets & excel 4) Attention to detail This is a long term project.
Excel Data Cleaning: Removing duplicates, errors, and inconsistencies for accurate analysis. Excel Data Formatting: Organizing data into a clear and professional layout. Excel Dashboards: Creating interactive and visually appealing dashboards for data visualization. Excel VBA: Automating repetitive tasks and creating custom macros to save time. Pivot Tables and Charts: Summarizing and visualizing large datasets effectively. Data Analysis: Performing advanced calculations and trend analysis for insights. Conditional Formatting: Highlighting important data with rules and color coding. Formulas and Functions: Using advanced formulas (e.g., VLOOKUP, INDEX-MATCH) for dynamic calculations. Data Validation: Ensuring data accuracy with dropdown lists and validati...
...seeking an experienced Power BI developer to create a comprehensive report for our sales and marketing data. The ideal candidate should have a strong background in data visualization and analysis, with a proven track record of delivering high-quality Power BI reports. **Project Requirements:** 1. **Data Integration:** - Integrate sales and marketing data from various sources (e.g., CRM, ERP, Excel files). - Ensure data accuracy and consistency. 2. **Report Design:** - Create visually appealing and interactive dashboards. - Include key metrics such as sales performance, marketing campaign effectiveness, customer segmentation, and ROI analysis. - Design reports that are easy to navigate and understand. 3. **Data Analysis:** - Perform in-depth analysis to identi...
I need a Word document transposed into an Excel file. Key Points: - The original document contains text only. - Text organization within the Excel file is not uniform. It varies and will need to be explained. Ideal Skills: - Proficient in Microsoft Excel and Word. - Good understanding of data transposition. - Detail-oriented to ensure accurate transfer of content.
I'm seeking someone with strong Google Sheets skills to create a team-wide KPI tracking document tailored to our needs. The document should compile data from different tabs/sheets into a "master" document for our weekly meetings. Key Requirements: - The sheet should automatically add new weekly KPIs to the top of each page. - There must be an input field for setting and distributing new KPIs to team members. - The KPIs will mainly come from manual inputs by team members. KPI Categories: - We're tracking various metrics such as outreach calls, follow-ups, face-to-face meetings, quotes, invoiced sales, and new customers. Setting New KPIs: - New weekly KPIs for each team member will be set manually in a designated field. Ideal Skills and Experience: - Proficien...
I need a comprehensive Excel spreadsheet containing the top 5,000 accounts. The data should include: - Number of followers - Social handle - URL link The accounts should be ranked by the number of followers. The ideal freelancer for this project should have experience in api data collection and Excel, with a proven track record of working with social media data. Attention to detail is crucial, as is the ability to source information from reliable platforms. Please do not submit junk data, or data you have not reviewed yourself. Send an excel file or google sheet document link. Thanks
...network's efficiency. The perfect candidate will have: - Proven experience with Mighty Networks or similar platforms - Expertise in digital marketing, especially in ad creation and optimization - Strong communication skills for effective member engagement - Ability to manage administrative tasks with attention to detail I am excited to work with someone who is as passionate about helping others excel in their personal and professional lives as I am. Let's make this network a thriving community together!...
I'm in the process of establishing a consulting company that specializes in project planning. I need a creative and professional name for the business that reflects its purpose and expertise. The name should be suitable for a consulting firm, and resonate with potential clients in need of project planning services. Ideal skills for this job include: - Creativity and innovative thinking - Understanding of consulting and project planning industry - Branding and naming expertise - Strong communication skills - Knowledge of SEO-friendly business naming conventions. Please provide examples of similar work you've done in the past.
I need a freelancer to help me gather real estate property addresses from public companies' websi...addresses from public companies' websites. I will provide the list with 25 public companies with the URL to their properties. Save the list of properties for each public company in a separate Excel to avoid confusion. Please compile the data in a Microsoft Excel spreadsheet, and ensure to include the following fields for each property address: - Street Address - Address 2 (optional) - City - ZIP/Postal Code - Name (if applicable) - State - Country I will provide a sample template to help. Ideal skills and experience for this job include: - Proficiency in web research - Familiarity with Microsoft Excel - Attention to detail - Understanding...
...Change the field “Nombre de la empresa (opcional)” to “DNI/RUC” and make it mandatory. • Reorder the address-related fields to follow this sequence: Departamento (Department), Provincia (Province), Distrito (District), Dirección completa (Full Address, with an example as a placeholder). A detailed Excel file with the list of departments, provinces, and districts in Peru will be provided. 2. Shipping configuration: • Adjust shipping rates based on the provided list of Peruvian locations in Excel. • For destinations within the Department of Lima and the Province of Lima: • Calculate shipping costs using the provided price table. • For destinations outside the Department of Lima and the Province of Lima: • Di...
...sheets linked by employee ID. - The summary and allocation detailed report should be in Excel format. - Total earnings is calculated as: Gross Benefit + Worker Compensation + Net Salary. Gross Benefit is the total of all benefits in the salary master file from columns R to AV, excluding Federal Income tax, California Amount, and California SDI. Option to add inclusion or exclusion without changing formula. - The bi-monthly payroll needs to be consolidated from two lines per employee to one line summary report. - Class allocation percentages should be sourced from the class columns E to VU in the class allocation sheet, and must total 100%. Ideal skills and experience for this job include: - Proficiency in Excel, especially in data analysis and manipulation. - Exp...
I Just need to update a smartsheet candidates sheet after I get a meeting in calendly with that candidate, updating statud and date in the sheet. And at the same time update a tag in mailchimp contact list to know that candidate have a pending interview. Once the interview date ocurrs update the mailchimp status when I change the status in Smarsheet control sheet. I would like be made with Make better than zapier or otheer tools no so expensive as Zapier.
...a dented metal cup, and a small, smooth river stone she'd found on her last trek. Lilah slipped out the back door, her boots crunching on the dew-kissed grass. The village was still quiet, the smoke from chimneys barely beginning to curl into the air. She didn't head towards the fields or the woods this time; her fox-sense led her in a different direction. She found herself following the winding path that snaked alongside the river, the same river that chuckled and gurgled secrets between its mossy particular stretch of the river was less traveled, wilder. Overhanging branches formed a green tunnel, creating a dim, mysterious light. Lilah loved this place. It felt like the world was holding its breath just for her. She followed the river for what felt like hours, her f...
...assist me in finding career boards for non-technical jobs from a list of approximately 1500 companies. The company list already has their website URLs and I've completed 60 as an example. Ideal Skills: - Data Entry - Research - Excel/CSV Proficiency Requirements: - Find career boards for non-technical jobs - Populate a CSV file with results I have tried to programmatically finish (you can not do this) and I have manually completed 60. This will be around 6 hours of manual internet search. I recommend doing site: <url> careers. I have created another sheet called to help where I have done this to give you a starting point. Some of the will be the correct location, others will need more clicking to find the correct place where all the jobs are located (th...
I need some expert guidance with Excel formulas for a cap table. The focus will be on equity allocation. I have created the excel file and entered the different rounds but I need help with some of the formulas. Key Requirements: - Formulas to effectively distribute equity among stakeholders - Representative display of shareholder names, number of shares held and percentage ownership Ideal Skills and Experience: - Strong proficiency in Excel, particularly with complex formulas - Experience with cap tables and understanding of equity allocation - Ability to present data in a clear and comprehensible manner
I need a methodical and detail-oriented freelancer to assist with data entry from supplied aerial site ...images. Specific Tasks: - Using Google Maps to obtain GPS coordinates for 96 marked building locations on the aerial images. - Pasting these coordinates into a provided Excel spreadsheet template. - Manually verifying each entry to ensure accuracy. Automation is not an option for this task. Example provided for the Excel spreadsheet. Please note, only the GPS coordinates are required from Google Maps, with the building locations indicated by outlines on the aerial images. Ideal Skills: - Proficiency in using Google Maps - Excellent attention to detail - Ability to work methodically and systematically - Competency in Excel - Previous experience with similar dat...
I am looking for a skilled VB.NET developer to assist in resolving issues (now and ongoing) that we are trying to send live. You need vb.net skills and experience with ms office object model though vb.net w...ongoing) that we are trying to send live. You need vb.net skills and experience with ms office object model though vb.net we also need an installer so we can push updates to clients. Key Requirements: - Develop a VB.NET application that can scan and read content from Excel and Word documents. - Implement functionality for the app to interpret different types of content such as text, tables, and charts. Ideal Skills: - Proficiency in VB.NET - Experience in developing applications for document scanning and reading - Familiarity with Excel and Word document structures -in...
...should be comprehensive and cover a range of details about each student. Key Data Points Needed: - Student First Name - Student Last Name - Current U.S. City - Student University Email - Student Personal Email - Student Home Country - U.S. University Name - Degree Pursuing (Bachelor's, Master's) The ideal candidate will have: - Experience in data collection and research - Access to verified data - Ability to deliver in a clear and organized way Important Note: The home country of the student must not be the USA. I am open to data from any other region, and I will need this data regularly over the next few months. Delivery Format: The data should be delivered in a Spreadsheet (Excel/CSV). If you already have a database of this information, plea...
...diligence, reviewing key metrics, customer data, and operational details of target companies. • Collaboration: Work closely with the leadership team to refine acquisition strategies and contribute to portfolio growth. What We’re Looking For: • Strong interest in online businesses, digital assets, and entrepreneurship. • Exceptional analytical skills with a detail-oriented mindset. • Proficiency in Excel, financial modeling, and market research tools. • Ability to work independently and manage multiple tasks in a fast-paced environment. • Familiarity with SaaS, social media platforms, or mobile apps is a plus. What We Offer: • A competitive stipend for the duration of the internship. • Hands-on experience in the venture capital and M&...
I have a project that involves transferring data from PDF documents into an Excel spreadsheet. The documents are about 100 pages long and contain a mix of text and numbers. The successful freelancer will need to: - Accurately input this information into Excel in both alphabetical and numerical order. - Use a pre-existing template, with potential for adding or deleting columns based on predefined rules or guidelines. Ideal candidates will have strong attention to detail, experience with data entry and proficiency in Excel. Prior experience dealing with PDF to Excel data transfer will be highly regarded.
I need an Excel spreadsheet that can perform specific calculations with my numeric data. - The spreadsheet should be able to multiply specific columns together: Column B with Column E to get G, Column C with Column F to get H. - It should then add these two results together to fill Column I. - Next, Column I should be multiplied by Column J to fill Column K. - This sequence should repeat with Columns L through P and a few additional columns. Ideal skills for this job include advanced knowledge of Excel, particularly in using formulas for multiplication and addition across various columns. Experience with data management and numerical data analysis would also be beneficial. Please ensure you have a strong understanding of Excel's capabilities before bidding.
I'm looking for a professional who can create a contract with dynamic dropdowns in a document using Power Automate. Key Requirements: - The contract document will be created on Power Automate. - The dropdowns in the contract should be populated from an Excel Sheet. - The contract creation should be triggered by an Email Request. Ideal Skills: - Extensive experience with Power Automate - Proficiency in Excel - Strong understanding of contract creation - Excellent email management skills
...to customer inquiries, resolving issues, and ensuring a positive customer experience. - Research Tasks: Conducting online research for various projects and compiling findings in a clear and concise manner. - Social Media Management: Overseeing company social media accounts, posting updates, and interacting with followers. Ideal Skills and Experience: - Proficient in the Microsoft Office Suite: Excel, Word, PowerPoint, and Outlook. - Familiar with CRM Software: Experience with tools like Salesforce or HubSpot is a plus. - Knowledgeable in Project Management Tools: Comfortable using software like Trello, Asana, or Monday.com. - Strong Customer Service Skills: Previous experience in a customer support role is preferred. - Excellent Research Skills: Able to find and compile informat...
I need assistance in extracting data from the website using the search term ONEU9092093. Requirements: - Get all available data from the topmost row of the search results - Paste the data into a Google Sheet, which I will provide access to Ideal Skills: - Web scraping - Proficiency in Google Sheets - Attention to detail Looking forward to your bids.
...Application Project Overview: We are looking for an experienced and skilled developer/team to create a comprehensive AI-Powered Career Counselor Application. The platform will assist users in making informed career decisions by leveraging Artificial Intelligence (AI) and Machine Learning (ML). The system will provide features like resume parsing, job trend analysis, skill gap identification, career path prediction, and an interactive AI chatbot. Additionally, the system will include a sentiment analysis feature to assess user emotions and provide more personalized recommendations. Key Features and Requirements: Phase 1: Foundational Modules (Mini Project) Resume Parsing and Preprocessing Extract and preprocess key details (e.g., skills, education, experience) from resumes in va...
... and boost conversions. Dedicated to helping businesses grow their online presence and achieve measurable success. in-depth market research and competitive analysis to identify trends and optimize campaigns. , execute, and monitored multi-channel campaigns, including SEO, PPC, social media, and email marketing, resulting in 20% increase in lead generation. advanced Excel skills to analyze campaign performance, creating insightful reports for clients. visually appealing and professional presentations using PowerPoint to communicate marketing strategies and results effectively. engaging content for websites, blogs, and social media, increasing audience engagement by 15%. websites and landing pages for search engines, driving 40% growth
...before I will hire. THANK YOU! I'm looking for a proficient web developer to create a dynamic e-commerce website. The primary purpose of this site is to sell DTF prints and Custom T-shirts. I have the newest Technology in DTF printing as it prints 9 colors. This will be a MAIN point for the site. Key Requirements: - A user-friendly interface for easy navigation and shopping experience. - Gangs Sheet Creator for DTF Printing - Custom Graphic T-shirt Creator (Use our graphics or Upload Customer Graphics to create the T-shirt) - A secure and reliable payment system accepting Credit/Debit Cards, Crypto (XRP, BTC) and PayPal. - A well-structured online catalog showcasing the DTF prints and T-shirts. - An efficient back-end system for order processing and inventory management....
i have the excel file you need to analyse the data and I want to you create advanced PowerPoint presentation presentation it need to be present to the big forums, primarily aimed to the top management. The presentation should reflect a professional and corporate style, with clear, concise content and well-structured slides. Ideal Skills and Experience: - Proficiency in PowerPoint - Experience in designing corporate presentations - Excellent understanding of corporate language and presentation etiquette - Ability to condense complex information into clear, digestible content - Creative approach to maintaining viewer engagement within a professional context.
I'm looking for a proficient web developer to create a dynamic e-commerce website. The primary purpose of this site is to sell DTF prints and Custom T-shirts. Key Requirements: - A user-friendly interface for easy navigation and shopping experience. - Gangs Sheet Creator for DTF Printing - Custom Graphic Tshirt Creator - A secure and reliable payment system accepting Credit/Debit Cards, Crypto (XRP, BTC) and PayPal. - A well-structured online catalog showcasing the DTF prints and T-shirts. - An efficient back-end system for order processing and inventory management. Ideal Skills: - Proficiency in e-commerce website development. - Experience with DTF prints and T-shirts e-commerce preferred. - Strong knowledge of secure payment system integration. - Excellent skills in crea...
