Excel macro merge excel files työt

I have a daily dataset of the prices and funding fees of cryptocurrencies from Binance. I'm seeking an Excel expert to automate the task of calculating the price, funding fee, and percentage of each crypto every day at specific time. - The output should be in a table format for ease of understanding and comparison. Any tool or programming language that can efficiently and accurately perform this task is acceptable. The goal is to create a structured, automated process that can handle this daily task with precision. Ideal Skills and Experience: - Strong Excel skills, especially in formulas and functions. - Prior experience with automation in Excel, macros and VBA programming. - A good understanding of cryptocurrencies and their pricing. - Ability to deliver a ...

As a part of my marketing campaign, I'm seeking a professional who can meticulously gather the contact information of celebrants in the entire South UK. The final output should be in a convenient Excel spreadsheet format. Key Responsibilities: - Data Mining: Cover all regions in South UK to get a comprehensive list of celebrants. - Accuracy: The data should include celebrants' name, location, phone number, and email address. I want 500 celebrants listed. Please bid to complete this project. Do not message me to have a chat further or look to increase a price posted. This is unfair on the people following my instructions and bidding.

I'm seeking a VBA expert who can help me create a tool that will generate both PDF and Word documents from a specific column of an Excel file. The Word document should contain some static data derived from the column details. The primary requirements are as follows: - The tool should be able to generate both PDF and Word documents. - The Word document should include some fixed data from the Excel details. - An interactive graph should be included in the Word document, based on the data from the specific column.

I need a freelancer with proficiency in data collection and Excel to handle a minor task for me. The project is straightforward, with only 28 rows of data that need to be collected. I'll need the following information included in each row: - 12 columns of data - Each row will contain Text, Dates, Phone numbers, Links, etc. - Other miscellaneous data related to my project requirements that need to be captured. The ideal candidate for this position is skilled in Excel, organized, and pays great attention to detail. Prior experience in data mining will be a huge plus.

I need a VBA script tailored to Excel that will assist in my data analysis projects. It should prompt me to enter a target amount, then let me select a range of cells that contain various amounts. The code should find a combination within the selected range that makes the sum equal to or closest to the target amount. It could be more than the target amount or less than the target amount but it should be closest. It should then highlight the cells that make the sum that is closest to target amount. It should also ensure that only visible rows are to be considered. Hidden rows are not to be considered. Key Requirements: - Prompt for target amount and range of cells - Find combination closest to target sum - Compatible with Excel 2016 and above Key Features: - Return the first...

Need an expert to help with this The Adobe Creative Cloud “conflicted copy” file problem has accelerated, and the studio (Robin, Jenna, Cameron (host) and Bill) have a lot of duplicate files. I think it’s duplicate inDesign files mostly. We are finding it too time consuming (and dangerous) to manually delete files, and direct support from Adobe has not solved the problem. It has taken a sudden sharp increase lately and we have no idea why. There was a theory that upgrading Jenna’s computer would solve the issue but it has not. We need to know how to test for solutions between our studio members. Unable to sync SEED Pre-trip Planning Guide because the file is locked. Please close this file in any open applications and ensure you have write...

Do you excel in Excel? Are you a pro at product cataloging and social media savvy? We're hiring an E-commerce Operations Specialist! Responsibilities: Data management wizardry in Excel Catalog listing perfection for top-notch quality Media editing mastery for captivating visuals Google sleuthing for competitive price analysis Shopify expertise and social media finesse Requirements: Excel expertise Catalog listing experience Media editing skills Google search proficiency Shopify knowledge Social media savvy Ready to level up your e-commerce career? Apply now!

In need of a qualified freelancer to automate tasks such as report generation and data manipulation in Excel using advanced VBA. Key Tasks: - Create automated processes in Excel for data manipulation and report generation - Work with Excel data sources exclusively Skills and Experience: - Expert in Excel VBA development - Proficient in the use of advanced Excel functions, including array formulas and 'What-if' analysis - Strong understanding of data handling in Excel The successful candidate will be expected to demonstrate a track record of automating complex tasks in Excel using advanced VBA, and manipulating data accurately and efficiently.

I'm in need of a detail-oriented data entry operator to transfer data from my handwritten notes into a structured Excel spreadsheet. The critical aspect of the task involves entering data in a date-wise manner. Key Tasks: - Translate data from handwritten notes into digital form - Create a spreadsheet that categorizes data by date Ideal Skills: - Strong attention to detail - Prior experience with Excel data entry - Good understanding of date-based data organization - Ability to read and interpret handwritten notes Your experience with similar tasks will ensure speed and accuracy in this project. Preference will be given to those who can demonstrate previous success in such projects.

I'm in need of someone who can assist me in developing Excel formulas for financial equations, focusing specifically on profit and loss analysis. - You should be an expert in using Excel for financial analysis. - You will need to create tailored formulas to handle profit and loss calculations effectively. - Experience in business finance, particularly in profit and loss statement analysis, is greatly preferred.

I am looking for a reliable virtual assistant to help me with a variety of tasks ranging from email management, scheduling, data entry and documentation to managing Excel sheets and handling calls. Your communication skills are crucial and you should be comfortable with a variety of communication tools. Ideal skills and experience include: - Prior experience as a virtual assistant - Proficiency in time management and organizational skills - Strong communication skills - Familiarity with a variety of communication tools including email, instant messaging apps and Whatsapp calls I expect to communicate with my virtual assistant on once per day 1-2 hours a day basis. The right candidate would be someone who is proactive and can work independently to get the job done. Must be fluent...

...the site (tariff payment and number of contacts). You need to make sure that these fields are also displayed in the mobile version of the site and add statement generation for these fields. * Set up the generation of a report (pdf file, form will be provided), which displays information about which users did not pay the bills of the previous month * On the 1st day of each month, files must be generated in Excel and XML-Format with the bank data entered by the contractor during registration and the amount to be paid from the account. One file for all users (form will be provided). * Fix the code when sending an E-Mail to the user at the time of invoice generation. Now email is sent many times in a row per day, it should be 1 time * Add one more page to the artist regist...

...real-life combat scenarios. Why Join Us: Strategic Partnership: This is more than just a job – it's an opportunity to become a key partner in our expansion, leading our machine learning initiatives to new heights. Leadership Role: As the Senior Machine Learning Engineer, you'll spearhead our efforts in leveraging machine learning technology, guiding and managing our talented teams to innovate and excel. Exciting Growth: VRAS is expanding rapidly, and we're looking for our next partner to join us on this thrilling journey. Equity Only Offer: This partnership opportunity is equity-only, reflecting our commitment to building a collaborative and mutually beneficial relationship. Future Salary: A rewarding salary is guaranteed once the project secures funding....

As someone managing integral data via Excel, I am experiencing significant issues with formatting errors, especially concerning chart alignment for printing. I'm keen to hire an expert who is well-acquainted with handling these challenges. Key facets you should focus on include: - Rectifying formatting issues: Your primary task will be to identify and correct any formatting discrepancies in my Excel charts that hinder smooth printing. - Specialized in Alignment: A considerable part of the task involves aligning the charts properly to ensure hassle-free printing. Hence, a solid grounding in Excel chart alignment is necessary. Ideal Candidate: - Proficient in Microsoft Excel, specifically adept at creating and formatting charts. - Excellent problem-sol...

I'm looking for a freelancer who can type up data from an XLS Excel sheet. The data is related to different categories and I want it organized accordingly. Additionally, I would need some basic analysis done on this data; think simple calculations like sum and average. Ideal Skills: - Proficiency in Excel, specifically with XLS files - Experience in data entry - Ability to perform basic calculations Please note: This project doesn't require any complex analysis like pivot tables or charts, just simple arithmetic operations.

I am looking for an Excel expert who can assist in improving formulas and functions related to my current project. The focus will mainly be on Lookup and reference functions. Key Responsibilities: - Review existing Excel worksheets - Improve or create Lookup and Reference functions as needed - Verify functionality and accuracy of updates Necessary Skills: - Proficient in using Excel 2013 - In-depth knowledge of Excel formulas, specifically Lookup and reference functions. Experience with complex Excel functions is a plus. The goal is to streamline my workflows, so efficiency and attention to detail are critical for this role.

Looking for a large list of investors who have worked in or showed interest in various entertainment industries provide data in excel: name | company | industry | location | email address We're paying $50 for every 1,000

I have a data analysis project that I completed within the required timeframe. This project involved analyzing sales data to identify trends. Key Points: - Project Type: Data Analysis - Goal: Trend Analysis - Data Source: Sales Data Ideal Skills and Experience: - Proficient in Data Analysis Tools: The ideal candidate should have a strong background in using data analysis tools such as Excel, Python, R, or any other relevant software. - Experience in Trend Analysis: A proven track record of conducting trend analysis is essential for this project. - Familiarity with Sales Data: Prior experience with sales data analysis would be considered a significant advantage. The successful completion of this project relies on the ability to extract meaningful insights from sales data and pres...

I need an Excel template tailored for my existing business to manage deliveries, sales, and balance quantities on orders. Key Features: - Advanced Formulas & Conditional Formatting: I require this to ensure the template is robust and can visualize data effectively. - Data Points Tracking: I need the template to include sections tracking: - Product names and categories - Customer names and contact details - Delivery dates and quantities - Profits and balances on Purchase Orders (POs) - Daily load outs reports The ideal freelancer for this job should have: - Proficiency in Excel, with extensive experience in creating advanced templates with conditional formatting. - A good understanding of business processes, especially in sales, deliveries, and inventory ...

I have a project that entails transferring text data from a PDF into Excel. Given that the information is well-structured, this task should be a smooth process for anyone proficient in data entry and comfortable handling documents in both PDF and Excel formats. Key Tasks: - Transcribe text accurately from the PDF to Excel - Ensure data maintains its structured format Ideal Skills: - Extensive experience with data entry - Proficiency in PDF and Excel - Detail-oriented and high accuracy rate A successful completion of the project would entail an Excel sheet in which the transferred text data from the PDF maintains its original structure.

...specific data from a website containing a list of potential investors. The project requires an attention to detail as well as proficiency with Excel or similar spreadsheet software. Key tasks: - Visit a pre-specified website and navigate to the list of potential investors. - Carefully extract the following details for each investor: Name, Fund name, and 'Sweet Spot' investment amount. - Collate this information in a well-organized Excel spreadsheet. - Find and add a link to each investor's LinkedIn profile alongside their extracted details. Specific requirements: - A meticulous approach to uphold the accuracy of data. - Experience or familiarity with Excel or similar spreadsheet software. - Strong data extraction and entry skills. - A detailed pro...

Excel to Invoice Automation System My project involves leveraging Power BI, excel, and macros to automate the invoicing process. I am specifically looking to reduce the manual work that comes with data transfer. Requirements: - Develop a system to automatically generate and track invoices from excel spreadsheets - Implement a robust and error-free data transfer process - The final product should be able to streamline the entire invoicing process Ideal skills and experience: - Deep experience with Power BI, excel and macros - Understanding of finance and invoicing processes - Proven track record in creating automated systems - Strong problem-solving skills, attention to detail. In conclusion, I need someone capable of merging my existing software with a new a...

I'm seeking a skilled transcriber to transform 15 audio interviews into written Word documents. Each session runs between 30 and 60 minutes. Key Requirements: - Deliver the transcriptions in Word document format - Include time stamps only for speaker changes - Capture non-verbal cues like significant pauses and emotions, and exclude all others Ideal Candidate: - Proficient transcriber with experience working on interview materials - Strong attention to detail to ensure accurate transcriptions - Ability to capture and interpret non-verbal cues effectively - Familiarity with delivering transcriptions in Word format Please provide a quote based on the volume of work and your experience in similar projects. Your bid should include the estimated time needed for completion and any releva...

...am in need of a proficient VBA and Excel Macros expert to develop a simple, yet efficient invoice/billing application. Key Features: - Generation of invoices from input data. - Tracking and calculation facility for totals. - Maintaining a robust database for customers and invoices generated. Interface Requirements: - The GUI should be straightforward and user-friendly, allowing quick input, management, and retrieval of information. Data Handling: - The application should exploit Excel capabilities for the storage and manipulation of all the data, including customer and invoice records. Ideal Skills & Experience: - VBA and Excel Macros expertise. - Experience in creating user-friendly GUIs in Excel. - Able to develop robust database systems in ...

I am looking for a distinguished copywriter to effectively deliver my ideas and goals with a special emphasis on reaching a wider, general audience. The ideal candidate should be able to merge creativity with business writing to generate engaging content. Key Responsibilities: - Creating content that appeals to a broad audience - Using persuasive and appealing phrases to attract the right attention - Ensuring the copy adheres to our overall content strategy Ideal Skills and Experience: - Profound experience in copywriting - Excellent communication and conceptualization skills - Capacity to understand and write for a general audience - High adaptability and keen eye for details What I Offer: - Clear communication and prompt response - Constructive feedback for mutual growth - L...

write a query in the attached database that copies the last record created in the customer table and copies it to the merge table overwriting any record that exists in the merge table. There should only ever be one record in the merge table. Return the testdb access database to me with the query that performs the above action. Piece of cake for access DB guru

...management. Therefore, we're seeking an expert in Excel to build us an inclusive inventory management template. The template should possess the following specialized features: - Product Categorization: A way of classifying each product for straightforward identification and reference. - Stock Tracking: The prime functionality we're seeking. Notably, it should track items by product name. This will ensure precision in monitoring our inventory and prevent replication or confusion. - Comprehensive SKU Tracking: It should encase a complete and precise representation of our stock movements. Specifically, it should include incoming stock, outgoing stock, and current stock levels. An ideal candidate for this job should have extensive experience in Excel, particularl...

I'm in need of a freelancer who is skilled in designing both process and workflow flowcharts via Microsoft Visio, as well as project management checklist forms in Excel. The checklist should be of an intermediate level complexity, incorporating features such as drop-downs and validation. Prior experience in constructing Visio flowcharts and Excel forms is imperative to understand the project's need thoroughly. Proficiency in Excel functionalities would make tackling this task comparatively easier.

I am seeking a skilled programming expert, proficient in either Ruby or Python, with intermedi...primary task involves intelligently executing aggregations and nested queries in ElasticSearch, extracting data, in JSON format, and then transposing it into Excel or CSV format. I'm open to whichever format you are more comfortable with, so long as it is either of the two mentioned. In addition to this, having familiarity with job automation via GitHub is critical for this project role. This background should include understanding how to automate and schedule tasks to regularly extract, convert, and save this data. Ideal Skills: - Proficiency in Ruby or Python - Intermediate level ElasticSearch querying - Experience with JSON to Excel/CSV conversion - Familiarity with Git...

Entering data into an Excel sheet is the primary task for this project. Unfortunately, I cannot specify the volume of data that needs entering as I skipped this information. However, please rest assured that there is no immediate rush, so you can complete the project at a pace that suits you. Ideal skills and experience for this job would include: - Proficiency in Excel data entry - High attention to detail - Excellent typing speed and accuracy - Relevant experience in data entry jobs If your profile matches these criteria, I'd be delighted for you to submit a bid. Looking forward to potentially working with you.

I'm looking for a skilled data entry professional who can assist me with inputting data. The exact details of ...data and proficient in working with different formats. Your responsibilities will include, but are not limited to: - Efficiently and accurately entering data into the required format - Ensuring that the data is correctly categorized and organized - Checking for errors and handling them appropriately Ideal Skills and Experience: - Proven experience in data entry - Proficiency with Microsoft Excel and other relevant software - Strong attention to detail and accuracy - Excellent time management and organizational skills Please note that the volume of data may vary depending on the project, so a flexible approach and willingness to adapt to different task size...

I need a proficient expert in Excel to type numeric data and carry out basic arithmetic calculations. The scope of the project includes: - Data entry of numeric information into an Excel sheet. - Applying basic arithmetic operations to the input data. The ideal candidate should have: - Proficient skills in Excel, specifically with numerical data entry and calculations. - A keen eye for detail ensuring accuracy in calculations. - An excellent understanding of basic arithmetic operations.

I need a detail-oriented and focused individual who excels in manual data entry to convert data from my physical documents into a spreadsheet. Requirements include: - Transferring data from paper formats into a computer system - Strong typing speed and accuracy - Experience with MS Excel or similar spreadsheet software - Ability to maintain confidentiality when handling sensitive information. Accuracy is absolutely critical for this project, so keen attention to detail is a must. Previous experience with similar projects will be highly regarded.

I have code for login trading accound and fetch token data. I need to update 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. I need an intelligent programmer, who can see future problems and solve them clever and independently. 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 an...

I need a proficient freelancer to extract and simplify excel data encompassing text, numeric, and date and time data from a significantly sized data file (approximately 5000 rows). The simplified output should be in the form of an Excel file. Ideal Skills and Experience: * Proven experience in data extraction and simplification. * Proficiency in Excel. * Excellent attention to detail. * Ability to work with large datasets. Responsibilities: * Carefully extract specific data segments. * Accurately simplify data for ease of understanding. * Convert the processed data back into an Excel file. * Ensure absolute accuracy throughout the process.

I need a skilled professional who can create some form of wizard (general office365 tools) that lets me enter personal and cv/resume types of data and then turns it into a word based cv using layout that I will provide. The word cv template must be amendable by me. The output is to remain a word document. I need it to be something that will work when my computer is offline not connected to internet I have attached a first cut of the word document template and it is the hello highlighted pieces that represent the inputs and show how/where tables need to be populated. the intent is to enter data and have a consistent cv created for all members

I'm in need of someone to assist me with typing text data into an Excel sheet. The data will be provided in a digital format (PDF, Word, etc.). Key requirements: - Accurate and fast typing skills - Proficiency in Excel for proper data entry - Familiarity with using specific fonts and sizes for consistent formatting - Experience with data sorting and filtering in Excel Your attention to detail and ability to follow formatting guidelines is crucial. The ideal candidate will be organized, efficient, and able to deliver high-quality work within the agreed timeframe.

I'm in need of someone to assist me with typing text data into an Excel sheet. The data will be provided in a digital format (PDF, Word, etc.). Key requirements: - Accurate and fast typing skills - Proficiency in Excel for proper data entry - Familiarity with using specific fonts and sizes for consistent formatting - Experience with data sorting and filtering in Excel Your attention to detail and ability to follow formatting guidelines is crucial. The ideal candidate will be organized, efficient, and able to deliver high-quality work within the agreed timeframe.

Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.

I'm in need of an expert who can assist with entering text data into an Excel spreadsheet. Key Responsibilities: - The primary task is to accurately input text data into the designated cells of an Excel file. Ideal Skills and Experience: - Proficiency in Excel, especially in handling text data. - Attention to detail and accuracy in data entry. - Previous experience in similar projects will be an added advantage. Looking forward to your bids. My typing speed is 55wpm

I need a proficient freelancer to extract and simplify excel data encompassing text, numeric, and date and time data from a significantly sized data file (approximately 5000 rows). The simplified output should be in the form of an Excel file. Ideal Skills and Experience: * Proven experience in data extraction and simplification. * Proficiency in Excel. * Excellent attention to detail. * Ability to work with large datasets. Responsibilities: * Carefully extract specific data segments. * Accurately simplify data for ease of understanding. * Convert the processed data back into an Excel file. * Ensure absolute accuracy throughout the process.

I am seeking a Python expert with extensive experience in MS Access database management. The project involves merging and transforming existing MS Access databases. Key Tasks: - Database Merging: You will be required to merge multiple MS Access databases into a single, coherent database. - Data Transformation: The data within these databases will need to be transformed to fit the new structure. - Query Optimization: Your role will also include optimizing queries to ensure efficient data retrieval and manipulation. Key Objectives: My main goal is to facilitate easier data management through this process. The end result should be a well-structured, consolidated database that is optimized for performance. Ideal Skills: - Proficiency with Python and MS Access - Extensive experience ...

I am currently in need of an Excel and data entry expert with strong understanding in copyright matters. Key Deliverables: • Efficient handling of data entry tasks with fast typing speed. • Strong proficiency in Excel functions and formulas. • Undertaking copyright research and analysis. Ideal freelancer for this role should have: • Proven experience in Excel and Data entry. • A strong grasp of copyright laws will be a plus. Please include in your application evidence of your speed and proficiency in data handling, and any relevant experience you've had in dealing with copyright issues. Your past experience related to these tasks will be greatly considered during the selection process.

I'm looking for an expert with a keen attention to det...representing the date and time, and the second representing a series of numbers. Once this data is extracted, it will need to be organized into an Excel spreadsheet and promptly emailed to me following each extraction. Skills and Experience: - Proficiency in data collection and entry - Familiarity with Excel spreadsheets - Exceptional attention to detail - Ability to work without supervision - Punctuality to ensure data sets are sent promptly after extraction. The success of this project relies greatly on accuracy, timeliness, and observance of instructions. Hence, the ideal freelancer should have great attention to detail and proficiency in Excel. Timely delivery is also paramount. As such, punctuality...

Project Title: Customizable Excel-Based Mark Book System for English Learning Area Tracking This reads like a lot, but I am only trying to be clear. It's just a mark book. Project Overview I need a skilled Excel developer to create a solution that helps schools track student progress against specific English Achievement Standards across year levels of the Australian Curriculum. The goal is to pinpoint areas needing improvement, empowering schools to target resources effectively. Is it Speaking and Listening, Reading and Viewing, or Writing and Creating? If so what particular Aspect (sentence? Key Requirements Foundation: Excel workbooks to accommodate multiple teachers and classes. Structure: Year Levels (tabbed sheets) with each year's Achievement...

...realistic and cartoonish styles, focusing on my wife holding a child as the central theme. I would like it done in the style of a particular image (see inspiration attached), including dia de los muertos theme. It will need to be high enoough resolution to print in large format (several feet) Key Requirements: - Blend of Realistic & Cartoonish Styles: I'm looking for an artist who can seamlessly merge these two styles to create something truly unique. - Skill in depicting People: The artwork should predominantly feature people. The ability to capture human expressions and nuances is crucial. - Creativity and Originality: I want something that stands out and captures attention. The artwork should be fresh, innovative, and engaging. Ideal Skills and Experience: - Profi...

Buscamos experto/a en planillas (excel) y docs en Drive, nube, etc., para varios trabajos de: - Arreglo de planillas a paquete de documentos actual. - Personalización de paquete de documentos a entregar a clientes (estandar, a todos se les entrega el mismo paquete) - Creación de un panel o sitio web con google sites, para montar (replicar) los documentos y hacer más lúdico su uso. Nota importante: no se requiere crear planillas desde cero, sino solo mejorar/actualizar las existentes. Informar: - Horas aprox., disponibles por semana (inicialmente, 3 a 6 horas por semana) - Valor hora (necesitamos fijar un valor hora para el pedido de arreglos de docs, entregas de la nube con el paquete de documentos, etc.) y otras actividades indirectas que puedan resu...

Seeking a Python wizard to generate line and scatter plots from simple numerical data housed in Excel files. Your expertise in Python and experience with data visualization is key to succeeding in this role. Please, in your application: - Highlight your experience in Python plotting - Specify similar projects you've completed Going above and beyond to deliver an error-free, clean and professional visualization will be appreciated. Trust me, I value quality. Let's get started!

...expertise in developing VBA scripts and macros in Excel to help me automate several repetitive tasks. I am looking for an expert in MS Excel to develop a special MS Excel Macro which can be integrated to MS Excel environment, in order to generate an output file. This tool will allow us to transform a specific Input file into another Output file. • Input: catalog_product_option-YYYY-MM-DD • Output: The 2 files are attached, with a color mapping to recognize the columns in scope. In summary, we need to be capable to issue an export file in a specific format (see attached picture “”): • Specific Orders of the column (Green) • Suppress the duplicated values for some line items, on 3 fields. The macro all...

I'm in need of a proficient Excel specialist who can help create a solution for selecting rows to display in Excel with a total at the bottom. Requirements: - Proficiency in Excel and experience with creating VBA or macros - Ability to display both numerical and text data - Ensure compatibility with Windows Operating System Please note, this task calls for a clean, simple solution. Your proposal should detail your previous work with similar Excel functions.