Macro merge excel files folder sheetงาน

I'm looking for a proficient Excel expert with a strong background in production planning and forecasting. The task at hand involves revising and enhancing an existing production schedule, enabling it to track more complex parameters and deliver insightful reports. In particular, the freelancer will need to: - Incorporate production milestones into the schedule, with these milestones determined by both booked work values and forecasted values. - Integrate a system for tracking production based on specific booked work values, as well as forecasted values. - Use parameters such as Steel in Tons and kg, and Pipe fabrication in Diameter inch for forecasting production. The ideal candidate will have: - Profound knowledge and experience in Excel and its more advanced featur...

I want to re-order some data on a spreadsheet. The picture attached shows you what I need doing. The excel spreadsheet is attached. I'd like the formulas in the spreadsheet left in there, so I can learn how to do it in future!

You should be having a YouTube and a Facebook account. In this project, you will be primarily focusing on entering data into spreadsheets. This job comes with an important responsibility as the data provided must be organized and prepared for analysis. Here's what I'm looking for: - Expertise in data entry work, particularly with Excel. - Strong attention to detail when transferring data. - Knowledge in data analysis; however, no specific analysis method required. - A strong candidate for this job would have prior experience with similar tasks, as well as strong analytical skills to help transfer the data accurately. Here is the task. @VegasMatt/videos Order the videos by latest it will be easier Go through

As we dive deeper into data analysis, an improved visual representation of our findings is required. Consequently, we need someone proficient in Excel and experienced in conditional formatting. Your task will be: - To apply conditional formatting within a certain range on our Excel data. - To highlight values which fall within this range, rather than color coding them. Skills required: - Proficiency in MS Excel. - Experience in conditional formatting. - Attention to detail. We look forward to having a clearer and more streamlined view of our data.

...highly proficient developer with expertise in JavaScript, Excel, and PHP for automation tasks associated with excel sheets. Though specific tasks directly related to JavaScript and PHP scripting were not defined, the focal task is oriented towards developing excel macros specifically designed for sheet automation. Key Responsibilities: - Macro development for excel automation - May also involve JavaScript coding and PHP scripting Ideal Candidate: - A demonstrated history of successful macro development and Excel automation - Solid understanding and command of JavaScript and PHP - Ability to provide a detailed project proposal Please include in your application your relevant experience, your past work particularly relating to ...

...captivating in their own right. What We Need: A Video Creation: A dynamic, game party-themed birthday video that resonates with the theme and feel of the sample video provided. It's crucial that your creation is not a direct copy but rather a unique take that retains the essence of the example. Promotional Images: A series of promotional images that align with the examples in the “promotionalimages” folder attached. These images should complement the video in style and theme, effectively capturing the excitement of a game party. Requirements: Expertise in Canva: You should have a strong portfolio of Canva creations, showcasing your ability to design both static images and videos. Please include your best Canva works with your bid, with a particular focus on ...

Creating an Accounting Excel Sheet and create an automation form.

DONE IN NEXT 3 DAYS Have a folder on Windows PC that outputs an XML file into a specific folder • The file contains customer details and it is temporary file. • It last 10-15 secs and then gets deleted. • Need to build a Vb.net APPLICATION / Windows EXE application that can scan the folder every 5 secs and if there is an XML file it will parse the XML file and insert the data into a local mySQL database • The windows exe must be able to run minimised in the system tray (bottom right hand corner) and consume very little memory • Will also need to confirm names/headings/ labels in APP before finals completion. Also need to all in a logo at the end as well. • Need all the Vb.net APPLICATION Project files – need all the raw ...

I'm seeking a skilled developer to create database or programme to accurately reconcile multiple csv files of data from different time periods into a single spreadsheet. Individual csv files need to be imported to create a single worksheet or report keeping the time period data distinct. The project includes: - Understanding of multiple CSV databases. - Accurate importation of each CSV file into a worksheet report. - Ensuring the integrity of the data during the importation process. Ideally, the candidate should possess: - Strong data analysis skills. - Experience with handling large CSV files. - Proficiency in Excel or similar spreadsheet application with understanding of database structures. - Attention to detail to maintain data accuracy. - Knowle...

I'm in need of a data analyst, capable of performing descriptive statistics and correlation tables, along with two linear regressions using Excel. I aim to identify trends and patterns that will help in improving operational efficiency and bolstering data-driven decisions. • The project involves analysis of data sourced from a Spreadsheet/Excel file. • The ideal freelancer should be skilled in Excel, descriptive statistics, linear regression and data interpretation. • The purpose of the research is not just to understand the current state of affairs but to make strategic decisions for the future. • A background in market research will be beneficial for the project. Your task will be to provide me with a comprehensive report detailing y...

I'm seeking a task-oriented freelancer who has profound knowledge and experience in financial accounting. The predominant pu...seeking a task-oriented freelancer who has profound knowledge and experience in financial accounting. The predominant purpose of my midterm project is to implement various financial accounting concepts. Specifically, these include: - Assets and liabilities - Revenue and expenses - Cash flow and financial statements - General Journal and General Ledger - Trial Balance - Income Statement and Balance Sheet - Statement of SE The ideal candidate would have a solid background in finance or accounting with the ability to effectively and accurately apply these concepts to a project. The ability to communicate these processes clearly will also be highly value...

I'm seeking a skilled web scraper to extract valuable data from Website 1. The data to be extracted includes the company name, address, location, phone number, and email. The priority of extraction should be the phone nu...location, phone number, and email. The priority of extraction should be the phone numbers and emails first, followed by the rest. - Extract information from Website 1 - Prioritize phone number and email extraction - Populate a single Excel sheet with all fields The ideal freelancer for this job should have robust skills and experience in data extraction, web scraping, and Excel. Timeliness and accuracy are of utmost importance. If this sounds like a project that matches your skills, I'd love to hear from you! Need to Extract data from a...

I am looking for a proficient professional who can create an advanced Excel Gantt chart for me that is produced from a table extracted from Salesforce. This would involve: - Incorporating elements of task scheduling and progress tracking into the Gantt chart. - Completing the project within a span of 1-2 weeks. - Breaking down each task on a weekly basis to provide a comprehensive visualization of the project timeline. Skills needed for the job would include proficiency in Microsoft Excel, experience in creating Gantt charts, a good understanding of project management principles, excellent time-management skills and attention to detail. Familiarity with task scheduling and progress tracking would be essential.

I am seeking somebody who can help me set up my social media business platforms & merge them together. Someone who is clued up with booking apps such as Fresha and Booksy and help bring them all together. My skincare business is aimed at the general population. On my social media I share skincare tips, before and after photos and process pictures as well as reels of my treatments to attract more clients. Key Requirements: - Experience in creating user-friendly interfaces - Familiarity or interest in the skincare industry is a plus To help merge my social media business platforms together. Desired qualifications: - A strong portfolio showcasing past work in application development. - Knowledge of skincare industry is advantageous, but not required. By joining us on...

I need a freelancer skilled in Excel who can create a sales tracking sheet for me. My focus is on monitoring the sales revenue of my business. Here's what I'm looking for: - A sheet where sales data can be manually input - A system that can effectively track AR from the customers Ideal Skills and Experience: - Advanced Excel expertise - Experience in data entry - Your role will involve not only creating the system, but also ensuring that it's easy for a person without a technical background to use. I'm hoping that this project can be completed efficiently, with minimal revisions needed.

โปรดลงทะเบียน หรือเข้าสู่ระบบ เพื่อดูรายละเอียด

...take on fantasy romance. **What to Include in Your Proposal:** - A brief overview of your experience in fantasy and romance genres. - Samples of past work that showcase your storytelling skills and ability to capture the essence of fantasy romance. - Your approach to creating enchanting tales within the constraints of a short story format. This project is the perfect opportunity for writers who excel in delivering impactful narratives in a brief format. If you have a talent for creating worlds where love knows no bounds and every sentence is a step into the magical unknown, I invite you to submit your proposal. Let’s create something truly magical together....

Necesito modificar un archivo csv que está alojado en un servidor, modificar mapear etc

I'm seeking a skilled professional who can design an integrated system of electrical and mechanical systems for my home, with a focus on advanced features and efficiency. The project should specifically include: - Design of smart home automation systems, including energy efficient lighting ...- Drafting of plumbing and water supply systems. - Energy-efficient solutions I expect the freelancer to understand the application of Matter technology and smart home customization. A deep knowledge of electrical circuit design, lighting, power outlets, and switches is essential. Experience in creating efficient HVAC and plumbing systems will also be a significant advantage. Your ability to merge aesthetics and functionality while focusing on sustainable, energy-friendly solutions wil...

I need a skilled photo editor to create a unique collage for me. This will incorporate photos of family members (from separate photos), combined seamlessly onto a realistically designed floral garden background. This piece wi...Implement a stunning, realistic floral garden for the backdrop. - Final output: The image needs to be high-quality, suitable for printing. Ideal candidates would have extensive experience in photo editing, specifically in creating photo collages and designing backgrounds. Experience in realistic floral illustrations would be advantageous. I'm expecting a clean, professional output, where all images merge seamlessly as one. Skills in using Adobe Photoshop or similar software are essential. The most important factor is the overall unity and appeal of t...

I am needing someone to create 200 photoshop files created using a template along with questions from a spreadsheet. We have 5 different categories of questions, with 40 questions in each category. Each question will be transferred onto its own card. We already have created the photoshop templates for the 5 different categories. We just need the text transferred and centered on each document. If it would be easier for you, it could be done in Adobe Illustrator instead. Please see the Text Centering to see how we want the text centered. Please see the Text Centering to see how a sample of multiple cards with different amounts of text, all centered properly. Please see the File Naming to see how we want 1 file per card, and how it is to be named by the category

I am looking for an expert in chatbot development who can construct a bot capable of engaging in meaningful discourse based on the contents of differing PDF documents. The chatbot will need to be fully integrated into an existing website, and should excel in suggesting relevant content from PDF files based on user interaction. Major functionalities include: - Ability to parse and understand content from a series of PDF documents - Skilled at suggesting relevant PDF material based on user chat inputs - Capacity to adapt dynamically to regularly changing PDF content Ideal applicants should possess strong skills in artificial intelligence, natural language understanding, machine learning, and web development. Past experience with dynamic chatbot development would be a signific...

I'm seeking an experienced software developer to create a Microsoft Office Add-in or application that could function in Word and Excel. This digital tool should be designed with artificial intelligence capable of recognizing factual and procedural questions within the documents. With a foundation in machine learning and chatgpt, it should be apt in offering answers by analyzing previous documents and accessing website information. I'd like the system to be versatile in its response presentation; it should present suggested answers both within the document and/or in a pop-up window. Looking forward to working with someone who has: - Significant experience in AI and Machine Learning - Understanding of Natural Language Processing for question detection - Proven track recor...

I'm in need of a proficient web developer to construct an e-commerce website with a methodical, corporate design. Key Specifications: ...developer to construct an e-commerce website with a methodical, corporate design. Key Specifications: - Implement e-commerce capabilities, enabling efficient online transactions. - Integrate Skrill as the website's payment gateway. Prior experience with Skrill integration will be highly advantageous. - Execute a professional, corporate aesthetic for the website design. Preference for developers who excel in creating such layouts. Ideal Skills and Experience: - Proficiency in web development - Experience with e-commerce website creation - Familiarity with Skrill payment gateway - Strong track record in creating professional, corpor...

I'm in need of a proficient web developer to construct an e-commerce website with a methodical, corporate design. Key Specifications: ...developer to construct an e-commerce website with a methodical, corporate design. Key Specifications: - Implement e-commerce capabilities, enabling efficient online transactions. - Integrate Skrill as the website's payment gateway. Prior experience with Skrill integration will be highly advantageous. - Execute a professional, corporate aesthetic for the website design. Preference for developers who excel in creating such layouts. Ideal Skills and Experience: - Proficiency in web development - Experience with e-commerce website creation - Familiarity with Skrill payment gateway - Strong track record in creating professional, corpor...

We're a service organization that uses a customer database that can be exported into an excel format that we want our service paperwork to reference and auto-populate in specific text fields. Any changes in the spreadsheet need to be reflected in the service form PDFs. So, we're in need of a competent developer experienced in Excel, PDF manipulation, and integration. Your task will be to create functional PDFs with formulas that reference my Excel spreadsheets. Key Aspects: * Proficiency in using Microsoft Excel * Expertise in Lookup and reference formulas mainly VLOOKUP, INDEX * Ability to develop a system that integrates PDFs with Excel spreadsheet to reflect real-time changes. We're looking for an expert who can deliver this promp...

I need a professional who can seamlessly merge two photos of people for my wedding occasion. Here's what is essential: • Expertise in photo editing and merging • Ability to create a composite image without any unnecessary emphasis, where everyone in the photograph has equal prominence. I require someone with a keen eye for detail and the skillset necessary to deliver this project with top-notch quality. Photography expertise, coupled with strong Adobe Photoshop skills, will be particularly beneficial. I look forward to a beautiful composite image showcasing everyone equally.

I need to create an addon for excel where I will send email using the built in mailmerge and outlook will be used to send the email. The addon needs to: 1) monitor for replies sent from these email 2) if no email is received from the domains (as replies may come from a different person) where the email was sent, outlook will trigger a calendar reminder to send a follow up email 3) an email follow up template should be automatically created in the calendar and when I click it, I shouldn't have to add anything extra, except maybe to change the name of the recipient (or if the addon can pick up the name from the first email, that would be best) and then I can click send.

I'm seeking an expert who has comprehensive skills in product analysis primarily focussing on different categories. This role involves identifying profitable ite...for each product Mandatory Skills: - Previous experience using 1688, Taobao and etc. - Proficiency in product analysis. - Ability to work with Russian text and marketplaces using a translator. - Understanding of how to use Keepa, Helium10, and JungleScout software to find trending product. - The ability to use Excel/Google Sheets In this task you will need to find 10 items and analyse them. I'm looking for long term business in case of successful completing the task. I'm pinning Excel with the template how it must be filled to calculate profit from the product. Also you will need to analyse Amazon...

...Romanian balance sheet denominated in the local currency (RON - Romanian Leu). The final deliverable will be an Excel spreadsheet that not only presents the translated information but also aligns the financial data with Italian accounting standards, ensuring clarity and compliance for stakeholders in Italy. Objectives 1. Translation Accuracy: To ensure the financial statements are accurately translated from Romanian to Italian, capturing all financial terminologies and nuances without loss of meaning. 2. Compliance with Italian Accounting Standards: To reclassify the financial data in accordance with Italian Generally Accepted Accounting Principles (GAAP), ensuring that the reclassified balance sheet reflects the formats and categorizations typical in Italy. ...

Link to download the old application the old application is in the project files - if the link doesn't work And here's what should be in the new version: A necessary condition is to implement a voice input mechanism consisting of the words "photo [number of the next photo]" after taking a photo (this is the basic functionality of the application). There is no situation where a photo is taken during audio processing from the microphone. When starting voice recording, we have two options: either we stop recording with the recording button and then we can take a photo with the photo button, or we press the photo button, which automatically stops recording and we take a photo. The only problem that

I need a freelancer with adept skills in data entry to assist with entering single random words into an Excel spreadsheet. Expertise in Excel and keen attention to detail will be necessary. No particular categorization or field-specific organization is required. However, accuracy in entry is crucial. This task will involve: - Data entry of single, random words into Excel - Ensuring accurate and error-free input - Delivering the completed project on time. Experience in data entry, particularly with Excel, is greatly preferred. Familiarity with handling text data will also be beneficial. Please ensure you're comfortable with such requirements before making a bid.

I'm seeking a skilled individual who can create a complex mathematical Excel program for me. This program will need to perform functions related to 401(K) CONTRIBUTIONS, MATCHING CONTRIBUTIONS, IRS LIMITS AND SPILLOVER. Data visualization focused on financial data. Key Requirements: - Develop financial models within Excel - Design data visualization​ techniques to present this financial data - Implement interactive graphs, allowing for visible outcomes based on different inputs. - Facilitate 'what-if' scenario changes, which will impact the outcome and must update correspondingly - Implement a system where variable inputs are updating corresponding outputs effectively. Ideal Skills & Experience: - Experience in Excel programming - Strong backgro...

...application of complex formulae to perform the following tasks: - I have a database which when I select a food it gives me the macros depending what grams I input. - I want to Enable the calculations to propose different food alternatives with the same macro attributes to automatically adjust so I can give other options (i.e., equivalent quantities of rice and potato)(i.e., equivalent quantities of chicken and mince). not exact but give or take 10% Kcal - Maintain the fundamentals of data validation rules and conditional formatting rules throughout the sheet. The ideal freelancer should be highly competent in Google Sheets functions and have experience with nutritional database handling. Knowledge in dietary macros would be an additional advantage. Punctuality is a must...

...player's goal-scoring prowess. I'm seeking an Instagram video creator to craft engaging 1-minute videos highlighting an athlete's skills from soccer matches. The ideal candidate will extract compelling moments from VEO footage to create daily Instagram posts showcasing a particular player's talents. Payment will be per video, with potential for ongoing work based on efficiency and quality. If you excel at creating captivating sports videos and can deliver promptly, this opportunity is for you. Key Requirements: - Advanced video editing skills are mandatory. Expertise in motion graphics, advanced effects, and professional color grading will be highly valued. - In addition to showcasing the player's goal-scoring abilities, the videos should highlight gene...

Hlo! I have done MS in statistics. I read your job description. I have expertise in SPSS, R studio, excel, minitab, quantitative and statistical analysis. I will provide you with the finest work that perfectly aligns with your time and budget constraints. Thanks waiting for your response. Regards, Hira Mahmood

Hi, you did an excel vba macro for me in 2019. It worked fine until now but it just broke, its not working anymore. can you help fixing it?

I require an automated system, coded in Python, to perform checks on Visa card validity through the website Key Requirements: - Know-how of Python programming. - Experience with automated testing. Deliverabl... Key Requirements: - Know-how of Python programming. - Experience with automated testing. Deliverable: - A Python script that can automatically run these checks and save them. Project Outcomes: - Verification of card validity. - The results need to be saved in an Excel (*.xlsx) file format or in my attachment Experience: - Freelancers with familiarity in Visa APIs, Python, and know-how of working with Excel files will find this task in their field of expertise.

I'm in need of someone who can create permanent, menus in both Microsoft Excel and OneNote - For Excel: The permanent drop-down menu should consist of various colors, always displayed on the screen ,that I don't have to click to open. - For OneNote: The permanent drop-down menu should consist of an array of tags, always displayed on the screen, that I don't have to click to open.

I am looking for an expert with proficiency in Microsoft Excel to redesign and update my current invoice template on Excel. You will maintain the agreed-upon overall structure but give it a fresh, modern aesthetic. The document must be made from scratch on a new Excel as the old design isn't saving in colour when saving on PDF. Colours must be the same as existing template. Your responsibilities will include: - Redesigning the template in accordance with the modern design principles. However, the overall structure of the existing invoice should be retained to ensure similarity. - Updating the existing invoice template to a more contemporary design yet similar to the existing document. - Potentially modifying formulas or adding new columns if necessary. Ideal ...

I require the expertise of a Power BI maestro who is proficient in creating dynamic, interactive and visually appealing reports from sales data. This project specifically involves: - Analyzing sales data I will provide in Excel format. - Constructing and designing a Power BI matrix table for reporting purposes The ideal candidate is proficient in Power BI and Excel with an in-depth understanding of sales data reporting. You should be able to translate complex data into informative visuals & interactive reports. Producing accurate, error-free analysis within arranged timeline is critical for the success of this project.

I am seeking a programmer proficient in PHP scripting, capable of creating a simple yet effective script for regular file deletion. This script should be designed to operate through cron, automating the process of deleting any files older than 14 days from a specified folder.

Hey people are f...creating Short Vairo Instagram videos. Now I have the overlay text the video style and even a reference to work from what you need to do is work through the Google sheet and create these videos for me. The budget for this is $50 and you’re probably thinking that’s a bit low for 30 videos. When you see how quickly these videos are created you understand the budget. I need someone who is fast and efficient, and there’s no excuse why this couldn’t be done in just one day. This will lead to multiple works because once I send this to all my clients, I will probably want to hire you as well to do the exact same process. Google sheet example ->> The video below is an example video

pasar informacion a excel. pasar informacion a excel

We had a problem with a proxmox VM , and we lost data when VM was full disk. Then, we need to recover /home folder. It has al least 800 GB. If you are an expert, please contact me to work together.

Milestone: LeadStudio will return 500 accurate emails by Friday (72 hours). Excel sheet provided to direct targeted leads. Amount: $ 100.00 USD

As a seasoned C# developer, I need to create a complex mapper function that can efficiently extract data from Excel. The .xlsx files contain variable patterns spread across different sheets, so having the flexibility to handle such diversity will be key for this task. Key Requirements: - Develop a mapper function in C# to process Excel files in .xlsx format. - Deal with variable data patterns having different layouts spread across numerous sheets. - Extract and process data from all sheets in the Excel file. Skills and Experience: - Profound expertise in C# programming. - Experience in handling Excel data with variable patterns across multiple sheets. - A robust understanding of data extraction processes. - Proven experience in developing map...

As the project lead, I am in urgent need of a self-driven and detail-oriented freelancer who specializes in online data entry. This project's volume isn't specifically set, but the selected individual should be prepared to handle a potentially large amount of data entry tasks. Tasks will include but are not limited to: - Prompt and accurate entry of data into our online system. Ideal candidates for this job should have the following skills and experience: - Proven online data entry experience, with references or portfolio to back it - Dedication to efficiency and accuracy - Ability to work under unknown volume pressure - Availability to start immediately would be an advantage Unfortunately, we have not yet established a definitive deadline, so freelancers with some de...

I am looking for a skilled data analyst who can proficiently use Excel to perform text matching between two different Excel files for the purpose of matching the most appropriate description given to a medical service code . No significance testing is needed in this project, it is purely a direct comparison task. I have particular requirements pertaining to "Data set A". Your role will be primarily centred around: - Matching text in one Excel sheet to another. - Consolidating data based on text matches. - Focusing specifically on "Data set A". Ideal candidates should be experienced in Excel, data consolidation and comparison. Knowledge on data set handling would be a plus. Please bid accordingly, ensuring your capabilities in ...

I'm looking for an experienced data manipulator who can efficiently reformat my data according to CRM-specific requirements. Specifically, I need the address and names in my data to be split into separate columns. Key requirements: - Break down the existing 'Address' field into: 'City', 'State', and 'ZIP code' columns. - Split...split into separate columns. Key requirements: - Break down the existing 'Address' field into: 'City', 'State', and 'ZIP code' columns. - Split 'Names' into two separate columns: 'First Name' and 'Last Name'. This does not require any data entry, just an understanding of data structures, and layout according to CRM needs. Ideal freelancer should h...