Excel macro merge files folderpráce

pasar informacion a excel. pasar informacion a excel

Pro pracovní projekt potřebuji zajistit webscrapping jedné webové stránky (nejlépe pomocí Octoparse) vytvoření dvou relačních databází (malé datové sety, jedny jako výsledek webscrappingu, druhé dvě Excel tabulky) pomocí SQL, včetně jednoduché prediktivní analýzy, a grafické zobrazení dashboardu v Power BI. Dat je málo, tedy věřím, že pro zkušeného datového analytika je to práce max. na pár hodin, mně to však velmi pomůže.

...nebo Redisu. Pokud umíš i JS, můžeš nám pomocí s vývojem ve Vue.js, TypeScript nebo ExtJS, ale není to nutnost, hledáme i čistě backenďáky. Na messaging používáme RabbitMQ, verzujeme v GITu, testy (Codeception) a statickou analýzu kódu spouštíme v Gitlabu. Pro napojení partnerů provozujeme API všeho druhu (REST, XML, SOAP), které dokumentujeme v Postmanovi. Úkoly evidujeme v Redminu, code review a merge requesty v Gitlabu. Docker pro lokální vývoj - v budoucnu i na produkci. Proč pracovat s námi? Vyjdeme ti vstříc v práci i v osobním životě, abys mohl/a skloubit práci, rodinu, zábavu a ...

Par hodin prace s kontingencnimi tabulkami ve dvou souborech Excel.

Jedná se o vytvoření ekonomických posouzení investic do realit. Po vzájemné dohodě dojde k zadání základních parametrů a informací, které je zapotřebí posoudit pomocí ekonomických ukazatelů jako jsou IRR, CASH FLOW, YIELD, ROI, ROE. K tento činnosti je nutné perfektně ovládat Excel a mít vzdělání ekonomického zaměření ideálně se zaměřením na realitní trh a investice na tomto trhu.

Krátkodobá a dlouhodobá půjčovna elektromobilů: - Datábáze vozidel (současná evidence v excelu) - Databáze zákazníků (CRM) - Automatizované vytváření dokumentace: smluv, předávacích protokolů, fakturace, pojistných smluv a jejich následné zálohování. Současně používáme Excel a Word. Cíl je mít centrální přehled a systematičtější postup. Ideálně i jako cloudové řešení.

...melo fungovat (hlavni funkce): - Vytvorim a nahraji sablony (word, excel, powerpoint nebo text dokument) do te appky na Salesforce. Tento template ma takzvane merge policka. Tj. kod, kterym si zakaznik bude moci vytvorit libovolny template a dat tam vzdy to policko ze Salesforce, ktere potrebuje, aby se mu ukazalo na finalnim -dokumentu - Zde jsem schopen spravovat ruzne sablony, rozhodnout se, jaka bude finalni podoba dokumentu (pdf, word nebo jine), dat dokumentu jmeno, kde muzu vlozit auto datum, policka ze Salesforce atd. - Jako druhy krok by melo prijit spojeni techto merge policek s policky v Salesforce (aby system vedel, odkud informaci brat) - Toto musi byt flexibilni, tzn. muzu si vytvorit nekolik variant propojeni merge policek s polickami v -Sale...

datae

datae

Pro účel vyúčtování potřebuje naše firma macro, které bude kontrolovat platby a jejich zdroje. Macro by také mělo identifikovat transakce, které buď nejsou spojené s žádným prodejem, nebo jsou nějakým jiným způsobem problematické. V příloze je vzor zdrojových souborů: report z našeho systému, výpis transakcí z paypalu, výpis transakcí z bankovního účtu. V případě zájmu/ dotazů mne neváhejte kontaktovat. Strobl

mise en forme

Dobrý den, potřebuji naprogramovat makro dle zadání v Excel příloze. Chtěl bych to rozložit na 2 části. 1: dle zadání v excelu 2: později po domluvě dodělat výstup na tiskárnu etiket

Napraviti Excel VBA program

...details into a spreadsheet. Responsibilities: -Conduct basic research to locate contact information for 25 specified agencies. -Validate that email addresses are current and active. -Accurately enter all data into a provided spreadsheet format. Requirements: -Experience in data collection and validation. -Proficiency in basic research and use of spreadsheets (e.g., Google Sheets or Microsoft Excel). -Ability to deliver accurate results within a set timeframe. -Project Length: Short-term, estimated completion within one week. ( MAX 80 AUD as a test round, if the work is good, Larger jobs will come) Application Instructions: Please message me with the keyword "VSL" at the beginning of your application to confirm that you have fully read and understood the job desc...

I need an Excel 365 PowerQuery or VBA script that can fetch daily market data and handle potential data source interruptions or changes. Google Shhets example =INDEX(IMPORTXML("" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). <Where C31 = Cell containing the Stock eg GB00B8XYYQ86, LU1033663649 or GB00B0CNH163 I need an identical function in MS365 Excel - either with PowerQuery OR VBA (preferable) Ideal skills: - Proficiency in Excel 365 and PowerQuery and VBA - Experience in web scraping and handling dynamic data sources. I am after a fixed quote for this project.

** Please do not apply. If you don’t meet the must have criteria at the beginning of this job description post. We are looking for a motivated and successful grant writer located within Canada! The grant writer will be responsible for locating, researching, and applying for potential funding opportunities in order to ensure successful grant app...research, and the ability to distinguish and identify Ontario/Canadian Grant opportunities • Ability to work effectively under pressure; • Excellent writing and verbal skills; • Be highly organized with the ability to implement systems and follow-up processes; • Proficiency in research, interpreting, and analyzing diverse data; • Excellent Computer skills (Microsoft Office Word, Access, PowerPoint and Excel),...

I'm seeking a professional able to create a custom CRM system in Excel for my business. Key requirements: - Sales Tracking: I need a system that allows me to monitor sales performance and forecast future sales. - Task Management: The CRM should have a task management feature to help me organize and prioritize my daily activities. Additional details: - The system will be used by a small team of 1-10 users, so it needs to be user-friendly and easy to navigate. - No integration with other software or platforms is needed at this time, so the focus will be solely on creating a robust, efficient Excel-based CRM. Ideal skills and experience for this job would include: - Proficiency in Excel, with a clear understanding of how to create complex formulas and visual repre...

...scraping and data collation. The project will involve scraping blog articles in HTML format and compiling desired information into an Excel file. Key Project Requirements: * The extraction will be from specified URLs, using their individual patterns for efficient and accurate scraping. * For each blog article, I need the title, the full text, and the publish date extracted. * This scraped data must be properly arranged in an Excel file for easy analysis. * List of articles is here: Ideal Candidate Expertise: * Proven experience in web scraping is a must, preferably with full understanding of HTML structures. * Proficiency in Excel and data organization. * Attention to detail to ensure accuracy of the scraped data. * An understanding of URL patterns would be adva...

I have a VBS script which downloads files from a server to the a folder on my local machine or onto AWS (MS Win Server 2012 R2). This script can be manually activated (double click) or via Task Scheduler. Recently the script stopped working. I think it has to do with AWS permission/read/write errors. I need to have this investigate and fixed. The person needs to understand AWS EC2 and VBS and JS scripting.

...is looking candidates for Senior Business Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 200 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good Technical knowledge of VBAs, Mac...

I'm in immediate need of a cloud-based stock management software with barcode generation, scanning, stock quantity tracking, and weight measurement functions. The system should enable me to: - Generate and scan barcodes...- Measure the weight of my stock in grams I prefer a cloud-based solution that can be accessed and updated from any internet-connected device. The software should have an easy to use interface and be able to: - Enable manual entry of stock data - Support updating stock information by scanning barcodes - Automatically update stock data from my sales records The software could be developed in Excel, as long as it's accessible online. As a freelancer, you should have experience in developing similar solutions and a deep understanding of stock management ...

I have previously worked code in and stored but it stopped working because readyPromise doesn't work and in that case, it can't load sequently...and in that case, it can't load sequently and crashes. New Java stuff?? It doesn't recognize readyPromise with var/const only works as await. Async has problems too. Even without Crashing tilesets seem not to load both from ION and Private/Public Domain. Need to solve this ASAP. You need to download files and work within your Domain or IDE or any other way to work directly with CESIUM LIBRARY!!!!! Or I will give you my Domain FTP access to the project folder and you can Upload .js .html files and see RESULTS in this directory as it will load html and js: YOU HAVE TO WORK WITH CESIUM LIBRARY!!

I need an Excel sheet created with the primary purpose of data analysis. This sheet should have the following features: - Data Sorting and Filtering: This is crucial for making the analysis process efficient and easy to navigate. I need the sheet to be able to handle large amounts of data and allow for quick and convenient sorting and filtering. - Data Visualization: In addition to the data analysis, I also require the sheet to include line graphs. I believe that visualizing the data will make it much easier to understand and interpret. The ideal freelancer for this project is someone with a strong background in Excel and experience in creating data analysis tools. It is important that the final product is user-friendly and has a clean, professional appearance.

I'm in need of a freelancer to assist with data cleaning from PDF documents. The task involves organizing the data into an Excel spreadsheet. Ideal skills for this role include: - Proficiency in data cleaning techniques - Strong attention to detail - Proficient in Excel for organizing data - Previous experience in similar data entry tasks

I want to scrape daily leads from LinkedIn Jobs, Indeed Jobs, , etc. The task involves extracting data from these job sites and exporting it to Excel sheets. It would be preferable to have some kind of automation that reduces human dependency in obtaining leads every day. If someone has already set up a similar process before, I would prefer that. Preference will be given to those who have previously performed lead extraction tasks for recruitment websites.

I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-friendly interfaces for Exce...

tengo libros excel que tienen diferentes planillas, son registros de notas de estudiantes, pueden ser varias hojas del libro excel, quiero poder transferir esa informacion a hojas con el mismo diseño en gsheets, y viceversa, lo que ponga en excel quieor que se envie a gsheets, y lo mismo de gsheets, puedo tener varios libros excel, cada uno con diferentes datos, quiero que cada libro excel y gsheets sea individual referente otro, y que se almacenen en diferente cuenta de correo electronico. adjunto imagen de referencia de una hoja del libro en excel. quiero saber cotizacion, manera de hacerlo, que se requeriria por favor. una de las ideas, seria desarrollar una app android que funcione como plantilla, que al tener la direccion de un libro...

I have four pictures of my parents that I would like to merge into a single photo frame design. The final design should be in black and white with a thin frame. The frame size should be 11 inches in height and 14 inches in width, and the photos should fade into the background from the shoulder upwards. Ideal skills and experience for this project include: - Graphic Design: Experience in creating custom photo frames is essential. - Photo Editing: Proficiency in black and white photo editing and blending photos seamlessly. - Understanding of visual composition and aesthetics. - Ability to work with specific dimensions and design requirements. Please submit your portfolio of similar projects if available. Looking forward to working with a talented and creative individual on this proj...

Help me publishing an Net6+ReactJs Project to IIS More details: Which version of Windows Server are you using for hosting the application? Windows Server 2012 Can you describe the specific problems or error messages you receive when attempting to deploy to IIS? SPA not launching when p...me publishing an Net6+ReactJs Project to IIS More details: Which version of Windows Server are you using for hosting the application? Windows Server 2012 Can you describe the specific problems or error messages you receive when attempting to deploy to IIS? SPA not launching when publishing to server folder: https//localhost:44321 works Have you ensured that the necessary files and dependencies for your React app are included in the published folder? Yes, I have checked and all nece...

...assistance in integrating image links into two Excel sheets containing a total of 620 and 46 product entries for my Shopify store. Each entry includes links to the official websites where the products are sold. The task involves creating a new column labeled Images in both Excel sheets and inserting corresponding image links. This integration is crucial for ensuring that when uploading a CSV file to Shopify, each product will display its respective images seamlessly. Project Details: Scope: Adding image links to Excel sheets for 666 products in total. Task: Create a new column labeled Images in each Excel sheet and insert corresponding image links for each product. Requirements: Image links should open the respective product images when clicked. The CSV fi...

Complete Excel Analytical and Descriptive Analysis on provided dataset by Friday 4 pm

...present the results in a detailed, report that relates to each hypothesis for my thesis research. The analysis is expected to be done using Excel analyses then further descriptive analysis is needed, focusing on summarising the main characteristics of the data and how they prove/disprove each hypothesis. This will involve exploring the responses to the survey questions, identifying patterns, trends, and constructing summary statistics. The key deliverable for this project will be as follows: an Excel spreadsheet with... - raw data in one tab (provided for you in the attached excel document) - cleaned data a separate tab (provided for you attached excel document) - your statistical analyses on other separate tabs a Word doc or PDF with... - insights and f...

Hi, I need assistance with installing a Public SSH key on my Linux server. The task focus on a single user who will need to access a specific folder located on the server. Key tasks to be completed include: - Enabling both write and read permissions for this user to that specific folder using its Public SSH Key authentification (without password). - The user should not have "execute" permissions or access to any other folders or areas. - Create a cron that will copy the content from this folder to another every 5min. The ideal freelancer for this job would have extensive understanding and experience with Linux command line, SSH configurations, permissions settings and security principles. Best regards.

I need an experienced freelancer to assist me in typing data from handwritten notes into an Excel sheet. Key Requirements: - Previous Experience: Please include details of your previous work in this area - Handwriting Deciphering: Due to the nature of the data being handwritten, you'll need to have good skills in deciphering handwriting - Accuracy: It's crucial that the information is entered into the Excel sheet with the highest level of accuracy Looking forward to your application.

I have a series of PDFs with text that needs to be typed into an Excel sheet. The data is mainly textual in nature. Key Requirements: - Data Entry: You'll be responsible for accurately inputting the text from PDFs into the corresponding cells in Excel. Ideal Skills: - Proficiency in Excel: You should be comfortable using Excel and have experience with data entry. - Typing Skills: Fast and accurate typing skills are essential. - Attention to Detail: The data needs to be entered accurately to ensure the integrity of the information. - Familiarity with PDFs: Experience working with PDFs is beneficial. Please note, there are no specific formatting requirements beyond accurate data entry.

I need someone who can donaload following datasets, then join them into one and merge into one dataset in COCO format so that it works out of the box if I replace data in attached notebook. Here are the links https://archive.ics.uci.edu/dataset/241/one+hundred+plant+species+leaves+data+set I am interested only in the following plants: Phragmites australis Typha angustifolia Typha latifolia Acorus calamus Iris pseudacorus Schoenoplectus lacustris Nymphaea alba Nuphar lutea Potamogeton natans Hippuris

I have a number of scanned documents that contain financial figures. I need someone to accurately type these into an Excel sheet for further analysis. Key Requirements: - Experience with data typing and analysis in Excel, particularly financial data. - Attention to detail is paramount; precision in typing is crucial for the accuracy of the analysis. - Proficiency in English is a must, as the data will be in English and will need to be accurately transcribed. The ideal candidate should have prior experience in financial data entry and analysis, and comfortable working with scanned documents. Your work will be the foundation for subsequent data analysis, so precision and attention to detail is key.

I am seeking an teacher well versed in Excel 2021 to create a comprehensive intermediate-level course. This course will total between 12-15 hours and will be delivered through both video lectures and interactive exercises and quizzes. Here's an overview of the specific topics the course must cover. • Formulas and Functions • Data Analysis and Visualization • Pivot Tables and Charts • Advanced Functions • Named Ranges • Tables • Charts and Slicers The ideal freelancer for this project will possess strong instructional skills, extensive experience with Excel 2021, and a knack for making complex concepts easy to grasp.

I need assistance with a small-scale copy and paste data entry task. The data is less than 1,000 rows and is in a spreadsheet format. Ideal Skills and Experience: - Proficiency in spreadsheet software such as Excel or Google Sheets - Attention to detail to ensure accurate data entry - Efficiency in copy and paste tasks to complete the job promptly This is Medium Task for 1 day Max and will be Fixed Price of 800RS. We have to Refer the Raw File and Practice test for the Students and will it in the correct format in the Practice Bulk upload

I have code for login trading accound and fetch token data. I need to update more data from the code to my system.I need to collect live data from the web and candle stick, Mins Intervals are in Dropdown box, I can choose any minutes interval, I need you to collect Last 5 candle data from the Excel in the web and other details for each token, I will give token name in the excel, It will automatically display the rows of data. If i chanage time interval it will display those data only. Need ot automate the buy/sell order Note: I dont know about coding, If you install the code and run successfully at my system thereafter I will hire you and release the payment. If you agree this term you will apply this task Budet is 600 INR and Good review, Dont expect more I am not big fish...

I have a project where I need you to work with numbers in an Excel sheet. Ideal Expertise: - Proficiency in data entry - Strong knowledge of Excel - Attention to detail - Ability to maintain accuracy and consistency in data entry - Proven experience in similar projects - Able to meet deadlines Please let me know if this is something you can assist with.

Desenvolvi uma planilha de excel mas estou a necessitar de ajuda para criar duas novas formulas.

I have 3 construction programs currently in Excel that I need to be converted into Microsoft Project. The programs are primarily focused on project scheduling and do not require resource management features. Key requirements: - Convert 3 construction programs from Excel to Microsoft Project - Create interactive Gantt charts with dependencies - No need for resource management features, just the scheduling aspect Ideal skills/experience for this project: - Proficiency in Microsoft Project - Experience in project scheduling and Gantt chart creation - Previous work in construction or similar industries would be beneficial Feel free to ask me if you need any further details.

I'm looking for a detail-oriented researcher to help me gathe...charts can come later. Time is critical - ideally 24 hours. - Sector-wise breakdown: I am particularly interested in the finance/investment sector. Hence, your role will be to provide in-depth insights into the investment figures within this sector. Ideal candidate should have: - Strong research experience - Experience in economics or finance - Ability to analyze & interpret data - Proficient in Excel or data analysis tools - Access and experience with databases including Office for National Statistics (ONS) in the UK /EUROSTAT and STATISTA (paid) for the EU and Investment Association (UK) This project requires a detail-oriented, problem-solving researcher. The figures/charts should all be referenced with t...

I require a meticulous professional to help transfer text data from a series of printed documents into an Excel sheet. There's no special symbols or diagrams at all, just plain text. Ideal Skills and Experience: - Thorough understanding of Microsoft Excel - Attention to detail - Proven experience of working with printed documents - Excellent typing speed with the high level of accuracy The project needs to be completed accurately with consistency and timely manner.

I'm in urgent need of a seasoned expert in Microsoft Excel, particularly in creating financial models with emphasis on cash flow management. The ideal freelancer for this project should have proven experience in constructing similar tools for businesses. Key Areas of Focus: 1. Housemaid Cash Flow Tracker: This spreadsheet will facilitate tracking cash provided to our two housemaids and matching their submitted invoices. With three team members involved, it needs to be straightforward and efficient. 2. Monthly Household Budget Expenses: This spreadsheet will serve as a comprehensive monthly budget for all household expenses, including groceries, Amazon purchases, and payments to other suppliers. I envision a format where invoices and supplier names are listed vertically, with ...

...for an expert in Excel who can assist me with designing a functional cash flow budget. The primary aim of this tool will be to help me track and effectively manage two team members expenses. Key requirements for this project are: - Excellent proficiency in Excel, particularly in designing complex budgets and financial spreadsheets. - Experience creating automated functions within Excel, specifically for totalling expenses. - Ability to create a user-friendly and aesthetically pleasing interface that enables efficient data entry and report viewing. The freelancer would need to provide consistent updates and flexibility for potential adjustments during the process. This initiative is essential for my financial planning and needs to be done professionally. If you...

need a skilled freelancer who is an expert in creating financial formulas in Excel. You'll work exclusively with data I provide. Ideal candidate should have: * Expertise in Excel with a specific focus on financial formulas Ddata will be provided

Hi Sir, I can create the macro as per instruction shared . Thanks Arun

I'm currently facing some issues with my Excel tracker. - The tracker contains a VBA macro file which seems to be causing formula errors and formatting issues. I'm unsure of the exact nature of these errors, but it's clear they are impacting the accuracy and usability of the tracker. I need a freelancer who can review and rectify these issues in the tracker. An ideal candidate would have strong experience with VBA and Excel, able to handle complex formulas and troubleshoot formatting problems swiftly. Your goal is to ensure that the tracker is fully functional and error-free. Experience with similar projects will be a plus.