Excel vba save as csvроботи

Необхідно розробити макрос з перетворенням 1 файлу excel "для обробки" у кілька файлів-шаблонів теж у excel. Суть заповнення всіх полів у цих шаблонах з даних файлу excel "для обробки" згідно з алгоритмом описаним у технічному завданні.

Створити таблицю Excel та внести в неї данні з касових чеків. Розбити по періодам та групам.

Потрібно реалізувати автоматичну вигрузку csv файла з фтп в БД сайта. На сайті повинно бути поле вводу номера телефона (для перевірки кількості бонусів на сайті) після вводу, людині повинна прийти смс з кодом підствердження, після вводу відкривається інформація про клієнта, а саме ПІБ, номер телефону, номер бонусної картки та кількість накоплених бонусів

Потрібно написати модуль (скрипт) для оновлення цін в інтернет магазині. Періодично висилають нові прайси, з яких потрібно підтягувати нові ціни. Вибірку робити по артикулу товару. На сайті поле артикула містить також назву фірми (для прикладу Nowodvorski 65441), а у прайсі просто 65441. Прайси приходять у Excel. Інтернет магазин створений на базі CMS Drupal 7.

Потрібно розробити імпорт інформацію з csv файлу та створити під неї сторінку телепередачі для сайту Детальне ТЗ в доці Приклад файлу імпорту прикріплений, для імпорту буде такий же, але в форматі csv

Transfer news websites advertising texts...

Ввод информации в базу, возможно Excel либо другой редактор, могу работать непосредственно с онлайн информацией

Вносити дані до таблиці Excel. Це э дуже непогана робота яку можна виконувати дуже швидко, а головне чітко і без помилок.

? About Us: SmartAccessory is a newly launched online store specializing in innovative and stylish smartphone accessories. We are on a mission to grow our brand and need creative, motivated freelancers to help showcase our products on social media platforms like TikTok and Instagram. What We’re Looking For: We are looking for talented content creators who can: Create engaging TikTok videos or Instagram Reels that highlight the value of our smartphone accessories. Promote our products in a way that resonates with their audience. Collaborate on affiliate-based campaigns with clear, trackable results. What We Offer: ? Attractive Commission: 10% commission on every sale made through your unique link or promo code. 15% commission if you create content for our own social media accounts. ...

I need an expert in Excel 365 who can link two sheets for me. The first sheet should update the second in real-time. - Data Type: The data to be linked is mixed, consisting of both text and numerical data. - Version: The linking has to be done in Excel 365. Please only reach out if you're proficient in Excel and can ensure real-time data linking. Thank you.

I need a skilled Excel professional to clean up the formatting in my Excel document so that "amount" and "total" columns are formatted consistently (centered or justified to right) and ensure that existing formulas in "amount" columns calculate to amounts in "total" columns. Create formula for all "total" amounts to calculate and produce grand total at end of doc. The project involves adding new formulas ensuring that newly inserted data is added to "amount" colum that the numbers will automatically calculate and be added to the totals, similar to the setup at the beginning of the document. When in doubt please ask questions. This is a small project with a deadline of end of day to late evening Sunday, 01/26/25. Key...

...c. Contact Information: i. Contact Person’s Name ii. Contact Person’s Title iii. Mobile Number iv. Main Number v. Email Address 2) Specific NGO Focus: Ensure the search targets Muslim-based NGOs only. 3) Use array aggregation to optimize credit usage, grouping multiple data points into a single data object. 2. Output Requirements: 1) Export the aggregated data into Excel format. 2) Automatically upload the Excel file to a designated Google Drive folder. 3) Provide sample outputs for the following locations: a. Malaysia, Selangor b. Indonesia, Jakarta c. Thailand, Bangkok d. England, London 3. Documentation: 1) Create a Microsoft Word instruction manual covering: a. How to run the workflow. b. Adjusting search parameters for countries, states, and categories. c...

I have multiple Excel files that need to be consolidated into a single Excel workbook. Each file should be placed in a separate sheet named according to its original file name. No data transformations or cleaning are required. Ideal skills for this project include: - Proficiency in Microsoft Excel - Experience in data consolidation tasks - Attention to detail to ensure correct file placement and naming.

...each step of the project, including a detailed description of Use Cases and system actions. In this guide, we will conduct a functional analysis for each of the processes in the Use Case for the "Smart Company Management System," describing the actions that a user will perform and the actions the system will perform. Additionally, we will address the constraints of non-functional requirements, such as performance, availability, security, etc. 1. Use Case: User Login User Actions: Entering user credentials: The user will enter their email and password. Constraints: The email must be in a valid format. The password must have a minimum length of 8 characters and include at least one numeric character and uppercase letters. System Actions: Checking login details: The sy...

Proposal for building a new scraper which contains feature. all sku from google sheet 2. Go to Website tradezone and serach for SKU 3. Fetch data like price and other required details. 4. Save Scraped data back to Google sheet Apart from all other feature you will get a two month of support as well.

Hello, I have experience in Python, web scraping, and data extraction using tools like Scrapy, Pandas, and Selenium. I can quickly debug your script and ensure it meets all your requirements. Here’s how I p...web scraping, and data extraction using tools like Scrapy, Pandas, and Selenium. I can quickly debug your script and ensure it meets all your requirements. Here’s how I plan to help you: 1. Fix bugs in your script within 2-3 hours. 2. Add functionality to match conditions and extract data as per your requirements. 3. Provide an easy-to-use script for future use. I will deliver the output in the required Excel format. Looking forward to your response so we can start immediately! Budget: $8 (as per your project description). Timeframe: First p...

# Job Title: Submit Job Applications on Job portals using my Resume # Job Description: I am looking for a reliable freelancer to submit job applications on my behalf usi...postings on Linkedin, Glassdoor, Workday and Indeed that match my experience and skills. - Submit my resume to the job listings - Ensure each application is relevant to my background and experience. - Track and report the total number of applications submitted using MS Excel or Google Sheets # Requirements: - Strong attention to detail and understanding of different job roles. - Ability to follow instructions and submit applications appropriately. - Good communication skills for reporting progress. - Experience using MS Word, MS Excel, Google Doc, Google sheets. # Compensation: - $10 for every 100 applic...

I'm seeking a proficient Excel VBA programmer to create a script for my Purchase Order workbook. This project involves both an existing workbook and the creation of a new one. The VBA script should be triggered automatically when the workbook opens. Key Tasks: 1. Implement filters at the top of the worksheet. 2. Adjust the width of Column C (Products). 3. Insert new columns with specified modifications: a. After Column I: Discrepancy (using formula: =I2-H2) b. After Column J: Reason (with a dropdown list sourced from the next sheet) c. After Column K: Notes (a free text column) 4. Apply specific formatting to the columns: a. Column A: 40 points b. Column B: 10 points c. Column C: 60 points d. Column D: 35 points e. Columns E-J: 15 points ...

I'm looking for an experienced web d...silverware products. Key Requirements: - Implement product search and filtering: This will enhance user experience by enabling customers to easily find their preferred items. - Incorporate customer reviews: I believe in transparency and value customer feedback. The developer should create a space for customer reviews on products. - Develop Wishlist functionality: This feature will allow customers to save their favourite items for future purchase. Payment Integration: The site should support payments via Credit/Debit cards and Bank transfers. PayPal isn't required at this moment. Ideal Skills: - Proficient in e-commerce web development. - Experience with customer review and wishlist functionalities. - Skilled in secure and reliable ...

I'm seeking a skilled Excel programmer to create a macro. This macro should compile various employee data from different sheets into a new Excel sheet. The task involves data cleaning, analysis, and report generation. Key Requirements: - Experience in Excel macro development - Understanding of data cleaning and analysis - Ability to generate summary reports, pivot tables, charts and graphs - Familiarity with handling employee data Please note, the goal is to create a macro that can automate this process, saving time and ensuring consistency in data compilation.

...financial metrics related to shipments of multiple grades across different countries. The sheets should track specific details for each shipment and highlight key insights. Ideal Skills: - Proficient in Excel or equivalent spreadsheet software - Strong understanding of financial data - Ability to visualize data clearly and concisely Specific Requirements: - Track shipment dates - Monitor product grades - Keep a record of destination countries - Provide an overview of which grade has moved the maximum - Include quantities and other relevant data - Need charts and graphs to represent the data as well - Pivot tables and more. These spreadsheets will be instrumental in helping me understand the financial aspects of my shipments better. Please, only apply if you have a stro...

I'm seeking a professional with extensive experience in cybersecurity and data analysis to build a consolidated vulnerability report and accompanying dashboard. Requirements: - The report should encompass ne...professional with extensive experience in cybersecurity and data analysis to build a consolidated vulnerability report and accompanying dashboard. Requirements: - The report should encompass network, application, and database vulnerabilities. - The final report should be delivered in Excel format. - The dashboard should visualize: - Vulnerability trends over time - Severity of vulnerabilities - Overview of affected systems Ideal Candidates: - Proven experience in cybersecurity. - Proficient in data analysis and Excel. - Previous work with creating security...

*Colour Game Requirements admin pannel* (user information) register list all withdraw doposit list recharge list account edit,block,unblock,delete,user trade ban tranjaction history,delete and add account balance add,debit,notice 8. users oder informations 9. user i...RECORD SAME WITHDEAWAL RECORD TO BALANCE MY PROMOTIONS CODE,MY PROMOTION LINK,COPY LINK ,RECHARGE,WITHDRAWAL,TRANSACTIONS CARD IN SIDE NAME IFSC CODE BANK NAME BANK ACCOUNT NO MOBILE NO EMAIL ID UPI ID CONTINUE TO ADD ADDRESS SECURITY IN SIDE RESET PASSWORD MOBILE NO VERIFICATION CODE (OTP) NEW PASSWORD CONTINUE TO SAVE DOWNLOAD &SUGGESTIONS

I need a skilled Excel expert to perform a Chi-Square Analysis on my survey data for a school statistics project. The main focus of this project is data analysis. Please have a strong background in statistics and Excel, with prior experience working with survey data. Your understanding of Chi-Square Analysis is crucial for the success of this project.

I need a skilled Excel expert to perform a Chi-Square Analysis on my survey data for a school statistics project. The main focus of this project is data analysis. Please have a strong background in statistics and Excel, with prior experience working with survey data. Your understanding of Chi-Square Analysis is crucial for the success of this project.

Будь ласка, зареєструйтесь або увійдіть в систему для перегляду деталей.

I'm looking for a comprehensive search for M&A advisory firms across Southeast Asia, specifically in Singapore, Malaysia, Thailand, Indonesia, Philippines, and Vietnam. Key Requirements: - The search should encompass all types of firms: local, international with local offices, and boutique firms. - The information gathered shoul...and boutique firms. - The information gathered should include, for each firm: - Name of company - Contact details - Services offered - Client portfolio - The final output should be a detailed spreadsheet with all the information. Ideal Skills: - Proficient in internet research - Experience in business analysis - Familiarity with M&A advisory firms is a plus - Proficient in Microsoft Excel or similar spreadsheet software. Lookin...

I need help finding high-quality, freely available downloadable dataset/links on consumer behaviour...ready-to-eat or cooked food. Also, I need assistance in creating related questions on which the dataset is based. The datasets/questions should be in Excel format. Key Aspects of Consumer Behaviour to Explore: - Purchase frequency - Brand preference - Consumption patterns - Additional parameters for in-depth analysis Other Considerations: - Demographic information - Spending habits - Product satisfaction - Sustainability considerations - Customer satisfaction The freelancer will also be required to assist in formulating relevant questions based on the dataset. Ideal skills for this project include: - Data analysis - Market research - Excel proficiency - Understanding of c...

I'm in urgent need of an experienced professional who ...Your main task will be to find data on mortgage foreclosures sold within the past 90 days. Key Responsibilities: - Collect data from public records, real estate websites, and county auctions. - Input data into an Excel sheet with a flexible structure. Key data points include: date of sale, foreclosed address, city, county, state, owner name, phone, email, opening and closing bid. - Leave cells blank for missing data. Ideal Skills and Experience: - Previous experience in data collection, particularly in real estate or mortgage foreclosures is preferred. - Proficiency in Excel with a keen attention to detail. - Strong understanding of honesty and accuracy in data reporting. Please do not waste my time if you cann...

...Responsibilities: Format and remediate PDF documents to meet WCAG 2.1 standards. Ensure accessibility compliance for Microsoft documents (Word, PowerPoint, Excel) and export them correctly to accessible PDFs. Use Adobe Acrobat and accessibility tools to add tags, alt text, and fix reading order. Conduct accessibility checks and resolve issues flagged by tools like Adobe Accessibility Checker and Microsoft Accessibility Checker. Key Requirements: Proficiency in Adobe InDesign, Acrobat Pro, and Microsoft Office tools. Strong knowledge of WCAG 2.1 standards and document accessibility principles. Familiarity with assistive technologies such as screen readers (e.g., JAWS, NVDA). Proven experience in document accessibility remediation. Detail-oriented with the abilit...

...PowerBI dashboards and reports. There are about 9 fields from Autotask, 3 from Quickbooks Online, and 4 fields from Excel which I need to have all in one place for analysis. At this point, to start, I'm just looking for customer data - income, expenses, status, and a few other fields both numberical and descriptive Key Responsibilities: - Consolidate data from diverse sources, including Excel files, Google Sheets, Autotask, and Quickbooks Online. - Focus on Financial and Sales data primarily. - Ensure the data is clean, well-structured, and ready for analysis. Ideal Skills: - Proven experience with data consolidation from multiple sources. - Strong proficiency in Excel and working with Google Sheets. - Familiarity with Autotask and Quickbooks Online is a ...

...but they are in separate files. Also, I would like to add one or two features that have not been developed yet. After making it into a single application, make it robust for Chrome extension application takes notes on any webpage. Key Features and requirements: - Assemble the applications into one single robust application for testing. - The primary function of this extension is to save notes, annotations, and bookmarks (already built only a front end). - Any notes, annotations, and bookmarks are displayed on the right-hand side, and any context information is displayed in the left-hand side approximate to the text highlighted or investigated by the user. - Context information 1: Provide a set of recommended papers based on the selected text using genAI (already built). - Conte...

...remote job. MS-SQL database expertise is required. The office hours are from 9 A.M. to 6 P.M., and lunch is complimentary. The project involves: - Implementing new features. - Bug fixing. - Performance optimization. The new features to be added include: - Customizable reports. The level of customization for the reports includes: - User-defined filters - Customizable layouts - Export options (PDF, Excel) Ideal candidates should have: - Extensive experience in raw PHP - Proven track record in developing reporting panels - Ability to work under pressure and meet deadlines - Excellent problem-solving skills for bug fixing and performance optimization - Experience in implementing new features in a timely manner - Skills in developing customizable reports - Familiarity with creatin...

I'm in need of a data entry professional adept at handling mixed data types - both text and numeric. The task involves gathering this data from various websites and compiling it into a CSV file. Key Requirements: - Proficient in data entry with a keen eye for detail - Experience with collecting data from websites - Able to handle mixed data types - Skilled in formatting data into a CSV file Ideal freelancers for this project should have a demonstrated track record of data collection and entry, with the ability to accurately transcribe and format data from diverse web sources.

...Overview: Looking for a Python developer to create a YouTube channel caption extraction bot with specific requirements for handling large-scale video processing. Project Requirements: Create a bot that processes YouTube channel video pages (e.g., @TheCookingFoodie/videos) Core Functionalities: Process all videos from a channel's video page Extract and save: Video titles Video URLs Closed captions (CC) Save data in text files named after each video Process videos chronologically (oldest to newest) Handle 1000-2000 videos per channel Technical Specifications: Language: Python Implementation using Python requests or YouTube-specific libraries Error Handling Requirements: Handle video page loading failures with refresh capability Log videos without CC to Implement robust

I need an Excel report that handles financial data, including expense tracking, revenue generation, and profit and loss analysis. The report needs to have interactive features such as pivot tables and interactive charts. Ideal Skills: - Proficiency in Excel, particularly with pivot tables and creating interactive charts - Experience working with financial data - Ability to create comprehensive and easy-to-understand Excel reports

I'm looking for someone to complete an excel spreadsheet with financial data sourced from various company websites. This project will primarily involve researching and collecting data related to property purchase prices, monthly rent amounts, lease start dates, and lease lengths. Ideal candidates for this project should: - Have experience with data collection and Excel - Be detail-oriented and able to work independently - Have a basic understanding of financial metrics and real estate - Be able to source reliable data from company websites Please provide examples of similar projects you have done in the past.

I'm looking for an experienced data analyst or Excel specialist to create a dynamic spreadsheet for me. I have sales data from 5 stores, and I want a spreadsheet that I can upload weekly sales into. This spreadsheet should calculate: - Weekly and monthly running totals for items sold per store - Total sales across all 5 locations The data points I have include: 1. Date of sale 2. Item 3. Transaction number 4. Price sold at 5. Store # If a customer buys 3 of the same item, it will give me 3 separate lines of data (i.e., all sales listed are quantity of 1). I will be uploading my data weekly through a CSV file into Microsoft Excel. The spreadsheet needs to be able to generate the following reports: - Weekly total sales - Monthly total sales - Item-wise sales pe...

I need assistance with finding product codes (SKU and size in either US or EUR and link for a proof) for 4100 EANs. The data should be sourced from Google or 1 another website , VERY easy because 2 /3 brand only Key Requirements: - Data processing and research skills - Experience with Excel/CSV - Ability to follow a specific format for data input I will provide the EANs in a spreadsheet (Excel/CSV) and I already have a format for the SKU and size. This is a straightforward project that requires basic data input and online research. Please be prepared to work meticulously and efficiently.

Будь ласка, зареєструйтесь або увійдіть в систему для перегляду деталей.

I'm looking for a research assistant who can help me collect and analyze both quantitative and qualitative data fo...research assistant who can help me collect and analyze both quantitative and qualitative data for an academic project. Key Responsibilities: - Data Collection: Gather both quantitative and qualitative data relevant to the research. - Data Formatting: Organize and prepare the collected data in Excel/CSV files and Word documents. - Data Analysis: Analyze the data to extract meaningful insights. Ideal Skills: - Proficient in data collection and analysis - Experienced in academic research - Skilled in using Excel and Word - Capable of working with both quantitative and qualitative data. Please, only apply if you're experienced in academic rese...

Key features of your custom CRM 1. User management: • Role-based access for administrators, team members and other user groups. • Secure login and tracking of user activity. 2. Leads and Opportunities Tracking: • Centralized dashb...to assign tasks and leads to team members. 3. Workflow Automation: • Automate repetitive tasks like follow-ups, reminders, and approvals. 4. Communication: • Integration with email, messaging or telephony systems for seamless communication. • Notification system for important updates. 5. Reporting and Analysis: • Customizable dashboards to track key metrics. • Exportable reports (PDF, Excel) for performance reviews. Depict corporate structure: Main business can have multiple subsidiaries, and eac...

...for predictive analytics and the virtual assistant. 2. Develop advanced dashboards and reporting tools. 3. Optimize the system for scalability and high traffic. ________________________________________ Monetization Strategy: 1. Subscription-based pricing with tiered options (e.g., per-student, annual, or termly). 2. Transaction fees for integrated payment solutions. 3. Paid premium features such as AI analytics and advanced reporting. ________________________________________ Competitive Advantage: 1. Scalable architecture supporting multiple schools under one organization. 2. Advanced AI capabilities for predictive insights and virtual guidance. 3. Seamless third-party integrations with LMS, payment gateways, and more. 4. User-friendly interface with mobile responsiveness. 5. Rob...

I'm looking for a skilled Visual Basic programmer who can help me develop an Excel macro. This macro needs to automate data entry tasks in a spreadsheet. Key Responsibilities: - Develop an Excel macro using Visual Basic. - The macro should be capable of automating repetitive data entry tasks. - Ensure the macro is user-friendly and efficient. Ideal Skills: - Proficiency in Visual Basic, particularly in creating Excel macros. - Experience with data entry automation. - Excellent problem-solving skills and attention to detail.

I'm looking for a professional to compile an extensive list of exhibitors from the Fitur trade show. This list will need to be more than 200 exhibitors and should include: - Company name and contact details - Product or service offerings - Booth number and location The final data should be delivered in a Spreadsheet (Excel/CSV) format. Ideal skills for this job include: - Attention to detail: It's crucial that the information recorded is accurate. - Proficiency in Excel: The final product should be well organized and easy to understand. - Research skills: You may need to look beyond the official exhibitor list to get a comprehensive view. Experience in data compilation and familiarity with trade shows will be an added advantage.

I'm in need of a freelancer who can compile a list of exhibitors from Fitur 2025. This list should be formatted in Excel and include: - Company Name - Exhibitor's Country - Email - Phone Number Please note that this list should be sourced from other trusted sources, not the event's official website or a public directory.

export csv file for tnt italy

I'm seeking a professional to clean up my CSV file, which contains keywords. The data requires moderate corrections for misspellings and the removal of non-alphabet characters while keeping the rows intact. Ideal Skills and Experience: - Proficiency in data cleansing - Experience with CSV files - Attention to detail - Good understanding of English spelling and grammar - Ability to identify and correct moderate misspellings Both attached spreadsheets are lists of keywords for google ads campaigns. I need to removed any NON-alphabet characters in the keywords between the [ ] symbols. It should just be a keyword phrase between the brackets. (nothing else) example characters to be removed !#$&^*(?" or anything else including a "square root" symbol. ...

I need a dashboard that visualizes and organizes the errors found in the List 1 and List 2 tabs of my Excel file. The goal is to track missing or blank cells within the data. The dashboard should include charts and graphs to clearly display the error data. Additionally, it should feature a mini database section with filters, showcasing the missing data headers and cell references for quick identification and navigation.

I'm looking for an expert in Tableau, specifically for creating interactive dashboards. The data will primarily come from Excel/CSV files, so proficiency with these sources is essential. Ideal Skills: - Extensive experience with Tableau - Proficient in working with Excel/CSV files - Ability to design interactive charts and graphs The dashboard should feature interactive charts and graphs. I'm not looking for a static, one-dimensional dashboard; I need something that can engage users and allow them to explore the data on their own. If you have a proven track record of creating such dashboards and can deliver a high-quality, user-friendly product, I would love to hear from you. My cost is 10USD