Excel vba refresh data sheetslavori

I'm seeking an analyst proficient in harnessing the Amazon Seller API to extract comprehensive data and metrics essential for reporting purposes. Your primary responsibility will involve pulling detailed information from Sales, Orders, Products, Customers, and other relevant sources via the API. Your expertise in navigating the intricacies of the Amazon Seller API to extract pertinent data for reporting is crucial. This data needs to get into Microsoft Excel seamlessly and effortlessly. This will enable easy access and manipulation of the data for reporting purposes. I'm seeking a freelancer with experience in the Amazon Seller API to pull back data and metrics - all columns of data related to Sales, Orders, Products, Customers...

I am looking for a seasoned programmer who can create a Linux-compatible automobile dashboard system for me. Key Features: - This dashboard system should primarily function as a complete drive system. - The programmer should have extensive knowledge in developing user-friendly interfaces for automobile dashboards. Desired Skills and Experience: - It is advantageous if the p...is advantageous if the programmer has a comprehensive understanding of Linux operating systems. - Previous experience with automobile dashboard programming, particularly with complete drive systems, is highly desired. - An ability to produce quality work in a timely fashion is mandatory. With the right skill set and experience, someone with a passion for innovative automobile technology should excel in thi...

I need assistance with my Excel data. Unfortunately, I haven't specified the exact issue I'm facing. However, I'm looking for a freelancer with advanced Excel skills. Ideal Freelancer: - Should be proficient in Excel - Ability to handle a variety of data-related tasks - Strong problem-solving skills - Experience in working with large datasets Please include a detailed project proposal in your application. This will help me understand how you plan to address my data-related challenges.

I am seeking a skilled and reliable data entry specialist for a part-time position. Key Job Details: - This is a remote work opportunity, so you will need a stable internet connection and a quiet workspace to work from. - The role will involve inputting data accurately and efficiently, so a keen eye for detail is essential. - The successful candidate should ideally have prior experience in similar roles, and be able to provide examples of past work. Ideal Skills and Experience: - Proven experience in data entry is a must - Strong attention to detail - Ability to meet deadlines - Proficiency in Excel or Google Sheets is a plus, but not mandatory

I'm looking for a software that can be designed within Excel to track daily sales and present a detailed profit calculation per liter of petrol. Key Features: - Daily Sales Tracking: The software should enable manual entry of daily sales figures for accuracy. - Profit Calculation: The software should generate a detailed report on profit per liter of petrol sold. - Remining fuel in tank also show - calculate auto profit in the tank Ideal Skills: - Proficiency with Excel including advanced formula writing, data organization, and report generation. - Understanding of petrol pump operations and metrics. Note: While the project is to be developed in Excel, suggestions for potential future software integration are welcome.

I am looking for Excel experts who can assist me with creating formulas and functions within a week. I have wholesale mobile shop. I want excel works for example desboard in one sheets and custumer sheets which contain debit credit ,describtion and total amount one more important all costumer name on desboard and if debit or credit amount also show on desboard please also look for attect excel file

...like Eventbrite, etc. - Managing community comments. - Meeting with the team on Zoom. Criteria: - Excellent English skills, both in writing and speaking. - Strong organizational skills. - Fast internet connection. - Team player with a sense of humor. Tools: Candidates should be comfortable using: - ChatGPT - WordPress - Social media scheduling apps such as Later, Hootsuite, Loomly, etc. - Google Sheets, Docs, etc. - Discord Work Hours: - Our primary team operates in the Eastern Standard Time (EST) zone. - You are free to work whenever and wherever you want. - Mandatory handoff meetings occur throughout the week to answer questions and provide updates. Hiring Process: We welcome all applications. We conduct a series of interviews via Zoom to get to know you better. Following t...

...classes accordingly. About the work from home job Selected intern's day-to-day responsibilities include: 1. Interacting with the parents and students and pitching them about course 2. Generating Leads from marketing 3. Strategizing and creating plans to reach out to our prospects 4. Reporting about the progress daily Skill(s) required: English Proficiency (Spoken) English Proficiency (Written) MS-Excel Who can apply: Only those candidates can apply who: 1. are available for the work from home job 2. can start the work from home job between 27th Apr'24 and 1st Jun'24 3. are available for duration of 1 month 4. have relevant skills and interests * Women wanting to start/restart their career can also apply. Language known: English & Hindi Other requirements...

I'm seeking an experienced individual to complete a text data entry project on Excel. You will receive all necessary data in a digital format, so proficiency in managing and manipulating digital data is critical. You should have the following: - Strong experience with text data entry - Expert familiarity with Excel - High attention to detail - Ability to work accurately and efficiently Your core responsibility will be to accurately input provided text data into an Excel spreadsheet. Prior experience in similar roles will be highly favored. I look forward to your bid.

Basic Project Overview: This project aims to create an online shop where university students can purchase study aids. These include physically distribute...be picked up at specific locations at the university. Security and Privacy: • Robust security measures will protect students’ personal and payment information within the online shop. Management and Distribution: • Administrators will manage payments and track which students from specific universities and academic programs have paid. This organization will be facilitated ideally through an Excel spreadsheet, enabling efficient organization of the distribution of physical materials. This project is for a French audience, so it would be better to create it in French (you can use AI), and ensure it is easy to ...

I'm looking for an excel expert to help build and format an advanced product database for the services industry. I already have an existing excel spreadsheet with many items already programmed so this will just be added on. This will revolve around three main components: -Product database containing items -Drop down menu to insert products from database -Custom Graph A strong working knowledge of Excel features, particularly Pivot tables, VLOOKUP function and conditional formatting is a necessity. It would be ideal if you also have experience in data management for the services industry. Your expertise will enable the creation of an effectively organized and easy-to-manage database.

I'm in need of an expert data entry professional who can help me with my data entry task. - I have a significant amount of data in an Excel spreadsheet that needs to be entered into a new system accurately and efficiently. - The work involves transferring the information from the spreadsheet into the new system, and maintaining the integrity of the data throughout the process. - Attention to detail is a key requirement, as any inaccuracies in data entry could have serious implications. - Experience working with Excel spreadsheets and handling large volumes of data is essential for this project. If you are a diligent and experienced data entry operator who can ensure the accuracy and completeness of the data en...

I require an expert in Excel financial calculations to design a spreadsheet to calculate commission on sales. The main purpose is to drive commission payments based on a tiered structure. It will be used to manage commission payments linked to sales figures above a specified target. Ideal Skills: - Extensive experience in Excel spreadsheet design, particularly with financial calculations - Experience in tiered commission structure calculations - Strong understanding of financial data management. Responsibilities: - Design and implement Excel spreadsheet for commission calculations - Ensure accuracy of calculations based on the tiered commission structure.

I am in need of a part-time bookkeeper/data entry specialist to help with monthly financial tasks. - Software: We use Excel for our bookkeeping and data entry tasks. - Frequency: The assistance will be required monthly, making it a recurring project that's ideal for someone seeking a consistent workload. - Tasks: The primary duty will be logging daily financial data for the monthly income. This includes categorizing, reconciling, and ensuring the accuracy of the data. Batches will be sent monthly and need to be processes within 72 hours of receiving . Ideal candidates should have: - Proficiency in Excel is a must. - Experience in bookkeeping or data entry, preferably for small businesses. - Excellent attention to detail and accuracy...

I am looking for a certified Excel and VBA expert to help me refine an existing financial model. I am looking for a two-days online working engagement where the person will sit with me online and solve for things one at a time. For Faridabad, Haryana based freelancers, we can do it in physical mode too. Key areas of focus will be: - Refining Formulas and Calculations. - Improving Data Organization and Management - Managing , improving the existing VBAs

I'm in need of an expert in...include text styling, background color, or layout positioning, among others. Core of part of work that needs doing is defining style sheets so what the user sees is what gets printed! You will need to modify the code in an offline area and then i will import into the live system. I will provide CSS file and html snap shot of pages. We need to be able to print what we see on the screen the exact same way it is displayed. Currently we use saved 'pdf' files to print labels and we are trying to generate these at runtime. We can now generate them fine, but the last step, getting them printed requires some modification and manipulation of the css / style sheets and elements. See the attached screen shots for what i am referring t...

I'm looking for an Excel expert to assist me with data cleaning tasks and applying conditional formatting in my Excel spreadsheet. Key Tasks: - Remove blank rows and columns: The spreadsheet has some unnecessary empty rows and columns that I need to be removed to make it more concise and easy to manage. Ideal Skills and Experience: - Proficiency in Excel: Expertise in Excel 2010, 2013, 2016 or later versions is a must. - Data Cleaning: Experience in data cleaning tasks, particularly removing blank rows and columns, is highly desired. - Conditional Formatting: Ability to set up conditional formatting to help me visually identify and manage data more effectively.

I am seeking an experienced Excel professional to set up a comprehensive spreadsheet for tracking various scooter specifications. Given data must include the following: - Brand - Model - Engine Displacement - Maximum Speed - Weight Capacity - Availability in Different Colors: This will need to be formatted such that each color has its own individual column. - Price: The price listed should reflect the Manufacturer's Suggested Retail Price (MSRP). - Additional Features: This may include factors like ABS, Bluetooth connectivity, etc. - Fuel Efficiency: Recorded in km/l or mpg. The ideal candidate will have proficient skills in data organization, Excel formatting, and data entry. Experience in automotive or scooter industry will be beneficial.

I have a step-by-step procedure, currently in PDF format extracted from Excel, that needs to be transcribed into a Word document and then formatted into a professional presentation. Detailed Requirements: - The content to be transcribed is text only. - The final formatted document should be in PDF format. - The presentation should be designed with a flexible layout, featuring one or multiple procedures per page, depending on the length of each procedure. Ideal Candidate: - Proficient in Microsoft Word and PDF formatting - Experienced in creating professional, clear, and concise presentations - Strong attention to detail - Capable of judicious layout design.

...am looking for an Excel expert to help me create a custom ELO ranking system for our pool and other sports. The system should integrate seamlessly with Excel for easy data input and allow us to rank players based on their performances in these sports. We need an Excel system that will integrate with our app. We need the Excel to stand alone as a backup to our app and test the ranking system before integrating it completely into the app. The players will use a paper scorecard to record the match, and then we will enter the game information into the Excel template to track and update players' score and rankings. Ideal Skills: - Proficiency in Excel to develop complex ranking formulas - Previous experience in creating ELO ranking...

I'm looking to engage with a skillful Excel whiz who excels (pun intended) in a variety of Excel formulas. In particular, I need someone who has proficiency in: - Average and standard deviation for each part - Average and standard deviation parts total by invoice - Average and standard deviation trip charge - Average and standard deviation Material markup % - Average and standard deviation Hours - Average and standard deviation Installation labor - Average and standard deviation Non-installation expenses - Average and standard deviation Other fees - Average and standard deviation Freight

For this project, we need an expert in data analysis who can help us make major strategic decisions by identifying trends, patterns, and evaluating performance. We are yet to finalize the specifics of the data being analyzed, but you should be prepared to handle diverse data sets. Key Responsibilities: • Data interpretation and analysis • Report generation and presentation Required skills and experiences: • Proficient in Microsoft Excel and Python • Demonstrated experience in data analysis • Strong ability to identify patterns and trends • Excellent problem-solving skills Further information regarding the data to be analyzed and the purpose of the analysis will be provided as we proceed.

...of a freelancer who is proficient in Microsoft Excel to create 3 comprehensive pro forma sheets and 4 sensitivity analysis sheets. The purpose of these sheets will be for financial forecasting, specifically in a year-by-year breakdown. Ideal Skills: - Advanced Microsoft Excel proficiency - Previous experience in financial forecasting - Attention to detail - Excellent analytical skills Please note, the project entails: - Creating 3 pro forma sheets - Developing 4 sensitivity analysis sheets - Ensuring a year-by-year breakdown for the financial forecasting - Providing a high level of accuracy and attention to detail - Adhering to deadlines with commitment If you have a solid background in financial analysis and are proficient in Microsof...

Estoy buscando un experto en Excel para realizar cálculos de ventas y rendimiento. Es importante que el freelancer tenga un sólido conocimiento en: - Realización de cálculos en planillas de cálculo Excel. - Generación de informes de ventas y análisis de rendimiento. Las funciones específicas de Excel a utilizar serán determinadas de acuerdo a los trabajos a realizar. Las habilidades con diversas funciones de Excel (suma, promedio, porcentaje, ordenamiento, etc.) son idóneas para realizar los cálculos de manera eficiente. La precisión y la rapidez son características esenciales para este proyecto.

I have a large number of scanned images that I need to be translated into an Excel spreadsheet. The data in these images need to be sorted and inputted in a clear, organized manner. Specifically: - You will be given scanned images of textual data that need to be translated into Excel. - It will be vital that you have a great attention to detail, ensuring that all data is accurately entered. - The data will need to be sorted in a logical manner within the spreadsheet. If you have experience in data entry, especially into Excel, and if you can show a portfolio of similar work, I would be interested in hearing from you.

...run, send me the Visual Studio project, and I am able to run it on my own system. Here's my end goal for the project, just to give you a better idea, however you won't have to do this, I'll describe what I need done in the next paragraph: Open excel, button in Excel add-in that you click, opens file explorer, you pick a local document on your system, it will upload it to Azure form recognizer, the returned results will be dumped into the current excel sheet. What you have to do: I'll give you the (very minimal) code I have, which essentially one excel launches, picks a pre-defined file on the system, like an invoice or something, uploads it to Azure formrecognizer, and returns the result in the debug console. The problem is that I can�...

I need an experienced professional to build a comprehensive excel model for financial analysis. Key Requirements: - The model should primarily focus on budget forecasting and commission analysis. - It should be designed for annual updates, therefore, it should be easily understandable and modifiable. Ideal Skills and Experience: - Proficiency in Excel and financial modelling. - Strong understanding of budget forecasting and commission analysis. - Experience in building user-friendly, efficient excel models. This project is suitable for someone who has a strong background in finance, as well as a proven track record in creating advanced financial models using Excel. A keen eye for detail and the ability to deliver a high-quality, user-friendly deliverable is e...

I need help creating a CSV file or Excel data sheet. I need a professional who can assist with: - Creating a CSV file or Excel data sheet - Formatting the data accurately - Ensuring the file is easily accessible and understandable - Potentially, assisting with data input This project may require someone with a good eye for detail, data management skills, and experience with Excel or similar software. Please apply to discuss further.

I'm in need of a freelancer who can create a CSV or Excel file for the ecommerce platform we're using. While we haven't decided on the specific data types yet, it's likely the file will include product, pricing, and inventory information. I highly value the skill and experience over promises. So, in your application, please provide examples of past work in this area rather than comprehensive project proposals exclusively. Although we didn't specify whether we need a test file before the start, we're flexible in this area, and are open to discussing what works best for the freelancer in correlation to their workflow. Experience with ecommerce platforms would be advantageous, as well as strong attention to detail and ability to work within timel...

I want a formula in column D of the attached spreadsheet to convert the date in column C to DD/MM/YYY

...custom order form in Excel. Though the specific features were not clearly defined, freelancers would potentially be working on creating dropdown menus, calculation formulas, and conditional formatting. Key Skills: - Proficiency in Excel - Previous experience in creating Excel forms Responsibilities: - Building dropdown menus - Establishing calculation formulas - Implementing conditional formatting Data Capture: The successful form should be able to capture: - Customer details - Product details Applications should include examples of past works similar to this project for review. Your understanding and experience in handling similar projects will greatly contribute to the success of this one. THIS IS AN EASY ASSIGNMENT. JUST NEED TO RE DO AN O...

...for the following: - Dashboard Functionality: The system should feature an intuitive dashboard with the ability to upload and manage email lists. This is crucial as the system will be used to send emails to a large database of recipients. - Email Sending: When sending emails, I want the system to allow me to manually select and attach a file to each email. - emails list will be upload through excel sheet - Email Appearances: The emails sent through this system should mimic regular emails in appearance. This means the sender name, subject title, and general layout should be similar to a typical email, to increase the likelihood of engagement and reduce chances of being marked as spam. Ideal skills for this project include experience with integration of server provider APIs, d...

I'm seeking an excel expert to handle high-volume data entry and organization tasks in an excel sheet. Key Requirements: - Data Entry and Organization: The primary task is to input a large volume of data and ensure that it's correctly organized. This includes dealing with more than 10 columns or multiple sheets, hence, experience and comfort working with complex data is crucial. - Cleaning: I need the data to be cleaned and correctly formatted. Ideal Skills and Experience: - Proficient in Excel: Extensive experience working with Excel and handling complex data structures. - Attention to Detail: The ability to accurately input and organize data. - Prior Experience: Previous work on similar pro...

I am in search of a proficient financial analyst knowledgeable in financial modeling and investment analysis. The successful candidate should have a keen eye on assessing financial risks and make informed decisions. The provided data for analysis will include balance sheets, income statements, and cash flow statements. Proficiency in Excel is highly crucial for seamless execution of tasks. Experience in financial analysis and modeling, risk assessment, and investment analysis will be beneficial. Able to work with Excel is a must-have. The ideal candidate should demonstrate attention to detail, understanding of financial trends, and maintain confidentiality. Accuracy is vital in all these processes.

I'm seeking an experienced Excel macro specialist to take on a key role in automating my work tasks. Let's dive into specifics: I have given Start time, Interval, End time in excel When i give start time(Ex:9:15), when that time reached E col data automatically copied in into G col, Next Interval is 10 Mins, When 9:25 reached E col data automatically copied in into H col, When 9:35 reached E col data automatically copied in into I col,When 9:45 reached E col data automatically copied in into J col, When 9:55 reached E col data automatically copied in into K col, When 10:05 reached E col data automatically copied in into L col, When 10:15 reached E col data automatically copied in into M col.(H col vale > G col, ...

As an enthusiast of Australian horse racing, greyh...analyze selected Australian races. The ideal applicant should have excellent knowledge of: - Web scraping, to gather necessary information - Machine Learning, to ensure the tool's precision and adaptability - Discord bot and automation, to streamline the application's operations and real-time info delivery Having experience with Google Sheets API and databases is advantageous, though not a requirement. Expertise in these tech fields will make the application’s data gathering and management process considerably more effective. A passionate professional who understands the ins and outs of Australian races is preferred, but not mandatory. Get in touch if you can build this precise EV finder application. ...

I'm looking for a Google Sheets expert who can create formulas, automate data calculations, and provide data analysis and reporting. The successful freelancer will need to automate data input from a website or database. Ideal Skills & Experience: - Proven expertise in Google Sheets, particularly in formula creation and automation. - Experience in data analysis and reporting. - Demonstrated ability to automate data input from websites or databases. - Strong communication skills and ability to provide detailed project proposals.

export WooCommerce orders to Google Sheets Emphasize that users should be able to filter orders by status and customize the data they want to export. Functional Requirements: Real-time synchronization: Orders should be exported to Google Sheets as soon as they are created or updated in WooCommerce. Filtering options: Users should be able to filter orders based on their status (e.g., pending, processing, completed). Customization: Users should have the ability to choose which data fields they want to export to Google Sheets (e.g., order ID, customer name, product details, order total). Error handling: The system should handle any errors gracefully and provide informative error messages to users if there are any issues with the export process. Expectations...

Refresh of an internal screen we use for monitoring please. Details to follow.

I'm in need of an experienced Power BI expert to assist me in creating daily reports from Excel/CSV files. Key Responsibilities: - Develop daily reports using Power BI, based on data in Excel/CSV files. - Ensure that the reports are insightful, visually appealing, and easy to understand. - Provide assistance in setting up an automated process for updating the reports on a daily basis. Ideal Candidate: - Proven experience in Power BI, specifically in report creation. - Proficient in managing data from Excel/CSV files. - Capable of creating visually engaging and informative reports. - Familiarity with setting up automated daily updates is a plus.

...construction process. So I have in total 3 of the work but first I need to make sure that process of building home template is good of work to give other 2 work after this. See below attached pdf of Google sheet which I have made step by step **Requirements** 1. **Automate Data Entry:** Currently, data is input manually or copied and pasted into our template. I'd like to have this process automated, significantly reducing time and minimizing human error. someone experienced with: - Data management automation - Google Sheets and other Google applications - Coding if necessary for complex automation tasks 2. **Automate Calculation Formulas:** The template uses both basic arithmetic like addition, subtraction, multiplication and division, and stat...

I'm looking for a skilled Excel expert who can create a sales-focused dashboard in Excel. Key Requirements: - Data Visualization: The dashboard needs to present sales figures in an engaging and easy-to-understand manner. - Regular Updates: The dashboard should be designed to be updated monthly, so it should be able to handle new data efficiently. Ideal Candidate: - Proficient in Excel: A strong understanding of Excel's charting and graphing capabilities is a must. - Data Visualization Expertise: Prior experience with creating visually appealing and informative dashboards is highly preferred. - Attention to Detail: The ability to ensure accuracy and consistency in the representation of data in the dashboard is critical.

I need an Excel macro that will primarily handle formatting and sorting data, and to be used on a daily basis. Key Responsibilities: - Developing a macro to automate formatting and sorting of data in Excel 2019. - Ensuring the macro is optimized for daily use, with minimal errors and efficient performance. Ideal Skills and Experience: - Strong expertise in Excel macro development. - Prior experience creating macros for daily use. - Proficiency with Excel 2019 is a must. - Attention to detail and thorough testing skills. Looking for a developer who can deliver a robust, reliable solution that can handle repeated daily use without any issues.

...help me set up a real-time inventory updating system between Google Sheets and SAP MM. The inventory data is available in CSV or Excel format and needs to be updated into both platforms with the specific format I have in place. Key Tasks: - Develop a real-time synchronization system between the Google Sheet and SAP MM - Ensure the data is accurately transferred in the specific format I have defined - Troubleshoot and provide support for any issues that may arise during the implementation Key Skills: - Proficiency in Google App Scripting and Google Sheets API - Experience in SAP MM module and data synchronization - Strong understanding of CSV/Excel data processing and transformation - Ability to work with a predefined data ...

I need a freelancer to assist me with an online data entry project. - The data will be provided via email and will be in PDF format. - Your primary task will be to transfer the provided data accurately into a spreadsheet. The ideal candidate for this position should possess: - Proficiency in data entry and a keen eye for detail. - Experience working with PDF documents and Excel spreadsheets. - Good communication skills, as the project details will be shared and discussed via email. This project could potentially lead to more work in the future, so I'm looking for someone who is committed to delivering quality results in a timely manner.

I am looking for an expert data entry freelancer who can efficiently and accurately transfer text data into a Microsoft Excel format. - The final delivery should be in a Microsoft Excel file format. - The preferred data structure in the Excel file should be row-wise. - Excellent attention to detail and proficiency in Excel is a must for this job to ensure data is entered correctly. I look forward to working with someone who respects deadlines, has a solid understanding of data entry requirements, and values quality service. This project could lead to long term engagement if successfully completed.

I have a large dataset containing information for various clubs. I need an Excel expert to set up club-specific auto-filters for me. Key requirements: - Set up a step-by-step guide to create auto-filters in Excel for specific clubs. - The Excel version can be 2010, 2013, or 2016. Ideal skills and experience: - Proficiency in Excel, particularly in setting up auto-filters. - Strong attention to detail. - Familiarity with data analysis and sorting. Please include past relevant work and experience in your proposal.

I need a web scraper to extract text from a provided list of URLs on a Google Sheet. - The URLs will be provided in a list. - The scraping should be done only once. Your tasks: - Scrape the text from the URLs. - Update the Google Sheet with three columns: URL, Title, and Text scraped. - If a URL doesn't contain any text or l...on a Google Sheet. - The URLs will be provided in a list. - The scraping should be done only once. Your tasks: - Scrape the text from the URLs. - Update the Google Sheet with three columns: URL, Title, and Text scraped. - If a URL doesn't contain any text or leads to an error page, please skip it and move on to the next URL. Key skills: - Experience in web scraping. - Proficiency in Google Sheets. - Attention to detail to handle exceptions as p...

I'm in need of an expert data entry professional who can help me with my data entry task. - I have a significant amount of data in an Excel spreadsheet that needs to be entered into a new system accurately and efficiently. - The work involves transferring the information from the spreadsheet into the new system, and maintaining the integrity of the data throughout the process. - Attention to detail is a key requirement, as any inaccuracies in data entry could have serious implications. - Experience working with Excel spreadsheets and handling large volumes of data is essential for this project. If you are a diligent and experienced data entry operator who can ensure the accuracy and completeness of the data en...

...contact them to introduce our service. You have to find the leads and also call them Your main task is to convince potential clients that a website will help them boost their business. You don't have to talk about prices or updates that they may need in their website or details. After they understand the value of a website you give them our email and you take theirs. Also you are required to make an excel list with businesses you called and if they accepted or not Tip: If you don't know a way to find businesses you can go to Google maps and search for small businesses around you. Sometimes if you click on them they have their website link. If they don't, it means they don't own a website so you can cold call them and introduce our service. We sell each web...