Excel 2003 vba worksheet nameроботи
Необхідно розробити макрос з перетворенням 1 файлу excel "для обробки" у кілька файлів-шаблонів теж у excel. Суть заповнення всіх полів у цих шаблонах з даних файлу excel "для обробки" згідно з алгоритмом описаним у технічному завданні.
Створити таблицю Excel та внести в неї данні з касових чеків. Розбити по періодам та групам.
Потрібно написати модуль (скрипт) для оновлення цін в інтернет магазині. Періодично висилають нові прайси, з яких потрібно підтягувати нові ціни. Вибірку робити по артикулу товару. На сайті поле артикула містить також назву фірми (для прикладу Nowodvorski 65441), а у прайсі просто 65441. Прайси приходять у Excel. Інтернет магазин створений на базі CMS Drupal 7.
Ввод информации в базу, возможно Excel либо другой редактор, могу работать непосредственно с онлайн информацией
Вносити дані до таблиці Excel. Це э дуже непогана робота яку можна виконувати дуже швидко, а головне чітко і без помилок.
I need a spreadsheet expert to help me streamline my expense tracking tables with automatic calculations. My spreadsheet contains financial data and is primarily used for tracking expenses. The goal is to make the tracking process easier and more efficient. Ideal Skills: - Proficient in Excel or Google Sheets - Experience with financial spreadsheets - Knowledge of creating automatic calculations - Attention to detail for tracking accuracy - Ability to optimize and improve existing tables Please provide examples of similar projects you have completed in the past.
...clear and professional formatting suitable for entry-level positions in marketing or project management. Provide both one-page and two-page versions of the resume in PDF and editable formats. Details to Include: Education: From high school to bachelor’s degree. Internship Experience: Responsibilities and accomplishments at BrightFuture Solutions as a Marketing Intern. Skills: Technical tools (Excel, Tableau, Canva, etc.), soft skills (communication, collaboration). Hobbies/Interests: Basketball, photography, traveling, and graphic design. Career Goals: Focus on marketing and project management roles. Requirements: Proven experience in creating professional resumes, preferably for recent graduates. Strong design and formatting skills (knowledge of ATS compliance is a plus)...
I'm looking for a freelancer to assist with electronic data entry of customer information from Excel spreadsheets into a new database. The data includes purchase history, so attention to detail is crucial. Ideal skills and experience for the job: - Proficient in Excel - Experience with data entry - Attention to detail - Able to handle confidential information with discretion
I'm looking for a talented graphic designer who can create a modern and sleek flyer for The Word Church. The flyer is to be sized 1024X768 and should prominently feature our 2025 theme: "Upgrade, Elevate, & Excel" (Ephesians 3:20). Key elements to be included: - The text: "The Word Church", "2025: Upgrade, Elevate & Excel (Ephesians 3:20)", "Tony Ray Smith, Senior Pastor", "". - A focus on the theme of 2025: Upgrade, Elevate, & Excel. - Our church logo. - A photo of our pastor. Example IMG_9673 ' Design specifications: - A modern and sleek style. - A dominant blue and silver color scheme.
I'm looking for a skilled Excel VBA programmer to create a script that will automate the process of copying and pasting data from multiple emails in a specific Outlook folder into an Excel worksheet. Key Requirements: - The VBA code should be able to handle multiple emails, efficiently copying and pasting the relevant data from each. - The code needs to target emails located in a specific folder in Outlook, so familiarity with Outlook's structure and VBA's capabilities in interfacing with it is crucial. - The data from the emails should be pasted into the Excel worksheet in an organized manner. Ideal Skills: - Proven experience with Excel VBA programming - Familiarity with Outlook and its folder structure - Ab...
I'm in need of a professional who can assist me with entering financial records into spreadsheets and making cold calls. Data Entry: - You'll be enteri...financial records into spreadsheets. - I have a general idea of how the spreadsheets should look, but I will need your input and expertise to create a clear and efficient format. Cold Calling: - You'll also be making cold calls on my behalf. - Excellent communication skills and a persuasive demeanor are essential. Ideal Skills: - Proficiency in data entry and spreadsheet software (preferably Excel). - Previous experience with financial data is a plus. - Strong communication skills for cold calling. - Ability to understand and contribute to spreadsheet design. Please provide examples of your previous work tha...
We need to add thousands of products to our ecommerce website. Most of our suppliers do not provide the product images and product documents like specification and installation documents. We need help getting these images and documents from supplier websites. You will be provided with excel files for each supplier with the full list of product for which to get images and documents
I'm seeking a skilled Excel VBA programmer to create a macro for me. The primary function of this macro is to send automated email reminders based on due dates in my spreadsheet. Key Requirements: - Automate email Notifications: The macro should send out reminders as deadlines approach, helping me stay on top of my tasks. - Data Validation: The macro should also check for missing data in my Excel file and notify me accordingly. Ideal Skills: - Proficiency in Excel and VBA - Experience with creating macros for email automation Thank you!
I need a fillable PDF created from an Excel worksheet. The PDF will be used to conduct a survey and will include both multiple choice and short answer questions. Key Requirements: - Convert specified Excel worksheet into a fillable PDF. - Incorporate various types of survey questions (multiple choice and short answer). - Ensure the PDF can be easily returned via email once completed. Ideal Skills: - Proficiency with Excel and PDF creation software. - Experience in designing user-friendly fillable PDFs. - Understanding of survey design and data collection processes.
I need an expert in Excel to assist me in merging two files. The task involves transforming the data in these files before the merge. Ideal Skills: - Proficient in Excel, particularly in data transformation techniques - Experience with data merging - Attention to detail for accurate data handling
I have 6 excel spreadsheets containing attendee information for some small upcoming events. I need the data sorted into groups by age and other specific requests. Additionally, I need some standard data cleaning to be done, specifically standardizing phone numbers and removing duplicates. Ideal skills for this project include: - Strong proficiency in Excel - Attention to detail - Good understanding of data sorting and cleaning techniques Please bid if you can assist with this task.
I need help with reworking an existing venture capital excel model for a new investment. The model should provide accurate financial returns for this investment. Specific Sections: - Revenue projections - Expense forecasts - Return calculations Assumptions to Update: - Market growth rate - Cost of goods sold - Operating expenses New Financial Metrics to Incorporate: - Internal Rate of Return (IRR) Ideal Skills: - Expertise in Excel and financial modeling - Understanding of venture capital and investment analysis - Strong analytical and problem-solving skills Experience: - Prior experience reworking venture capital models - Proven track record of accurate financial forecasting I'm looking for a freelancer who is detail-oriented and can deliver a robust model that me...
...statements for each account have already been converted to excel format. You must go through the transactions for each year and properly itemize each transaction and creat the Businesses Financial Statements (PNL & BS) for tax filing purposes. This role also involves reviewing my personal bank account statements to identify any business-related transactions made that should be included such as making a payment for a business credit card, owner investments, and Etc. I need this to be completed ASAP perferably by the end of this week if possible. Key Responsibilities 1. Organize and Classify Transactions: Review and categorize all business-related transactions from each accounts transactions that have already been converted to excel from the PDF statements, including: ...
I need a Data Entry Specialist, preferably with an engineering background, for a 3-hour task. This project involves: - Transferring mixed data (numerical and textual) from a PDF document into an Excel spreadsheet. - Organizing the data by categories or sections in a clear and user-friendly format. - Applying both totals and averages using basic Excel functions or formulas. The ideal candidate for this task must: - Have a strong proficiency in Excel. - Possess keen attention to detail and accuracy. - Be able to complete the task within 3 hours. Given the nature of the task, an engineering background would be beneficial due to the need for precision, analytical skills, and a structured approach.
I need assistance pulling all followers from my business Instagram account. Specifically, I'm looking for their username, email, and name (if available). Ideal skills for this project include: - Proficiency in data extraction and web scraping - Familiarity with Instagram's platform and its data privacy rules - Experience in data presentation using Excel or CSV formats Please bid only if you can deliver the data as a neatly organized spreadsheet (Excel, CSV).
El proyecto "Servicios Personalizados en Excel" consiste en ofrecer trabajos a medida en Microsoft Excel, donde el cliente especifica sus requerimientos y yo me encargo de realizar el trabajo correspondiente. Este enfoque garantiza que cada proyecto se adapte a las necesidades unicas de cada cliente, asegurando satisfacion y resultados optimos. Objetivos del Proyecto: 1. Atención Personalizada: Escuchar y comprender las necesidades del cliente para diseñar soluciones efectivas. 2. Ejecución Rápida y Eficiente: Realizar los trabajos solicitados en un tiempo razonable, manteniendo altos estándares de calidad. 3. Diversidad de Servicios: Ofrecer una variedad de servicios que incluyen automatización de procesos, análisis...
I'm in need of a comprehensive spreadsheet to track various em...and associated "points" per HR policy. - Detailed Recording: For each absence, the spreadsheet should capture the date and time, the reason for the absence, whether the employee gave late notice or not, and the number of "attendance points". - Identification: Employees should be identifiable by their full name. Here are some links to tutorial for similar trackers: Ideal Skills: - Proficiency in Excel or Google Sheets. - Experience in creating tracking spreadsheets. - Understanding of HR metrics would be a plus. Please ensure that the spreadsheet is user-friendly and can be easily updated on a regular basis. Looking forward to your bids.
I have two Excel files detailing my wine collection - one is from 2023 and the other is an update. I'm looking for someone to identify the differences between the two files. Specifically, I need to see: - Changes in item quantities - Any addition or deletion of items After the comparison, I would like the results to be compiled into a summary report. Additionally, if possible, a visual chart illustrating the differences would be appreciated. Ideal candidates should have extensive experience with Excel and data analysis. Familiarity with inventory management and wine collections would be a plus.
I require an excel sheet that tracks and analyzes the changes in open interest data of the NIFTY index. This sheet should be able to provide insights into market sentiment based on this data. Key Requirements: - The excel sheet should continuously update the data every minute. - The sheet should be able to provide a text summary of inferences about market sentiment from the open interest data. Ideal Skills: - Proficiency in Excel with experience in financial data analysis. - Understanding of open interest and its implications on market sentiment. - Ability to create an automated Excel sheet that updates data every minute. Please note that I'm looking for a freelancer who can deliver a high-quality, reliable tool for tracking and interpreting NIFTY index...
I need a excel sheet (some columns protected), as soon as date are entered in Sheet 1 on a specific column the entire row needs to more to tab2, same at tab 2 as soon as date entered the row needs to move automatically to tab 3, same to tab 4, 5, 6. (All the rows are protected, can not be deleted, they will only move between tabs as the project runs) - Production Job Tracking report I would like to do the project together with the freelancer on teams (within the next hour is possible) I assume the project will take maximum an hour
I'm looking for an Excel developer to create an inventory management system. While specifics on the functions of the system haven't been detailed yet, the system will need to track stock levels and generate reports. As such, the ideal freelancer for this project should have prior experience in developing similar systems on Excel. Skills and experience required: - Advanced knowledge of Excel - Prior experience in developing inventory management systems - Ability to generate and interpret detailed reports - Excellent understanding of tracking stock levels
...freelancer who can assist me with entering part numbers and costs from a supplier's website into an Excel spreadsheet. This spreadsheet contains makes and models for every vehicle listed in the UK. Key Responsibilities: - Accurately input part numbers and costs from a supplier's website into designated columns of an Excel spreadsheet. - Follow specific formatting and column header requirements as detailed below. Specific Columns and Formatting: - The data needs to be entered under specific column headers in a predefined order: makes, models, costs, part numbers. - Conditional formatting or color-coding will need to be applied at times according to supplied guidelines. Ideal Skills: - Familiarity with Excel and its data entry requirements. - Attention to...
I need a comprehensive dataset prepared for Tableau that encompasses a variety of data types including sales, customer, and financial information. The data is currently in Excel/CSV format. Key Requirements: - Transform and clean various data types (sales, customer, financial) from Excel/CSV for Tableau - Prepare the dataset to allow for a variety of analyses and insights, including but not limited to sales trends over time, customer demographics, and expense versus revenue tracking. Ideal Skills: - Proficiency in Excel/CSV data handling - Expertise in data preparation for Tableau - Strong analytical skills to understand and anticipate necessary data transformations for desired insights Please note that the final dataset should be versatile enough to facilitate a wi...
I'm looking for an Excel expert to design a template for tracking my total monthly/yearly sales. This template should also allow for comparison over time. Key Features: - Total sales tracking - Comprehensive data visualization features: Bar charts, Pie charts, Line graphs - User-friendly manual data input Ideal Skills: - Advanced Excel skills - Experience in data visualization - Knowledge in sales data tracking
I'm in need of a reliable freelancer skilled in Excel and SQL database management. Key Responsibilities: - Regular data entry and updating in Excel. - Managing and maintaining a SQL database. Ideal Skills: - Proficiency in Excel for data entry and updating. - Experience with SQL database management. - Attention to detail for accurate data handling.
...looking for a developer/team to create a mobile app for managing hospital admission details for employees and their dependents. The app will have two user roles: employees and employers. Key Features: Employee Login: Enter Employee ID to access the app. Display Details: Show the employee's name and their dependents. Admission Form: Select the person to admit (employee or dependent). Input fields for hospital name and admission date. Submit Button: Sends the data to a backend. Employer Dashboard: Generate an Excel sheet with all admission records....
I'm seeking an Excel expert to help build a dashboard for a monthly employee task tracker. The excel sheet is on Google shared folder so we need to work together The dashboard will need to display: - Employee names and tasks completed - Performance metrics The visualization of the data will primarily involve: - Charts and graphs This dashboard will be used by: - Managers Ideal skills for this job include: - Advanced Excel proficiency - Experience with data visualization - Understanding of performance metrics Please bid if you have the relevant experience.
... Key Responsibilities: • Set up and manage Facebook Ad campaigns, including campaign groups, ad sets, and individual ads. • Collaborate on Google Ads campaigns, refining bidding strategies and audience targeting through regular Zoom sessions. • Optimize ad campaigns to ensure maximum ROI, including A/B testing and data analysis. • Work with contact lists from tools like Seamless to upload Excel files containing 1,000-2,000 targeted contacts into the backend of Facebook Ads Manager and Google Ads for custom audience creation. • Create and manage remarketing campaigns using these custom audiences to deliver video ads tailored specifically to this list. • Provide regular performance analyses and actionable recommendations based on campaign data. ...
Transform Excel Sheet Data to Charts and Stats using Power BI, we need interpretation for each chart.
I am seeking a highly experienced circuit design engineer with expertise in digital and analog electronics, proficient in using Eagle for PCB design. The ideal candidate will have a strong background in signal conditioning, low-noise circuit design, and power management for compact, low-po...power management for compact, low-power applications. Familiarity with integrating multiple sensors, including PPG, glucose, HRV, and electrolytes, into electronic systems is a significant advantage. The role requires exceptional problem-solving skills, attention to detail, and the ability to deliver efficient, production-ready designs, including schematics, PCB layouts, and prototypes. If you excel in creating innovative circuit solutions and thrive in challenging projects, I would love to hear...
This project involves manually searching through a list of Facebook groups for posts containing offers and events (e.g., "Happy Hour," "Live Music"). The freelancer will identify relevant posts, extract key information such as location names and Facebook links, and compile the data into an Excel spreadsheet. They will also download and save images of the event locations. The search period for this project is from January 1st to January 7th. Evaluation Questions: 1) Describe your experience with manual data entry and data organization. 2) How would you approach the task of efficiently searching through multiple Facebook groups and identifying relevant posts within a short timeframe? 3) Imagine you encounter a Facebook post that mentions an event but does not ...
Hi, Statistics is my favorite subject and will be glad to help. I have skills in Data Processing, Statistics, R Programming Language, SPSS, Tableau and Excel. Hire me for your methodology and data analysis chapters for your dissertation.
I'm seeking a proficient Excel Solver expert to help me analyze my inventory data. The tasks involve moving averages, Mean Absolute Deviation (MAD) calculations, and time series forecasting. Key Tasks: - Help with moving average calculations - Calculate MAD - Apply time series analysis for forecasting Ideal skills for this project include: - Advanced Excel skills, especially with Solver - Strong understanding of inventory data analysis - Proficiency in time series forecasting methods
...currently using an Excel template to visually represent all our projects in a Gantt chart. I need an expert to enhance this template for me by adding a sales target function. This function should calculate and sum up the revenue for each job based on the percentage of the job completed in each month. - Example: For a $100k job with 75% of the work days in January and 25% in February, the system should automatically allocate $75k to January and $25k to February, and sum up all the jobs for each month. The work days are automatically calculated by the existing template. The only adjustment needed is the division of revenue by month and the presentation of this in total. I have an example of the desired output, just built manually. Ideal skills and experience: - Proficiency in ...
Hello Sophia, Please translate given file by January 12th. Thank you, G
...Visualization and Reporting: - Create interactive dashboards using tools like Power BI or Tableau. - Provide meaningful visualizations such as charts, graphs, and heatmaps for easy interpretation. - Prepare a detailed final report with actionable recommendations. Requirements: - Proficiency in Python, R, or other statistical programming languages. - Experience with tools like Excel, Power BI, or Tableau for visualization. - Strong understanding of statistical methods and data modeling. - Ability to communicate insights effectively. Project Timeline: Expected completion within 3 days from the project start date. If you have the required skills and can deliver high-quality results within the timeline, we’d love to hear from you. Please include e...
I'm looking for a talented graphic designer to create a modern, minimalist, single-color logo for my real estate company. The design will incorporate an image I've already selected, so the designer will need to integrate th...Ideal skills and experience: - Strong background in modern, minimalist design - Experience in logo design, particularly for the real estate industry - Proficient in graphic design software - Able to seamlessly integrate provided images into new designs - Strong understanding of single-color designs The name of the company Descamps Immobilier, maybe you can integrate the D and I in the image add subtitle DEPUIS 2003 Font Tenez for "Descamps Immobilier" or similar and ROBOTO for "Depuis 2003" I need the logo in Illu...
...looking for an expert in Excel and astrology software integration. The primary task involves data import/export between the two platforms (excel and software). Please note, the data to be transferred/extracted encompasses specific fields from the astrolog software. Ideal Skills: - Proficiency in Excel and creating macros - Experience with software or with any astrology software that uses swiss ephemeris - Data management skills - programming skills to pull out data from () - be able to connect data from excel and the astrology software I will be placing dates and times into excel, and then I want to click a button and extract out info from software and paste it into the excel worksheet. The data I want to extract
I'm in need of a modern-style name card design that incorporates vibrant colors. The card will feature: - My name - Contact details - Our company logo The ideal freelancer for this project should have a strong portfolio in modern design and experience with creating visually compelling name cards. A knack for using vibrant colors effectively and understanding of minimalist principles to avoid clutter would be a plus.
PLEASE READ FULLY!!!!!! If you do not read, and submit artworks that are nothing like what we have asked, you will be reported! If you send great artwork, we will pay good money. This is just a start. We are looking for a new logo to represent our new touring name, we are in a 4x4 touring Australia. We need the name on the artwork. It is LOST DESTINATIONS We need the file to be full vector, NOT JUST AI SUBMITTED FILES WITH NO OUTLINES ETC!!! We need to be able to pull the artwork apart if we need to. This will be used for socials, tshirts, printing etc. Please keep it nice, vivid colours welcomed, teals, pinks, blues, oranges, greens etc are all welcomed THE THEME MUST CORRELATE TO palm tree, island theme, 4x4, ocean etc. WE WOULD LIKE THE FONT LIKE IN THE PICS
...Collection:** - Use tools like Lusha, , and any additional necessary platforms. - Identify target companies and their main subsidiaries across the specified regions. - Gather detailed contact information, including **personal emails and phone numbers** of CEOs, CFOs, and key decision-makers. 2. **Data Organization and Delivery:** - Structure the information in an Excel sheet or database, ensuring it includes company details, locations, and contact hierarchy. - Deliver contacts progressively for quality verification and catalog integration. 3. **Verification:** - Cross-check all collected data for accuracy, reliability, and completeness. **Requirements:** - Expertise in tools like Lusha, , and other B2B data platforms. - Strong skills