Helpful excel macrosงาน

I need assistance with a basic Excel data entry task. This work will encompass activities such as copy-pasting and sorting data. The volume of data is not overwhelming, with just a few hundred entries to be managed. Ideal candidates for the job are experts in Excel and have a knack for meticulousness and swift data entry.

Hello. I have some Excel Sheets whereby I have some tables in them. I want to protect the sheet. However, when I do so, I notice that I cannot add additional rows to my tables. I need to be able to lock my sheets and add additional rows to my tables when I need them. It is worth noting that I am also copying data from one table to another on a separate sheet sometimes. I want someone to solve this problem for me, and make me a small video to show me how to do it. I need it explained in perfect English in a way that I understand. In simple terms. I am not a coder or anything like this. Although I am good at using Excel. I made a video for you to check, it is a short video. I have the link on the pdf document.

I am seeking an individual with proficient skills in Excel and a keen eye for detail. Your main task will be translating handwritten documents containing text, numbers, and dates into formatted Excel spreadsheets. This will require: - Accurate data transcription from handwritten documents into Excel - Filling out more than 20 columns and rows per sheet - Proofreading and immediate correction of errors The ideal candidate should have extensive experience in Excel and data entry, plus superb attention to detail. Knowledge and practice in inputting handwritten data would also be beneficial. Make sure to include any relevant data transcription experience in your proposal.

I need to extract a list of 500+ stores from an online directory. The structure of the directory is: - A home page with a long list of stores. You can see the name of each store. If you click on a store, you will be taken to that store's page. - Each store has its own page in the directory. This page contains lots of data about the company. This is what needs scraping. Key Deliverables: - Excel or CSV file containing contact data for each store Data required to be extracted (if found on the page): - store name (this is the store's name, separate from company name) - store company name - store website URL - store Facebook page - store telephone number - store email - store Introduction paragraph - google maps link - opening hours IMPORTANT: You must ensure accuracy of t...

I'm urgently seeking an advanced Excel coder for data analysis. With a budget of just $10, your key role will be to analyze and report on an undisclosed set of data. To be successful in this task, the following skills are desirable: - Expert knowledge of Excel, including creating custom functions - Strong data analysis and reporting abilities - Experience automating repetitive tasks to improve efficiency Please, note that I am aiming for prompt completion of this project, so your ability to produce results ASAP would be beneficial. If your Excel coding skills align with what I'm seeking, please don't hesitate to bid on the project. Improving data accessibility and understanding through your expert analysis is my main goal. Your guidance through this d...

I'm urgently seeking an advanced Excel coder for data analysis. With a budget of just $10, your key role will be to analyze and report on an undisclosed set of data. To be successful in this task, the following skills are desirable: - Expert knowledge of Excel, including creating custom functions - Strong data analysis and reporting abilities - Experience automating repetitive tasks to improve efficiency Please, note that I am aiming for prompt completion of this project, so your ability to produce results ASAP would be beneficial. If your Excel coding skills align with what I'm seeking, please don't hesitate to bid on the project. Improving data accessibility and understanding through your expert analysis is my main goal. Your guidance through this d...

I have a specific ACCDE file that needs expert attention. The required tasks for the freelancer include: - Customization of forms and reports in the ACCDE file. This ACCDE file has forms where users...expert attention. The required tasks for the freelancer include: - Customization of forms and reports in the ACCDE file. This ACCDE file has forms where users can input the data, I would like to export this data into excel/csv or SQL (whichever is conviniant) - Current challenge is, unable to look at the VBA code or export full columns how in the form. The ideal candidate has extensive experience with MS Access, specifically in the customization of ACCDE files and data exportation. They should have in-depth knowledge of form and report design as well as MS Access to Excel/CS...

I am on the hunt for a mathematical wizard who excels in calculus and can guide me through a high school level problem-solving exercise. Key responsibilities include: - Explaining concepts behind the calculus issue at hand - Providing solutions, step by step, for selected calculus problems - Ensuring an understanding of the problem-solving strategies - Offering helpful tips and tricks to tackle future related problems effectively The ideal freelancer should: - Be knowledgeable in high school level calculus - Have prior experience or prove capability in teaching or tutoring math - Possess excellent communication skills in explaining complex mathematical concepts in easy-to-understand ways This project does not just aim to solve problems but also boost the confidence in handling...

I'm looking for a chef, experienced recipe writer or a cook who can help me craft a beginner-friendly cookbook. This project is aimed at people who lack experience in the kitchen but are eager to explore multiple cuisines. Key skills needed for the project inc...previous with just re heat or assembling ideas on the day) - i am after several E books (canapes, plated meals and shared platters) - will need to have a guide on presentation ideas as well as preparation hints and hacks and portioning for the amount of guests If you are well-versed in these different cuisines, skilled in writing easy-to-understand instructions and have an eye for creating clear, helpful illustrations, I would love to see your proposal. Together, let's inspire novices in the kitchen with a diver...

I'm seeking an experienced freelancer to construct a comprehensive Excel worksheet. This worksheet will be used to calculate and compare around 10,000 individual assets with different inservice (depreciation start dates). The assets i specifically am looking at are called SUBbase assets and used in Road construction. We currently have asset lives of around 150 years but wish to compare this life with a variety of years 200/250/300/350 and 400years. Possible different years so needs to be able to amend lives and compare against original. I am looking at having something design that can give comparisons against the original live (which ive highlighted in yellow). The file attached has a large amount of data alot of which isnt necessary The columns in yellow are what you wil...

I am in need of a freelancer who is an expert in US taxes, particularly with experience in accounting and bookkeeping. The project involves generating helpful guides that explain, in layman's terms, the complexities of IRS tax forms. -Breakdown of Forms: The forms to be analyzed include 1040 (individual tax return), Schedule C (sole proprietorship income), Schedule E (rental income), and ideally, all forms issued by the IRS. -In-depth Understanding: The guides should include advanced tips and tricks to make these forms easier to understand. Freelancers are expected to provide a comprehensive explanation of each form. -Experience and Skills: Freelancers should demonstrate their previous work experience in the tax industry, particularly in the US context. This project requir...

I need a VBA macro expert to automate repetitive tasks in Excel. Specifically, the focus is to build a macro that will update data from multiple database systems, pulling all necessary data and accurately updating the Excel file. The requirements include: - Deep knowledge in Excel VBA and macros. - Extensive experience in dealing with database systems. - Attention to detail to ensure valid and accurate data updating. - A solution-oriented approach to identifying potential issues with the automation. The ideal candidate will have a proven track record in creating VBA macros that interact seamlessly with various database systems. They'll bring efficiency and reliability, turning the repetitive updating process into a seamless, automated one.

I'm looking for an experienced writer and data analyst to help me with my project. I already conducted an experiment and did a preliminary analysis and reached some results, but I need someone who can work on this data and analyze it in a way that makes it more likely to be published in ISI journa...report based on findings Ideal Qualifications: - Proven experience in social sciences and data analysis - Strong grasp on cognitive psychology - Familiarity with psychology-focused research and writing - Specialized in performing in-depth data analysis and providing detailed insights -ISI quality of paper Your expertise in psychology particularly in cognitive psychology will be immensely helpful in carrying this project to its completion. Please include any relevant experien...

I am in need of a proficient Excel automation specialist. This job requires updating an existing workbook with new data, automating the creation of rows, columns, and formulas and allowing for an undated workbook to be downloaded without having to re-create all the formulas etc. I am open to the choice of programming language used for the Excel automation, eager to discuss your expertise and preference. Here are the expected tasks: - Modify an existing workbook with new information - Automate the import of current workbooks - Automate the creation of rows, columns, and formulas The frequency of these tasks will be dictated by our data download schedule which is done on an as-needed basis per job schedule. Ideal candidates will have a solid background in Excel automat...

I need a detail-oriented freelancer to assist me in extracting text content from Word documents and transferring it into an Excel spreadsheet. Key Tasks: - Copy text from Word Files - Paste text into Excel Spreadsheet The ideal applicant should have: - Experience in data entry - Strong attention to detail - Proficiency in Word and Excel Speed and accuracy are of the essence in this job, resulting in an efficient conversion without loss of information.

I am on the lookout for a season...detailed historical rain data for Camden County, New Jersey, spanning the last 2 years. Your key tasks will include: - Gathering and analyzing rainfall data specifically for Camden County, NJ - The data should cover a period of the last 2 years - Present the data in an Excel format Ideal candidates should possess expertise in the following areas: - Meteorological data gathering and analysis - Familiarity with weather recording instruments and systems - Proficiency in transforming raw data into actionable reports - Firm grip on Excel for data input, organization, and presentation With your contribution, this project can march forward with key weather insights for Camden County, NJ. I look forward to hearing from those with a knack for ...

Project Description: We are a transportation company specializing in vehicle transportation across the United States. Our operation involves four main divisions: Drivers, Dispatchers, Accounting, and Management. The current process involves manual data entry into Excel documents for tracking loads, payments, and generating weekly reports and invoices. This process is time-consuming and prone to errors. We aim to automate and streamline our operations by developing a custom web application. Objectives: To develop a user-friendly web application that automates the entry and tracking of load information. To create a system that automatically generates invoices and weekly reports based on the entered data. To allow for real-time data access and updates by different divisions within t...

Project Description: We are a transportation company specializing in vehicle transportation. Our operation involves four main divisions: Drivers, Dispatchers, Accounting, and Management. The current process involves manual data entry into Excel documents for tracking loads, payments, and generating weekly reports and invoices. This process is time-consuming and prone to errors. We aim to automate and streamline our operations by developing a custom web application. Objectives: To develop a user-friendly web application that automates the entry and tracking of load information. To create a system that automatically generates invoices and weekly reports based on the entered data. To allow for real-time data access and updates by different divisions within the company. Key Features:...

I'm seeking a proficient Python programmer who can build effective scrap...and LinkedIn profiles. Your task will include: - Using Python with Scrapy to collect desired information. - Developing scripts that can identify and retrieve the services provided by the mentioned sites, along with their relevant contact details. - Ensuring that the scripts can also gather a comprehensive list of requirements from LinkedIn profiles. - Lastly, providing the compiled data in an Excel file format. Experience with Python and Scrapy is vital, and a firm understanding of web scraping and data manipulation is necessary. A proven track record in similar tasks would be advantageous. The freelancer must also be aware of and adhere to the legal boundaries around web scraping to avoid any potentia...

... This includes retrieving details such as company names, contact names, addresses, phone numbers, website address and email addresses. Key tasks include: - Scrape all necessary information - Format scraped data into an excel file - Rigorously remove any duplicate entries The ideal freelancer for this project would have a vast amount of experience in web scraping and data mining, as well as a deep understanding of data cleansing to ensure we are only left with unique data points. Highly proficient in Excel and familiarity with Website A's structure would also be advantageous. ----- note there are two parts for each record: Scrape : date: / name of show/ and location on this page: then continue click on each

Problem: we want to be reminded / flagged when a contract should be renewed / re-tendered. We want to reminded / flagged six months before the contract expires. The data point we have is the contract expiry (dd/mm/yyyy). Solution: if the contract expiry is less than 6 months away, please make column H red. It needs to be done in a google sheet and in excel.

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

Excel VBA Automation- As discussed.

I am in need of a meticulous data entry clerk, proficient in both text and numeric data entry. The project involves entering 200-250 items into a pre-provided template. Ideal skills and experience: - Proven data entry work experience. - Strong language skills. - High levels of attention to detail. - Experience with data entry software. or in an excel template - Experience working with templates. Please note: The excel template for data entry will be provided, I'll need you to follow the structure precisely and ensure you maintain high levels of accuracy. The data provided will be a mix of text and numeric data. Fields (Columns) will be : date = date field supplier name = text field nature of items or services ( 7-10 key words) = text field ...

I am seeking a professional with strong capabilities in Excel who can assist in creating 5-10 filter views on an online Excel sheet. The successfully completed project will include: - Ability to filter numbers, text and dates with precision - Filter views applied effectively on each individual column - Advanced understanding of Excel to ensure seamless integration of filter views The ideal freelancer for this job will have experience with complex Excel tasks, especially filter views. Your expertise should include a strong understanding of Excel formulas, data types and the ability to navigate and edit online Excel sheets with speed and accuracy. Your work will significantly improve the functionality of my spreadsheet, enabling faster data retriev...

I have two lists of invoice numbers and associated amounts, formatted in Excel. I need a worksheet created that will compare these lists and highlight any invoice numbers that cannot be found and their corresponding amounts. The comparison results should be incorporated into existing sheet 1. Additionally, the data in these invoice lists includes dates, invoice numbers, and transaction amount. Ideal freelancers for this project should be: - Highly proficient in Excel - Experienced in data comparison and highlighting functions - Able to work with data that includes dates and transaction amounts.

I'm in need of an Excel expert who can utilize Excel macros to automate several of my routine tasks. The main actions to automate are listed below: - Data Entry - Generating Reports These tasks are currently taking a significant amount of time and I'm confident that with the right automation, efficiency can be greatly increased. Ideal candidates should have extensive experience in using Excel macros for automation and report generation. A deep understanding of Excel and automated data entry via macros is essential for the successful completion of this project.

I need a proficient guru to inset 2 links to "shake hands" between and my gay adult website. It's just 2 links, guys. This is easy... IF YOU UNDERSTAND HOW WORKS. It's helpful if you have worked on dating software. My software site is custom-built, but they all work pretty much the same. Required Skills: -A ability to do this work in 48 hours. - Must be OK with working on a gay adult website. - Robust understanding of 's features and integration protocols for website payments and the flexforms they use. - Must have experience working on a dating website. The specific links to insert are: (for: $99.00 for 365 days) Flex ID: bb510ebd-46cb-4d67-8903-4da9c7eb3b46

I'm seeking a highly skilled freelancer to assist with data processing tasks. Key Responsibilities: - Process various data efficiently Please note, the source of the data to be processed is unspecified at this point. Timeline: - There is no strict deadline for project completion. However, a sense of urgency is appreciated Ideal Skills: - Solid data processing capabilities - Prompt delivery and high-level accuracy - Exceptional problem-solving skills Experience in the data entry field If you think this project aligns with your skills, I'd love to hear from you.

Creation of a real estate acquisition model including Cash flow, tenancy schedule, lease modeling and renewal assumptions, IRR, levered and unleverred. Including formula to play with the model.

I'm in need of a professional who can create basic floor plan drawings. I will not pay more than $30 for this, so please do not bid above that. It is a very, very simple job!! Key Items: - Develop architectural CAD drawings - Focus on detailed floor plan creation - Scale of plans is uncertain, open to recommendations. Ideal freelancer must be skilled in CAD with ...more than $30 for this, so please do not bid above that. It is a very, very simple job!! Key Items: - Develop architectural CAD drawings - Focus on detailed floor plan creation - Scale of plans is uncertain, open to recommendations. Ideal freelancer must be skilled in CAD with previous experience in generating architectural drawings. Your portfolio containing similar past projects will be helpful in the sel...

I have multiple Excel files that require thorough cleaning. The data inconsistencies that I need addressed include duplicates, formatting errors, and incorrect entries. There's also a need for merging, splitting, and conditional formatting. Ideal candidates for this project should be proficient with Excel and have experience in data cleaning. They should also be adept at identifying and solving data-related issues. Ultimately, I need all duplicate entries to be removed from these files. • SKILLS REQUIRED: - Proficiency in Excel - Experience in data cleaning - Ability to merge and split data - Familiarity with conditional formatting

I urgently require an experienced professional to assist in setting up my Shopify store. I don't yet have a domain name, so guidance with this will be helpful. Notably, I'm venturing into selling live plants and gardening equipment, hence getting a domain that resonates with such products is crucial. Additionally, given my limited expertise with product images and descriptions, I'll need your assistance in creating and managing them. Key Skills Required: - Shopify Store Setup - Domain Purchasing - Product Image Design - Product Description Writing Ideal candidates should have a background in horticulture or a deep understanding of plants and gardening tools to help create meaningful and engaging product descriptions. Your portfolio showcasing previous stores set up...

...device, I need a firmware developer adept at handling the nRF9160 chipset. Key components of this project will include: - Designing and implementing firmware with real-time data monitoring capabilities. - Ensuring the firmware supports remote updates. - Optimizing the firmware for low power consumption. Please note, specific aims for real-time data monitoring weren't specified. As such, it'd be helpful to have experience in different monitoring mechanisms - such as sensor data monitoring, data visualization, or setting up alerts/notifications. Frequency for remote firmware updates hasn't been defined either at this stage, so expertise in firmware updates ranging from daily to monthly intervals is preferred. Essential Skills: - nRF9160 firmware development - K...

Project Description: We are seeking a talented graphic designer to create a captivating social media flyer for our online course. The course targets individuals aged 15-25 and course name is Data analysis with MS Excel Requirements: 1. Design must be visually appealing, professional, and in line with our brand identity. 2. The post should include engaging visuals and concise, compelling copy to capture the audience's attention. 3. Dimensions: WhatsApp status, WhatsApp post, Instagram 4. Incorporate relevant course details such as course name, key benefits, and a call-to-action (e.g., "Enroll Now"). 5. Use our brand color pallette 6. Provide the design in a high-resolution format suitable for social media posting. Deliverables: - One social media post design in the...

I require a comprehensive spreadsheet created that compares four different real estate brokerages. The spreadsheet should contain multiple tabs, each committed to the follo...four different real estate brokerages. The spreadsheet should contain multiple tabs, each committed to the following aspects: - Fees - Number of transactions closed - Average price point - Stock options - Agent attraction For the 'number of transactions closed', I wish to use a preset value for each brokerage. Moreover, I want the 'fees' data structure to be tiered. Candidates with excellent Excel skills are preferred. It's also beneficial if you have a good understanding of real estate brokerage fees and structures. Attention to detail is essential as the spreadsheet needs to allo...

I require expertise in extracting purchase details from text-based PDF attachments in my Outlook emails and compiling this data in an excel sheet. Key tasks: - Set up a platform that automatically imports data from new email attachments - Extract purchase details from these attachments - Place this data into an Excel sheet accurately. Skills and Experience: - Proficient in Microsoft Outlook and Excel. - Knowledge of data extraction from text-based PDFs. - Automation experience, ability to set up a system that triggers upon receipt of a new email. - High attention to detail required. - Previous work in data extraction or related fields is a plus.

I am in need of a skilled logo designer who can create a minimalist logo using a specific color scheme. This logo will be a combination of both text and image elements. Here are some more details regarding my needs: - Logo Style: Minimalist - Color Scheme: I have a specific color palette in mind that I would like to use....project. - Logo type: The logo needs to be a concoction of both text and image. I'm looking to have a perfect synchrony between the text and image in the logo design. Ideal Skills: - Proven experience in minimalist design - Ability to work with specific color palettes - Expertise in combining image and text for a single logo Your portfolio showcasing past minimalist designs would be very helpful. I look forward to creating a sleek, modern, and engaging...

I'm in need of an Excel VBA expert who can write a VBA routine to alter the font of a string. See image attached Sub BookLabel() Select Range StartLabel (H2) Select first x characters of string where x = value in cell F2 Set font =16 Font = Bold Down 1 cell Repeat same Continue to loop until some statement such as “End”, below the last record End Sub

Tengo el inventario de la tienda ya escrito, pero nescesito tenerlo en un excel para que sea mas dinamico y facil de usar.

I'm in need of a unique text-based logo for the base of a ski which is die cut friendly. This entails certain specifications to consider: - The design of the logo needs to be bold, blockish, with clear separation between the letters to ensure its optimal adaptabili...of the logo needs to be bold, blockish, with clear separation between the letters to ensure its optimal adaptability to a die-cut process. - Stick to a monochrome color scheme, presenting both a professional and modern feel. Ideal candidates for this project should have a strong background in graphic design and experience working with die cuts. Familiarity with ski equipment design could be helpful as well. The success of this project will be measured by the clarity and adaptability of the logo when applied to ...

I need a meticulous person with a keen eye for detail to hunt down and manually input contact details from an event's website into an Excel file. Key Responsibilities: - Collect the data fields: Name, Email, Phone Number, Company and Sector from the website. - Store data in an organized manner in a .xls Excel file. Ideal Candidate: - Someone with experience in manual data entry - Attention to detail, as accuracy is of utmost importance - Please provide examples of past work demonstrating your data entry skills I look forward to seeing your applications and choosing the best fit for this job. Remember, past experience counts!

Hi, I need to extract data and images from product pages into an Excel file. Here is an example link - Video showing it - ATTACHED FILE is the format it needs to go into so I can import it into WooCommerce Product name All images Price About this product Details Variations: color, size, etc

...a meticulous and detail-oriented freelancer to concentrate specifically on the following for an unspecified number of Excel files and bank statements: - Date Formats: Ensure all dates are consistent - Transaction Types: Verification and correction of all transaction types - Narrative Consistency: Ascertain uniformity in transaction narratives Ideal skills for the job would include extensive proofreading experience and in-depth knowledge of Excel data and bank statements. Any examples of past work or detailed project proposals you could include in your application would be beneficial. Please be prepared to dive into a project of an undefined size, as the number of Excel files and bank statements has not been specified. With your assistance, I'm confident we ...

...Python, Excel and other development languages. Monitor+ is designed for reference data and handles complex pre-processing of data and can return historical data in a variety of JSON formats in just three lines of code." - Monitor+ is a high value, low cost, API platform designed for Reference Data. - It's a complete reference data solution for traders, analysts as well as front, mid and back office. - Monitor+ provides market data vendors with a new, affordable channel to market - fast. - Extremely powerful API gives easy data access in R, Python, Excel and other languages. - Access energy, commodities, stocks, currencies, global indices and more. For Clients Paragraph of text and 5 Bullet points "We offer native access to ma...

...skilled graphic designer who can develop a series of medium-sized, flat design styled icons for our digital courses. These courses encompass topics including Excel, PowerPoint, MS Project, and Power BI. The icons should follow the style of the ones we already have for our HSE (Health, Safety, and Environment) courses, maintaining consistency across our course offerings. Ideal Skills and Experience: - Proven experience in designing intuitive and visually appealing icons - Proficient in Adobe Illustrator - Strong understanding of flat design principles - Prior work on digital content or courseware would be a bonus - Familiarity with Excel, PowerPoint, MS Project, and Power BI for context-oriented design. Requirements: - Maintain consistency with the style of icons used fo...

Hello. I need to extract the values from this website in a spreadsheet (CSV or XLSX) in an automated way and every 10 minutes: . Must be with a VBA Macro and no required nothing special, only plain text in rows and columns (see attached). You will notice that it corresponds to a website with information about sports betting. The fields to be extracted are ALL the ones you can see per game. For example: - Sport - Country - Championship - Date and time of the event - Equipment - Type of bet (Home/Away, Over/Under 2.5, Final result, etc.) - Etc. Also note that "surebets" with 2 and 3 results appear, depending on the nature of the bet. If you have any doubt, ask me. Look at next examples of 2 results, but 3 results is seemed, adding more columns at the final table (see atta...

I'm experiencing an issue where a form in my Angular app...Angular framework, especially in form handling. - Proven troubleshooting and problem-solving skills in a similar domain. - An understanding of form behaviors, in order to help identify which action is required upon submission (whether it should redirect to another page, display a success message, etc.). When bidding on the project, it'd be helpful if freelancers could include: - Their experience in resolving similar Angular form bugs would be helpful, although it's not a requirement. - Examples of past work around Angular applications, especially those that had forms at their core. Looking forward to working with a detailed-oriented, problem-solving expert in Angular who could help troubleshoot and...

I'm seeking a freelancer proficient at data entry for impending tasks. The job involves entering both numerical and textual data. Details: - You will need to enter a mixture of numeric and textual data. - Accuracy is crucial to ensure the quality of data entry. - The finalized data should be provided in an Excel spreadsheet. Skills and Experience: - Proficient in data entry. - Strong attention to detail. - Experience using and formatting Excel spreadsheets.

I have two excel files. In the file, I want you to color code cells from B2:E2 to the end of the columns with text as either green, yellow, orange, red for how closely the text in one cell matches in another. Green - perfect or near perfect match Yellow - most of it is good Orange - less than 70% match Red - poor match or no match I roughly counted there are about 2000 cells.