Excel macro refresh data işler

I am in need of an expert who has a solid grip on Excel, able to arrange numerical data into tables for me. To make my work simpler: - The main task will involve averages, mean calculations, as well as frequency and distribution analysis. Past experience with these functions is essential. - I am looking for someone who can efficiently sort the data in ascending order. Demonstrated ability with sorting functions in Excel is preferred. In summary, a flawless understanding of Excel and a keen eye for detail will be crucial for this project.

Hi there, I am currently battling with some issues on my training website after some PHP updates. First and foremost, the main issue I am dealing with is the improper display of course content for logged-in users - they are either greeted by a blank page or shown incorrect content. Ideally, I want this bug fixed as soon as possible. Beyond that, I also want a complete refresh of the website once this key issue is resolved. This includes, but is not limited to, improving the UX/UI design and modernizing the overall aesthetics. Some of the key skills and experiences I am looking for in a potential freelancer includes: - Proficiency in PHP & Bug Fixing: As this lies at the heart of the current problem, deep understanding of PHP and experience in bug fixing is crucial. - Experien...

I'm in need of a professional who has mastered the Excel 2016 with a strong focus on VBA scripting. The individual should have: - Proficiency in financial modelling using VBA. -Option Future calculations P&L of portfolio.

I'm looking for a resourceful and diligent researcher passionate about coffee consumption in North India. The objective is to conduct local market research to understand the At Home coffee consum...market research, especially within FMCG product category - Understanding of geographic nuances of urban and suburban areas in Delhi (we can start with one city at a time, starting with Delhi) - Ability to compile and present data in a clear, effective manner Tasks include: - Collection of information from a variety of users. Looking at a user volume of up to 1000 people - Analysing and interpreting data to deliver insightful reports. This opportunity is perfect if you're interested in market research and the coffee market. If this sounds like something you'd e...

I require a quick and precise assist in compiling sales leads data from the New York Suppliers Day Exhibitor List. Your tasks will involve: - Extracting names and contact details of exhibitors. - Organizing the acquired details into a spreadsheet in an ordered and readable format. The list can be found here: Note: *ONLY 'RAW MATERIALS' EXHIBITORS REQUIRED* The first one is already done for you here: Given the urgency, applicants should have: - Proven data entry abilities, with strong attention to details. - Proficiency in Excel or similar spreadsheet tools. - Able to deliver as quickly as possible. Candidates

...include profound knowledge of both Android and iOS platforms, extensive experience in app development, and an understanding of the intricacies involved in creating music applications. Ability to infuse apps with user-friendly features while keeping the aesthetic appeal is a definite plus. Take note, there is no time limit to this project, but maintaining quality is of utmost importance. So, if you excel in precision and have a knack for creating robust applications, you're the right fit for this job....

Transitioning from Excel to Looker has been quite a hurdle. I need a professional who is an expert in building new Looker explores and can also provide guidance and answer specific queries on dashboard building. Here are the specifics I'm looking for: - Looker Expertise: Help us transition from our existing Excel methodology. Your task would not just be to visualize the data but also come up with insights that aid business growth. - Interactions: You would be closely interacting with our team. Hence good interpersonal skills are a must. - Data Source: Proven experience in connecting and analyzing data from Google Sheets through Looker is vital. In short, we need someone who can take the lead in ushering us from the Excel era into Looke...

...we need to accomplish with this system. 1- Upload daily order files - EXCEL/CSV. 2. Update daily orders , quanity, status (avaiable/not avaiable, when avaiable with dates) etc. 3- Genarate procurement orders sheet to market 4- Genarate adress sheet to feed into shipping software 5- Upload shipping software sheet into system. 6- generate order sheet with tracking number to feed into external system. 7- Should be able to view pending, fullfillment orders on any dates, date range. 8- create monthly or year to date, cutom range date report for all orders etc. 9- Able to upload supplier inventory sheet in to system on daily basis to check the delta of supplier inventory specially prices and quantity check from back date of data or new inventory. We should be able to track the c...

...individual who can proficiently lend a hand in some aspects of my Computer Science course, specifically labs and exams that utilize Excel and Microsoft Access. Here's what I'm grappling with: - Database design, query writing, and forms and reports design. - Comprehending lab instructions. - Applying theoretical knowledge in practical tests. - Interpreting results accurately. Although I possess intermediate knowledge about Microsoft Excel and Access, these topics are giving me a hard time. The ideal person for this role would be someone who can expertly guide me to enhance my understanding and application of these areas. You would need strong, practical experience in Excel and Microsoft Access, including proficiency in database, forms and reports design, ...

【 overview 】 This time, we would like to ask you to develop a tool that au...hours. [Request details] ・Development details: Please develop a business hours search automation tool system on Google. - Desired function: System image ①Import an Excel file or CSV file containing only phone numbers to the system ② The system automatically searches Google and searches for the information you want, such as business hours search * Desired information → "Business hours", "Closed days", "Reviews" *There are some patterns that Google doesn't have, so I'd like you to add a flag for those cases as well. ③ After the search is complete, the information will be listed in the cell to the right of the phone number. ④Data is exported after the search...

...Design - Graphic Design - UX / UI Design - SEO optimized content Pertinent Features: - My website will house detailed resource guides, so proficiency in organizing and categorizing large volumes of information is essential. - A clean, user-friendly navigation menu to direct users to the relevant guides. - It should be mobile and desktop friendly. This is a great opportunity for designers who excel in developing educational or resource-based platforms....

In my financial business project, I'm looking for a professional to help me schedule 10 to 15 online meetings per week with investors. Key responsibilities include: - Make a list of investor names/emails in Excel; - Collect emails that are actually valid; - Contact investors to collect email addresses. This would be a great opportunity, especially for those who do not have any skills developed to their full potential. If I close a deal with a client who comes to you, you will receive a commission (ranging from US$90, US$180, US$270 or US$360). Are you ready to join my financial journey? Your efforts can lead to fruitful rewards!

Estudiante avanzado o recibido Para realizar las tareas será indispensable contar con: Excel avanzado Disponibilidad horaria para conectarse Conocimientos en plan de cuentas, de gastos, uso se software contable, etc.) Algunas tareas: Tareas fiscales para DGI Contabilidad interna Pasado de comprobantes de compras y gastos Análisis financieros

I need to create an automatic functions to split the data in Excel. Can be created in Excel Macros or VBA

Looking for someone well-versed in Excel for efficient and accurate data entry of quantitative data. Skilled data entry specialists who can handle basic computations will be preferred. Knowledge in Excel formulas or functions might be necessary, but I'm not entirely certain at the moment. - Proficient in Excel - Demonstrable experience in data entry - Ability to perform computations - Knowledge of Excel formulas/functions a plus

...open-source solutions to expedite development, reduce costs, and ensure efficient execution. Key Features of the Web App: - User account management - Wallet management - Deposit/withdrawal management - Referral management - Investment pool management - User profiles management - KYC management App Functionality: The Web App serves as a portal for investors, facilitating onboarding by collecting user data to tailor their experience. Upon account creation, users gain access to a comprehensive dashboard. Here, they can deposit funds, explore available investment pools, and provide liquidity. For insight into our envisioned investment pools, refer to [Centrifuge](). Additionally, the dashboard displays users' latest transactions, pool deposits, and ROI distributions. An affil...

Auditor Appointment & Filing of Form ADT - 01 (Auditor Appointment). Preparation & Filing of Form INC - 20A (Declaration of Commencement of Business). Preparation & Filing of Balance Sheet, P & L Accounts, Audit Report, Director's Report. Preparation & Filing of Extract of Annual Returns & Financial Statements (0-100 transactions) if provided in Excel sheet. Preparation & Filing of Annual Returns Form AOC 04 (Financials Related Annual Return). Preparation & Filing of Annual Returns Form MGT 07 (Management Related Annual Return). Preparation & Filing of Minutes of 04 Board Meeting & Minutes of AGM. Preparation & Filing of Income Tax Returns (Company). FY 24-25 Preparation of Share Certificates (For All Shareholders). Preparation & ...

I need a skilled professional to update my website's stock prices in real-time using excel. The project primarily involves: - Updating numerical data on my website - Ensuring accuracy and real-time updates - Using excel as the data source Ideal candidates will have: - Experience in data updating on websites - Proficiency in excel and data management - A good understanding of stock prices and real-time data management The goal of this project is to enhance the user experience on my website by providing accurate and real-time stock prices.

...Arabic speaker who is proficient in Power BI to help convert an existing Excel file into a dashboard for performance tracking purposes. - KEY RESPONSIBILITIES: The practitioner will be proficient enough in Power BI to translate raw data into accessible and meaningful dashboard visualizations. Highlighting and tracking key performance indicators for strategic planning follow-up is a must for this role. - REQUIRED SKILLS: Understanding of Microsoft Power BI, an eye for design to ensure the visualization is as seamless as possible, and fluency in Arabic. Experience with Excel to Power BI conversions and strategic planning will be considered favorably. - IDEAL CANDIDATE: The freelancer should have a strong background in data analysis and a portfolio or exam...

We need to create an Excel Spreadsheet to track Cash income and expenses. We will begin with a specified amount of cash. First priority is to be able to know at any given time how much cash should be in the petty cash account. Would like to have a space for a weekly balance in order to identify losses or un recorded income/expense in a timely manner. At the end of each week, the keeper of the account will enter the actual amount of cash on hand. This should be subtracted from the recorded expenses and income and a + or - sum generated. (This allows us to catch and correct possible typo's and/or unrecorded income/expense in a timely manner) We want it to generate monthly totals to include Total Cash income Total Cash expenses. The cash expenses should be subdivided...

I'm in need of a freelance bookkeeper fluent in German for approximately 20 hours per week. Key responsibilities will include document research and debtor/creditor management. - Software Proficiency: You should have experience in Excel and a solid grasp of basic accounting principles. - Responsibilities: Duties will involve expense tracking, invoicing, and bank reconciliations. A keen, meticulous eye for detail is a requisite as well as outstanding organizational skills. A flexible, freelancer approach is ideal for this project. This role will suit someone who enjoys piecing together information and has excellent problem-solving abilities. Experience in a similar role would be a great advantage.

I am looking for an experienced Photoshop specialist to accomplish a small task that will take less than two minutes. Your main task will be to modify the content of the text within an image. The modification will involve replacing the existing text with a specific phrase provided upon project initiation. To excel in this job, you need to have a keen eye for detail to ensure precision in text modification and a good command of Photoshop. Fast turn-around would be much appreciated.

I'm seeking a skilled freelancer experienced in data entry and Excel to enter and transform a medium-sized set of customer records and product details. Key Responsibilities: - Accurately enter data, including customer records and product details into Excel templates - Transform raw data into more useful formats and ensure data integrity - Double-check entries for accuracy and fix any discrepancies Skills and Experience: - Expertise in data entry and Excel - Proficiency in transforming and structuring data - Previous experience handling equivalent tasks related to customer records and product details. Your expertise and attention to detail will be critical to ensure the accuracy and usefulness of the resulting dat...

Looking for a ...efficient professional to perform data entry into Excel. The type of data is not specific at this point and could include text, numbers, dates, or a combination. You must have good typing speed, strong attention to detail, and basic knowledge in Excel. Ideal Skills & Experience: 1. Expertise in Microsoft Excel 2. Strong attention to detail 3. High accuracy in typing 4. Experience in data entry Although not necessary, to improve your chances of being considered, you can include in your application: 1. Any examples of similar work you have done before. 2. Demonstrate your level of experience. 3. Provide a detailed project proposal. Currently, it's unclear how many sheets are there in the Excel file. Regardless, yo...

Hello there, We will translate your Google Sheets English (KTO Ad Copy) into Brazilian Portuguese. Thank you!

...from a proficient Excel user who can create two essential templates for me: An invoice template and an expense tracker. For the invoice template, I require the following fields and calculations to be included: - Item description and quantity - Unit price and subtotal - Tax calculations - Grand total I'd appreciate it if macros could be incorporated where needed for automation purposes. For the expense tracker, it needs to categorize various business expenses including, but not limited to: - Food and drinks - Transportation - Office Supplies - Site local purchase expenses The ideal freelancer for this project would have significant experience in Excel, specifically in creating detailed, user-friendly templates for professional purposes. Proficiency in the use...

I'm in search of a skilled data entry operator with an in-depth understanding of Excel's formulas and functions. The project includes both text and number entries which are reasonably simple in terms of their structure. The project details: - Data entry includes less than 500 entries - The structured use of Excel formulas and functions is critical - Both text and numerical data need to be accurately input Ideal candidates will have experience with data entry, Excel, numerical data, and text data processing. Reliability, accuracy, and attention to detail are key for this project.

Hi Umer S., Can you please convert the attached Quote to Excel as you have done for others. Require as soon as possible please.

I'm seeking a skilled freelance Data Clerk to enter and cross check the Korean Fields on a business card, including the key details such as Name, Job title, and Company name, and more. Your responsibilities: - Type all the fields on the business card on a Excel - Ensure the data being filled in the business card is accurate - There are 363 business cards need to type. - Estimated HR needed: 10 hr Sample of the Card:

Do you want to convert any PDF, JPG, PNG, or image files Are you looking for any kind of document conversion or need editing in your documents, You are on the right gig. MY SERVICES: ✅ Data Entry ✅ Web research ✅ Data Conversion ✅ Copy Paste Work ✅ Excel Data Entry ✅ JPEG to Excel or Word ✅ PDF to Excel or Word ✅ Real Estate Data Entry ✅ Language Translator ✅ Microsoft Excel ✅ Microsoft Word ✅ Lead Generation If you still have any questions or want to discuss prices for a custom project, don't hesitate to contact me. WHY ORDER FROM ME?? Fast Delivery, Never Late ✔ Message me if you're unsure or have project-specific questions Thank you

I'm in need of an Excel expert who can help me with a range of tasks. The project involves a large Excel file with over 10 sheets. The tasks include: - Data Analysis: I need someone who can help me analyze the data in the file, looking for trends, patterns, and key insights. - Chart and Graph Creation: I also need charts and graphs to be created based on the data. These should be visually appealing and easy to interpret. - Formulas and Functions: The data file includes a lot of mathematical calculations. I need an expert in Excel formulas and functions to help me with this. Specifically, the type of data analysis needed includes statistical analysis, trend analysis, and comparative analysis. The ideal freelancer for this proje...

More details: What type of data are you looking to have entered? Text How will the data be provided for entry? Digital files What is the preferred format for the final data? Excel

More details: We already have a excel workbook but need to improvise it and make it automated for calculations of XIRR, Investment Holdings, etc with monthly update of transactions User-friendly interface Intermediate to Advanced Skills required

More details: What specific data or information do you want to analyze in Excel? Financial data How do you prefer to receive the analysis results? Formulas What specific calculations or formulas do you need to perform in Excel? advanced & basic

More details: What specific tasks do you want to automate in Excel? Data entry, Data cleaning and formatting, Data analysis How many Excel files do you need to automate? 1-5 What is the approximate size of each Excel file? Less than 1MB

I am seeking the help of a back office staff to assist with a variety of tasks, including data entry, file management, and document organization. The ideal candidate will be able to work less than 10 hours per week. Requirements: - Proficiency in Excel, Google Sheets, and QuickBooks - Previous experience in data entry and file management - Strong organizational skills - Ability to work autonomously and efficiently - Excellent time management skills You will be responsible for maintaining and organizing essential documentation and assisting with other administrative tasks as necessary. This role requires excellent attention to detail, time management skills, and the ability to work independently.

...option for single sign-on (SSO) for ease of use. - Data Visualization: The application will be data-heavy, so I need a developer who can implement maps and geolocation features for effective data visualization. The ability to create interactive dashboards is also a key requirement. - Real-Time Updates: It is crucial that the application supports real-time updates. Users should be able to see changes and updates as they happen without needing to refresh the page. Ideal skills and experience for this job include: - Proficiency in both Django and React, with a strong portfolio of previous projects that demonstrate your skills in these technologies. - Experience with implementing complex user authentication systems. - A deep understanding of data visualiz...

I'm in need of an Excel-savvy individual who can competently create a detailed data entry listing. The purpose of this project is to list email addresses, data input should be as provided without necessarily having to be in any specific order. Along with each email address, you should also input the associated full name. This job requires attention to detail and proficiency in Excel. Previous experience in data entry would be advantageous.

I am in search of an Electronic Engineer to assist me in the development of a prototype. are you able to calculate the wire diameter number of turns to achieve !.8T electromagnetic field on a given material? I am trying to b...stronger, even with double the voltage. Here are the specifications of the core laminations: 0.3mm thickness, 70mm x 150mm, and the core is 70mm x 70mm (radius of 3.949 or diameter of 7.898mm = area of 49cm2). The bobbin is 75mm x 75mm inside for wire radius 6.77cm or diameter 8.4628cm. The sides are radius 6.77cm diameter 13.540, and the length is 150mm. I need your job electronically in Word or Excel Please provide a summary of your relevant experience in your proposal. I look forward to working with a skilled professional who can help bring my projec...

Need to do data entry from chatgpt I to excel spreadsheet. Need basic math and English skills

...hours of dedicated Excel skills Please proceed with reading further, only if you are willing to work hard and devote time to complete the task correctly. It CANNOT be automated or run via a script. It CANNOT be outsourced via code. Please do not waste your valuable time trying to do either. The task: There are 10 Excel workbooks, with approximately 1 million rows each. These contain the data for text messages sent via SMS to customers in the last 1 year. Your task is to sort and separate the messages into different sheets in each workbook. You will create 1 workbook for each month, e.g., messages sent between the first and last day of: 1. April 2023 2. May 2023 3. June 2023 .....and so on The sample workbook is here (). The main data files are here

I need help with a research project focused on the US. The main objective is to gather a list of law schools in the US, along with ...deans. This research should be done on a state by state basis to ensure comprehensive coverage. The main deliverable would be an excel table with all the below information: - Basic information for each law school (name, state, city) - Contact information (general email and phone number) - Emails of deans and assistant deans The timeframe for completing this research project is less than a month, ideally within a week Ideal skills and experience for this job: - Proficiency in using research tools and databases -Attention to details - Strong organizational skills to ensure systematic approach by state - Ability to verify and ensure accuracy of coll...

I am looking for a proficient Excel VBA developer to create a macro that can automate sending payslips to employees on a monthly basis. Key Requirements: - The VBA code should be able to extract the pay information from an Excel spreadsheet and generate a PDF file with the payslip. - The generated PDF file should then be attached to an email that is sent to the corresponding employee. Ideal Skills: - Proficiency in Excel VBA, including the ability to work with PDF files - Experience with automating email sending processes - Strong communication skills to ensure the solution meets our needs. Please note that this project is specifically for creating the VBA code for the payslip emailing system - the design and content of the payslips themselves are already...

I have a CSV file containing 1 lakh records, with each record having a full address. I am looking for someone with advanced Excel skills who can convert these addresses into latitude and longitude. Ideal Skills and Experience: - Advanced Excel skills, particularly in data manipulation - Understanding of geolocation data and coordinate systems - Experience with data analysis and visualization, particularly with large datasets - Proficiency in working with CSV files The latitude and longitude data will be used primarily for data analysis. The final output should be in CSV format, which I will then use for further analysis. Given the large number of records, efficiency and accuracy are essential.

We are looking to hire individuals to assist u...are looking to hire individuals to assist us with product data management on our bigcommerce site. The job is as follows: Receive product data sheets from manufacturers Match up product data from manufacturers to our product data sheet using an existing template Adjust product data for SEO optimization Locate, and do light editing on product images To confirm you have read this job posting please put the word pineapple in your response. Experience with automotive ecommerce sites is preferred but not required. You must have excellent attention to detail, and be able to work quickly. We have tens of thousands of products to onboard so it is imperative that you are familiar with best practices in Excel ...

I am seeking a freelance Excel expert to assist me with a project that involves intermediate-level use of Excel formulas and functions. The ideal candidate would be able to automate the process fully.

I require competent services for data transcription. This project involves the transcription of data from a total of 265 JPEG images into an excel spreadsheet. Example Jpeg attached. The Details: - The JPEG images contain a combination of both text and numbers. - An integral part of this project is that the data from each image should be transcribed into a separate tab on the Excel spreadsheet. Key Qualities: - Proficiency in data transcription from images (JPEG) is essential. - Advanced skill level in Excel data management. - A keen eye for detail to ensure text and numbers are accurately transcribed. Thus, if you possess a high attention to detail and proven proficiency in this kind of work, I invite you to make your bid.

...am seeking a skilled TEAM of professional to migrate my Magento 1 website, with an emphasis on enhancing the overall user experience. If your message includes "I'm a full stack developer" - you will not be selected. This is NOT a 3-7 day project. Just sharing all credentials and evaluating the project is likely going to take a little time. We want a realistic time frame please. There is no data to migrate. No transactions, no products. There is no plugin that is worth keeping on the Magento 1. We are calling this project a "migration" because there is already a site that exists () but really, we are expecting a website created within our already existing Magento 2 platform. We expect to use the "multi-site" function of Magento 2. Dee...

I am looking for an experienced freelancer to create a comprehensive hiring tracker on Excel. The tracker should be linked with PowerPoint and automatically update the slides. Additionally, I need a detailed dashboard that displays the following data points about the hiring status: - Number of applicants - Stages of the hiring process - Open vs filled positions Furthermore, I would like the dashboard to include some extra information, specifically: - Source of applicants - Diversity statistics The ideal candidate for this job should have a strong background in Excel, PowerPoint, and data visualization. Experience in creating automated systems and dashboards for recruitment or HR purposes will be highly appreciated.

I'm in need of an experienced Shopify expert to refresh, redesign, and update my already-established Shopify store. Here's what I'm specifically looking for: - A complete revamp of the site layout including a redesign of the homepage and improvement of the navigation menu. I am looking for innovative and customer-friendly designs using shopify themes with knowledge of HTML, CSS, and Liquid programming language for Shopify theme customization - Integration of new functionalities plug-ins that can significantly enhance the user experience such as: - Payment gateways (e.g., PayPal, Stripe) - Shipping calculators and fulfillment services - Email marketing and customer retention tools (e.g., Mailchimp, Klaviyo) - Product review and social proof plugins ...