Excel vba open files in folder one at a timeроботи

Доброго дня! Шукаю фрілансера, хто міг би допомогти час від часу писати коди SQL запитів для SAP B1.

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

Об’єктом автоматизації є електронна записна книжка. Записна книжка дозволяє зберігати коротку текстову інформацію (нотатки) та здійснювати пошук по них. Також, записна книжка може мати кольорові закладки, якими можна помічати нотатки для прискорення пошуку, або дозволяє лишати теги прикріплені до кожного запису. Самі записи також можуть мати назву, яка характеризує їх зміст, що може прискорити перегляд списку всіх збережених нотаток, оскільки при цьому зникає необхідність відкривати кожну з нотаток для ознайомлення зі змістом. В тому випадку, лише назва буде показуватися у загальному переліку, яка будучи лаконічною та значно коротшою за вміст нотатки, швидко дозволить ідентифікувати шуканий запис. Як варіант розширеної функціональності, записи можуть містити прикріплену інформацію фо...

Об’єктом автоматизації є електронна записна книжка. Записна книжка дозволяє зберігати коротку текстову інформацію (нотатки) та здійснювати пошук по них. Також, записна книжка може мати кольорові закладки, якими можна помічати нотатки для прискорення пошуку, або дозволяє лишати теги прикріплені до кожного запису. Самі записи також можуть мати назву, яка характеризує їх зміст, що може прискорити перегляд списку всіх збережених нотаток, оскільки при цьому зникає необхідність відкривати кожну з нотаток для ознайомлення зі змістом. В тому випадку, лише назва буде показуватися у загальному переліку, яка будучи лаконічною та значно коротшою за вміст нотатки, швидко дозволить ідентифікувати шуканий запис. Як варіант розширеної функціональності, записи можуть містити прикріплену інформацію фо...

Об’єктом автоматизації є електронна записна книжка. Записна книжка дозволяє зберігати коротку текстову інформацію (нотатки) та здійснювати пошук по них. Також, записна книжка може мати кольорові закладки, якими можна помічати нотатки для прискорення пошуку, або дозволяє лишати теги прикріплені до кожного запису. Самі записи також можуть мати назву, яка характеризує їх зміст, що може прискорити перегляд списку всіх збережених нотаток, оскільки при цьому зникає необхідність відкривати кожну з нотаток для ознайомлення зі змістом. В тому випадку, лише назва буде показуватися у загальному переліку, яка будучи лаконічною та значно коротшою за вміст нотатки, швидко дозволить ідентифікувати шуканий запис. Як варіант розширеної функціональності, записи можуть містити прикріплену інформацію фо...

Об’єктом автоматизації є електронна записна книжка. Записна книжка дозволяє зберігати коротку текстову інформацію (нотатки) та здійснювати пошук по них. Також, записна книжка може мати кольорові закладки, якими можна помічати нотатки для прискорення пошуку, або дозволяє лишати теги прикріплені до кожного запису. Самі записи також можуть мати назву, яка характеризує їх зміст, що може прискорити перегляд списку всіх збережених нотаток, оскільки при цьому зникає необхідність відкривати кожну з нотаток для ознайомлення зі змістом. В тому випадку, лише назва буде показуватися у загальному переліку, яка будучи лаконічною та значно коротшою за вміст нотатки, швидко дозволить ідентифікувати шуканий запис. Як варіант розширеної функціональності, записи можуть містити прикріплену інформацію фо...

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

Потрібно витягнути інформацію з веб сайту, щось на подобі жовтих сторінок. Могу сделать всё что угодно!

Transfer news websites advertising texts...

Вітаю. Потрібна допомога з сайтом на маженто. Відновлювали сайт з старого хоста, де зломались жорсткі диски. Все перекинули на новий але сайт не був запущеним. Чи є у вас можливість глянути на сайт?

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

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

Написати скрипт. Нам треба ввести на сайті дані - дату народження і номер справи, номер втрачений. Потрібно , щоб програма добавляла одиницю починаючи з 1-ин до 50 000 і зафіксувала момент , коли номер зійдеться з датою народження, в цей момент відкриється наступний крок на цьому сайті.

I need an expert to create Power BI slides for data analysis. - The primary objective is to assist me in analyzing the data from excel spreadsheets efficiently. - The slides are intended for basic data analysis. Therefore, the level of interactivity required is basic, encompassing features like tool tips and basic filters. Ideal candidates should have: - Proficiency in Power BI for data analysis. - Proven experience working with Excel spreadsheets. - The ability to create easy-to-understand visuals. - Good communication skills to understand the requirements and deliver the project urgently.

...for an expert to assist in creating a dynamic Power Bi dashboard. This job should revolve around integrating data from Excel spreadsheets and designing a variety of data visualizations. Key Responsibilities: * Guide me in creating the dashboard on my company account. * Connect the Power Bi dashboard to Excel spreadsheets as the primary data source * Develop compelling data visualizations using pie charts, line graphs, and bar charts * Configure the dashboard to refresh data on a weekly basis Ideal Candidate: * Strong experience with Power Bi and data analysis * Proficient in handling Excel data * Expertise in creating different types of charts * Ability to work with time-based data refreshing schedules ...

I'm in need of a skilled Power Apps developer to create a custom business application with the following features: - Image Capture and Upload: The primary function of the app is to allow users to take pictures using their device's camera. - Integration with OneDrive: The images taken should be uploaded directly to a specific folder in OneDrive. - 4 Different Upload Buttons: I'd like the app to have 4 distinct buttons, each triggering the camera function on the end user's phone for specific image captures. Needs to be compatible with both Android and iOS devices. No app needed just a Link to be able to be sent to clients. Ideal candidates for this project should have: - Proficiency in Power Apps development - Exp...

I'm in need of a skilled Machine Learning Engineer who can develop modules to help analyze the real-time electricity consumption for a variety of devices in our system. Backend: Key Points: - Devices to be analyzed include air conditioners, lights, and simple motors and other simple devices. - The analysis should cover both the collective consumption of groups of devices and the individual consumption patterns of each device. Ideal Experience: - Strong background in Machine Learning, ideally with experience in real-time data analysis. - Previous work in energy consumption analysis or similar fields would be a huge plus. - Proven track record in developing ML models for group and individual level analysis...

Content and photos ready. Must me mobile responsive. One page of content, 4 photos. Generic information that applies to all listings. Same description will be used on all listing. Description will not contain product information.

I need a proficient Python expert to scrape recipes from a designated website to an Excel sheet. The project needs to be completed as soon as possible. You can use this open-source working scraper Key requirements: - Scraping recipe information (name, ingredients, cooking instructions, nutrition facts) from a specific website. - Outputting the scraped data in a well-organized Excel sheet. Ideal skills for this project include: - Proficiency in Python for web scraping. - Familiarity with scraping data from websites. - Excellent organizational and data management skills for outputting the data in Excel. If you can deliver this quickly and efficiently, please feel free to bid.

I am looking to fill a longterm editor position for multiple projects for my agency. I am running a short-format content agency that edits videos for various coaches, businesses and podcasts. *The videos are up-to 60 seconds long and I expect you to edit subtitles, b-roll, stock footage, dynamic motion/graphics and make the video in general: entertaining and highly engaging.* *I am looking for a person that can be my full time editor for the next 6-12 months with the possibility of consistent pay-raises when the agency experiences growth.* *You will be paid 7usd for every video-edit.* *The process is super streamlined.* *All videos are tailored by me -> you get the raw footage, edit it and upload the edited videos in a separate fo...

This is a one day project. I will provide a spead sheet to be formatted in excel. Debits and credits will be separated and sumed that easy 24 months are involved the files email for additional information.

Project Overview: We are looking for a talented web developer or development team to transform our Excel workbook into a dynamic subscription-based web application. This workbook is integral to the operations of multiple educational institutions, featuring data management, automated calculations, and reporting capabilities. Project Goals: Seamless Transition from Excel to Web: Convert all functionalities, including complex formulas and VBA macros, from the Excel workbook into a web-based application. Robust Subscription Management: Develop a modular subscription system that allows for easy updates and the addition of new features. Future-Proof Architecture: The application should be built with scalability in mind, allowing fo...

I just need someone to open these files in 3ds max and save them as max2021, nothing else. I'll consider it a favor. Thanks in advance.

I'm in need of a professional who can create DXF files for laser cutting on acrylic material. The designs are focused on geometric patterns. Key requirements: - Creation of DXF files for laser cutting on acrylic material - Designing geometric patterns. Ideal skills and experience: - Proficient in CAD software, particularly in creating DXF files. - Previous experience in designing geometric patterns. - Understanding of material-specific design considerations for acrylic.

I'm in need of a proficient developer to build me a simple QuickBooks online application. This application should be geared towards triggering real-time dispatch of event data on items/products inventory to a webhook like Zapier. Below are the specific requirements: - Dispatching of Item Names, Quantities, and Prices: The application should be able to send all item/product data particularly item names, quantities, and prices from QuickBooks to Zapier. - Real-Time Data Dispatch: The application should be able to dispatch this data in real-time to ensure high responsiveness and accuracy of data. Ideal skills and experience: - Demonstrable experience in creating QuickBooks integrations - Familiarity with Zapier webhooks - ...

I'm in immediate need of a dedicated and dynamic Virtual Assistant to support my growing needs. The ideal candidate will be someone who thrives in managing multiple tasks efficiently and possesses a keen eye for detail. Your main responsibilities will include: The budget is 100 USD a month. ( 6 hours a day, 6 days a week ) - Managing my emails with the utmost discretion and organization. - Scheduling appointments, ensuring I never miss an important date. - Conducting data entry tasks with accuracy. - Performing internet surveys to gather valuable information for projects. - Preparing ad-hoc reports based on collected data and research. Required Skills and Experience: - Proficiency in Microsoft Office Suite, especially in...

...need an Excel expert to help me with my spreadsheet. My spreadsheet has some formula errors that need to be fixed. The spreadsheet is not very complex; it mainly contains simple formulas and calculations. Ideal skills for this job: - Strong understanding of Excel formulas - Experience in fixing formula errors - Attention to detail After the fixes, I plan to use the spreadsheet for daily operations. I need help to fix the column titled "Total Shifts" and the row titled "TOTAL" - Both of these are not calculating the correct numbers when a selection is made from the dropdown lists in the table. I also want a report creating which will tell me how many of each shift type in that week the employee has done i.e if they ...

Need a one pager designed for my company .

Los datos se los tiene en un archivo de excel, son recetas de cocina y la lista de productos (ingredientes), necesito generar una nueva receta según el pedido del cliente, y consolidar en una tabla la cantidad de productos total y el costo de cada producto (este dato se obtiene del portafolio de productos) que se necesita comprar para la preparación de todas las recetas

I'm thrilled to be pursuing an exciting opportunity as a Sales Executive at Tidsol. As a novice in the sales industry, my focus has been in the tech products area. This targeted specialization could offer a perfect fit for Tidsol's objectives. The ideal candidate will exhibit a keen interest, a foundational experience in sales, and strong knowledge of selling tech products.

One-week contract - 2 videos per day

I'm seeking a seasoned developer well-versed in C# and Selenium to create a bot to facilitate automation on Facebook Marketplace. The bot that I'm envisioning would need to perform the following tasks: - Can use multiple accounts, log into several accounts to enter automatic Facebook marketplace listings or Facebook group posts, logged in accounts are saved and can be opened without re-entering the password - Autopost Facebook Marketplace Create Product Title, product description, Product Category, Product Condition, location and product price range, Product Availability, Product Label / Keywords can be separated by commas, SKU Only We Can See. After inputting, you can automatically select a location, especially for the Indonesian region. - Can...

Perform an in-depth sensitivity analysis of a Pressure Swing Adsorption (PSA) process for CO2 capture using zeolite 13X. Scale up a CO2 capture system from a small-scale experimental study detailed in the attached research paper to an industrial application focusing on a flue gas stream solely made up of CO2 and N2. This comprehensive investigation can be based on specific equations, data, and parameters that will be provided from a relevant paper. Duties and Responsibilities: - Understand the Base Model: Analyze the experimental study to grasp foundational models and calculations. - Industrial Sensitivity Analysis: Utilize any effective method to scale up these findings to industrial levels. - Use MATLAB, Excel, or any other tool t...

Excel Automation of my project and data visualization

I'm in need of an Excel expert who can assist me with data analysis, formulas, and data visualization. The project involves working with a dataset of medium size, specifically, between 1,000 - 10,000 rows. Key requirements for this role include: - Strong understanding of data analysis: The ideal candidate should have a proven track record of analyzing data, preferably in a business context. - Proficient in formulas and calculations: You should be very comfortable with advanced Excel formulas and calculations. - Data visualization skills: The ability to present data in an easily understandable and visually appealing way is crucial for this project. Specific functionalities and tools that need to be utilized include: - Pi...

I want a simple platform using APIs and web sockets to collect real time data and calculate the values and show in the form of heatmap using plotly heatmaps. I need 4 features. Liquidation heatmap, order book, net position heatmap and liquidation level. Please read attached requirements before sending a bid. And please quote actual amount

I need assistance with a one-time data entry task into Microsoft Excel. The volume is less than 100 entries. Ideal Skills: - Proficient in Microsoft Excel - Attention to detail - Strong data entry skills Please note that the data needs to be accurately entered and organized in the Excel sheet. The project shouldn't take more than a few hours for someone with good data entry experience.

Job Description: We are seeking a skilled Freelance Full Stack Developer with experience in AI technologies, web development, and data processing to build an automated pipeline for creating AI images. The successful candidate will be responsible for developing a complete solution that includes trend analysis, automated prompt generation, integration with image generation APIs (such as DALL-E, Stable diffusion and MidJourney), backend infrastructure setup, and frontend design. Responsibilities: Trend Analysis: Implement a system to analyze and extract trends from Google searches stored in an Excel file. Prompt Generation: Develop an automated system to convert trend data into creative prompts suitable for image generation APIs. API Integration: Co...

I'm looking for a data expert to merge two sets of data from Excel spreadsheets. The combination should be based on a unique ID field that is generated using fields common in both datasets. Here are the key details: - Data Type: Both data sets are in Excel format. - Merging Output: The final result should be a new Excel spreadsheet. - Matching Fields: There are common fields present in the two datasets that should be used to generate a unique ID for matching. -Filter: There are records that will not be used, but they are easily identified by a unique, consistent value The ideal freelancer for this project should: - Be proficient in Excel and capable of handling small datasets. - Have experien...

We need to create a plugin that will handle the matching of products with the specific types of cars. The types of cars are actually the combination of the following data: CarTypeId - Maker - Model - Year - RoofType Their relationship should be many-to-many, so we probably need a middle table that contains their combinations CarTypeId - ProductSKU The above is just a suggestion and additional columns or different implementations can be used. The plugin should implement the following: DATA Import: A way to import data from Excel file (example file attached). The import file might contain data for many SKUs and should overwrite the data of every specific SKU. As a result all the matching of Cars to SKUs is actually done in the Excel f...

I need a reliable person to help me with a project that involves voting on a website. I'm looking for someone who can use automation tools to do the voting. Key requirements include: - Expertise in using automation tools for website voting - Ability to work consistently until the project deadline - Proficient in setting up and using a real-time dashboard to track the voting progress I'm not exactly sure about the security measures involved. If you have experience in bypassing common security measures like CAPTCHAs or IP rate limits to automate voting, it would definitely be a plus. Please reach out if you have the required skills and are available to help me until Sunday 11:59pm.

I am looking for a Shopify + Wordpress developer with specific expertise in custom theme development. The ideal candidate will have experience in the US time zone and be available for full-time work. Specific requirements for this project include: - Custom theme development for Shopify - Familiarity with app development for Shopify - Store setup and configuration Industry experience is not a requirement for this project, any industry experience is acceptable. In order to separate spammers from real candidates, if you agree with this statement please write it on top of your bid: "I am available to work in the US time zone and have X hours left available TODAY!" - where "X" is the amount of hours you have ...

Pre-teens are a curious bunch, teetering between childhood wonder and teenage independence. Museums, with their vast collections and interactive exhibits, can be the perfect playground to ignite this curiosity and equip them with valuable life skills. But how do we transform a museum visit from a passive stroll to an active learning experience? This blog delves into life skills activities that pre-teens can engage in at museums, turning a casual outing into a springboard for future success. Unleashing the Inner Communicator: Debate Club in the Dioramas: Museums often have dioramas depicting historical events or ecosystems. Divide your pre-teens into groups and assign them opposing viewpoints related to the scene. Encourage them to r...

Hey, as I have sent you the first draft for the Punjabi song creation, you can reward the first milestone that is 20$. The remaining 30$ would be at the completion of the work

I'm searching for a professional well versed in Excel to help with lookup functions. I'm struggling with finding matching values and retrieving data from different worksheets in a text-based file. Key parts of this project: - Locating matching values across two worksheets - Retrieving needed text data from another worksheet The ideal candidate will have: - Strong proficiency in Excel lookup functions - Experience dealing with data across multiple worksheets - Understanding of text-based data within Excel

Tasks : 1. Construct a queueing model that replicates a week of collecting and processing DNA samples. a. First develop a flow diagram of how the process works, from the reporting of a crime, to the eventual match/no match on the DNA database. b. Identify any conditional aspects of the process, for example if there are any stages of the process where resources only become available once the previous sample has been processed. c. Second, write out the relevant equations associated with each step of the process, and construct a formula for the overall time in system. d. Use relevant notation and write out equations using Equation Editor in Word. e. Note – the rule of thumb is that any reader can pick up your report and rep...

I'm looking for a detail-oriented Excel expert to amend certain elements on my existing spreadsheet. Key tasks include: Data Entry Corrections: - Correcting inaccuracies in data entries. - Rectifying data location errors. Data Reorientation: - Shifting the format from a vertical to a horizontal layout specifically for data values. It would be ideal if you possess a keen eye for detail, advanced Excel skills including formulas, and a proven track record of spreadsheet data management. Experience in handling large copy-paste tasks will also be of great advantage. Due to the nature of this task, a meticulous and systematic approach will be required.

As part of my project, I need an expert in Excel to type data from various digital files into a spreadsheet, ensuring accuracy and efficiency. This data will be utilized for basic data analysis purposes, so it's important that the freelancer is comfortable with working on this type of data. Key Requirements: - Converting data from various digital files (PDF, Word, etc.) into an Excel sheet. - Proficient in using basic Excel formulas and functions to manipulate data for analysis. - Attention to detail and accuracy are critical for this task. Ideal Skills and Experience: - Proficiency in Excel - should be able to work with basic formulas and functions. - Prior experience in data entry or data analysis is a...

am looking for a writer/journalist who can produce news articles based on trending topics we provide. The ideal candidate will have experience in producing multiple stories per day on incoming news. Skills and Experience: - Strong writing skills - Knowledge of current events and ability to research and gather information - Ability to write in a neutral and unbiased manner - Experience in writing news articles - Ability to meet deadlines and produce high-quality work consistently

I'm looking for a skilled developer to create a custom procurement spend analysis dashboard. This tool will help our procurement managers to efficiently track and manage our expenses. Key Data Sources: - Your primary task will be integrating data from Excel spreadsheets and purchasing data from our suppliers. This will provide a comprehensive view of our spending patterns. Key Metrics: - The dashboard should enable real-time tracking of our total spend by category. This will allow our procurement managers to identify areas where costs are higher than expected, enabling them to take immediate action. Primary Users: - The dashboard will be primarily used by our procurement managers. It should be user-friendly and intuitive, allowing for quick and ea...