Sheet refresh vba excel 2007công việc

I'm looking for a data-savvy professional to assist me with analyzing and processing some wine investment fund data. Key Responsibilities: - Data entry: You'll be entering data from Excel spreadsheets into other required formats or systems. - Financial Analysis: You'll need to interpret the data and provide insights into trends, valuations, and potential investment opportunities. - Investment Research: I need you to conduct thorough research on possible investment opportunities within the wine market. Skills and Experience: - Proficient with Excel and other data processing tools. - Strong understanding of basic finance and investment concepts. - Prior experience in analyzing financial data and conducting investment research is a plus. - A passion for wine or...

I will add these features on the Form - * Please add the header content, logo & steps to use the form as provided in the reference excel sheet. * The user should be allowed to fill the form only if the selection is 'Yes' * Please check the verbiage in the first page (Specially under Residency information - Canadian tax return (also check the order of questions here) & Residency information -US tax return) * In UN25, the selection should be a tick mark instead of just a dot. * Changes regarding the appendix as discussed in the call and also as highlighted in #3 in our previous mail. *U9 to U39, UN1 to UN25 (when a user clicks on the 'Yes', the alert box is not changed as per the previous requirement. I guess you have missed from the previous requ...

...space) to load the data in a postgres database. 2. Scrape reviews of products from the (CWH) website and store them in the database. 3. Look up the availability of the product in specific stores and write the boolean value in the postgres database. (code attached - ) [Phase / Milestone 2] 4. Once this data is scraped, I then move it to a Google Sheet where I run a script to enrich the data using ChatGPT. I want to reduce these steps or make them efficient so that it can be done within the postgress / python application. 5. Install (it is like an airtable frontend for postgres) - to provide me with a frontend that will help me modify the prices and any other changes to the data - before pushing it to Shopify via API. You must be

I'm in need of a Python script that can download an Excel report from a public website every hour and upload it to a designated portal folder without any modifications. - **Task**: Script should perform the following tasks - Download an Excel report from a public website every hour. - Upload the report to a specific portal folder without any modifications. Ideal Skills: - Proficient in Python programming. - Prior experience with web scraping and automating tasks. - Familiarity with working with Excel files in Python. - Knowledge of file upload protocols and processes.

I need someone to convert my 28 page bank statement from PDF to Excel. - You will need to extract all details from the bank statement. - The data should be formatted into a standard table format on Excel. - No further data processing is required after extraction. Ideal candidates will have: - Experience in data entry and PDF to Excel conversion - Attention to detail to ensure all information is accurately captured. check sample

I'm looking for a skilled Virtual/Administrative Assistant to support me, a busy C-Level Executive. The ideal candidate should possess 3-5 years of experience, particularly in: - Project Management - Business Calendar Management - Copywriting - Task Prioritization - Researching - Personal Task Management (Daily, Weekly, Monthly) - Proficiency in Microsoft Office Suite (Excel, Word) - Excellent Typing Skills - Coordinating Contacts Meetings - Outbound Phone Support - Data Entry (with Excellent Accuracy) - Other Related Business Tasks To start with, I require 5-10 hours a week. The most crucial skills for this role are Project Management, Calendar Management, and Copywriting. Your primary focus will be on managing my business calendar, so experience in this area is vital. Add...

We are seeking a skilled data professional to compile a comprehensive database of recently registered domain names along with relevant ownership or business details for the purpose of targeted outreach and lead generation for website development services. Database Scope: Collect domain registration data with a focus on re...sources such as WHOIS databases, expired domain lists, and domain auction sites. No data collection that violates GDPR, CCPA, or similar data protection laws. Preference for data from businesses requiring web development services. Data Accuracy: Ensure data is as up-to-date and accurate as possible. Remove incomplete or redacted records from the final dataset. File Format: Deliver data in CSV or Excel format. Proper column segregation and labeling for easy ...

I'm looking for an Excel sheet that can help me track daily sales for my pizzeria. The sheet should be user-friendly and structured in a way that allows for easy data input and analysis. Key Requirements: - The Excel sheet should be designed specifically for sales tracking. - It needs to accommodate daily sales data. - It should be able to present the data in tables. - The design should be clean, simple and easy to use. I have an existing sample , if you like Ideal Skills: - Proficiency in Excel - Experience in designing sales tracking tools - Ability to present data clearly and logically Please note, the primary purpose of this Excel sheet is to keep track of my pizzeria's daily sales. It should not include any unnece...

I'm looking for an expert in Excel to create a comprehensive bidding sheet for my concrete company. The sheet should be able to accurately calculate labor costs, material costs, and time estimates for different projects. Key Features: - Formulas and calculations: The sheet should include necessary formulas to automate calculations and ensure accuracy. - Conditional formatting: This feature will help in easily identifying key data points or alerts. - Graphs and charts: Visual representation of data will be beneficial for understanding project estimates and costs at a glance. Templates: The Excel sheet should also include templates for: - Bid proposals: A pre-formatted template that I can use for submitting bids. - Invoicing: A template for cr...

I need someone to convert my 28 page bank statement from PDF to Excel. - You will need to extract all details from the bank statement. - The data should be formatted into a standard table format on Excel. - No further data processing is required after extraction. Ideal candidates will have: - Experience in data entry and PDF to Excel conversion - Attention to detail to ensure all information is accurately captured. check sample

Vui lòng Đăng Ký hoặc Đăng Nhập để xem thông tin.

I am currently working with a budget model and need a financial modeling expert to help me complete a sensitivity analysis. The variables that need to be includ...working with a budget model and need a financial modeling expert to help me complete a sensitivity analysis. The variables that need to be included in the sensitivity analysis are: - Revenue growth rate - Operating costs - Interest rates The analysis should be conducted in Excel. Ideal candidates will have extensive experience with financial modeling, particularly with budget models, and be able to conduct a comprehensive sensitivity analysis. Proficiency in Excel is a must, and familiarity with advanced Excel functions and techniques will be an asset. Please provide examples of similar projects you&#...

I need a skilled Desktop Support Engineer for Windows 11 installation, hardware troubleshooting, and MS Office setup. Your responsibilities will include: - Installing Windows 11 on various desktops - Troubleshooting hardware issues as they arise - Installing and configuring MS Office applications (Word, Excel, Outlook) - Setting up printers and configuring computers Ideal candidates should have: - Proven experience as a Desktop Support Engineer - Strong knowledge of Windows 11 and MS Office - Excellent problem-solving skills - Ability to install and configure printers Please provide evidence of your relevant experience and your approach to troubleshooting hardware issues.

I'm seeking an Excel expert to develop a spreadsheet that will assist with calculations and comparisons for our purchases. Key Requirements: - The Excel sheet should be able to help us make comparisons and use logic to decide whether to place orders. - Data inputs will include product prices and quantities, supplier details, as well as purchase dates and times. - A primary function of the sheet will be to carry out price comparisons between different suppliers. Ideal Skills: - Proficiency in complex Excel formulas and functions. - Experience in data analysis and comparison. - Ability to create user-friendly and efficient Excel models.

I need a professional, mixed media video demonstrating the stepwise process of fitting solar panels. This should include how to fit the monorail, followed by the installation of the panel with both end clamp and mid clamp on a roof sheet. The same process should be shown for an RCC rooftop. Key aspects of the project: - The video should be visually appealing. While clarity of instructions is important, the overall visual appeal of the video is paramount. - The video should include both voice-over narration and on-screen text. The voice-over should provide clear, concise instructions, while the on-screen text should reinforce these points. Ideal candidates for this project should possess: - Extensive experience in creating mixed media videos, particularly in the realm of educationa...

I'm looking for a Windows program that can download data from the 'Individuals' sheet of the provided ODS file link and replace this data in a SQL Server 2019 table with compatible fields. The program should execute this process daily at 06:00 am. Key Requirements: - Windows based program - Data download from the specified ODS file - Data replacement in SQL Server 2019 - Daily automation at 06:00 am - No notifications after data processing - No logging required

As a Singapore-based company, I require a complete suite of accounting services, including financial reporting, preparation of all necessary financial documents, and full tax filing assistance. Key Requirements: - Financial reporting: I need regular, detailed reports on the company's financial status. - Financial Reports: The reports should include a Balance Sheet, Profit and Loss Statement, and Cash Flow Statement. - Tax Filing: I need full assistance with tax filing services. This includes preparation, submission, and any necessary correspondence with tax authorities. Ideal Skills and Experience: - Expertise in accounting and financial reporting - Experience with Singaporean tax laws and filing processes - Proficiency in preparing comprehensive financial reports - Prior ex...

Description: We are seeking an experienced Financial Modeling Consultant with in-depth knowledge of affordable housing developmen...layering. Familiarity with compliance and reporting requirements for state and federal programs. Exceptional analytical and problem-solving skills. Excellent communication skills and ability to explain financial concepts clearly. Preferred Qualifications: Experience working with LIHTC, HUD, or other Florida-specific housing programs. Background in real estate finance or development. Proficiency in Excel and financial modeling tools. Deliverables: A refined or new underwriting model for affordable housing projects. A detailed report outlining recommendations and insights for financial decision-making. Ongoing support for financial strategy discussions ...

I'm in need of a skilled Excel VBA developer to create a macro that transfers numerical data from one Excel workbook to a second one on a daily basis. The macro should be designed to bring over all data from the source workbook. In addition, I would appreciate written instructions on how to recreate the macro in the event of a break. This project requires a clear understanding of Excel, VBA programming, and the ability to write clear and concise instructional material. Must speak good english as best we do a zoom / teams meet to review workbooks.

Description: We are seeking an experienced Financial Modeling Consultant with in-depth knowledge of affordable housing developmen...layering. Familiarity with compliance and reporting requirements for state and federal programs. Exceptional analytical and problem-solving skills. Excellent communication skills and ability to explain financial concepts clearly. Preferred Qualifications: Experience working with LIHTC, HUD, or other Florida-specific housing programs. Background in real estate finance or development. Proficiency in Excel and financial modeling tools. Deliverables: A refined or new underwriting model for affordable housing projects. A detailed report outlining recommendations and insights for financial decision-making. Ongoing support for financial strategy discussions ...

I have a data sheet ready for a Monte Carlo Simulation assignment. An Excel expert is needed to input the formulas into the sheet and complete the assignment. A formula sheet and instructions will be provided. Key Requirements: - Intermediate level complexity for the Monte Carlo Simulation - Use of Random Sampling technique - Results presentation in both tables and charts Ideal Skills/Experience: - Proficient in Excel - Experience with Monte Carlo Simulations - Able to present data in a clear and concise manner

I'm in need of an Excel expert who can assist with a complex spreadsheet designed for data analysis. Key Responsibilities: - Help with analysing data using %tile rank - Potentially adding additional features to the spreadsheet Ideal Skills: - Proficient in Excel with a deep understanding of its functions and formulas - Experience in data analysis - Able to implement automation with macros, create visualizations with charts, and use conditional formatting if needed I am open to suggestions for additional features that could improve the functionality of the spreadsheet. Please provide a comprehensive proposal outlining how you would approach this project.

I need a freelancer to help with maintaining my Excel files. My datasets typically range from 1,000 to 10,000 rows. Ideal Skills: - Proficiency in Excel 365 - Data cleanup and organization - Troubleshooting formulas and functions - Macro creation and automation Experience with large datasets and Excel 365 is essential. Tasks may include data organization and cleanup. I look forward to your proposals.

I require a Microsoft Excel expert to assist with data analysis and visualization. The data is currently in an Excel spreadsheet and needs to be analyzed using descriptive statistics. Your tasks will primarily include: - Interpreting data and providing meaningful insights - Creating visual representations of the data Ideal skills and experience for the job include: - Proficiency in Microsoft Excel - Experience in data analysis and visualization - Strong understanding of descriptive statistics

...need someone to scrape website data and social media posts. Please download every Tiktok post from Return Home: @returnhomenor?lang=en We will need the videos, text description, hashtags, and all comments (and their associated data). In doing so, we ask that you create an Excel spreadsheet, a folder with video downloads, and a folder of Word documents that include the comments on each video. We provide a detailed description below. 1. Excel Spreadsheet: Please create an excel spreadsheet with the following columns. Column A: Label: “Video title” In this column, please provide the video title to match the title of the video download. For example, if you look at this TikTok video (@returnhomenor/video/7164090596796157230?lang=en), you would label

I'm in need of a freelancer who can assist me with data entry of realtor information (name, company name, phone number, email, city) from multiple websites onto an excel sheet. This data needs to be formatted in a way that it can easily be imported into my CRM. Key Tasks: - Source realtor information from multiple websites - A combination of web scraping and manual data entry - Processing of more than 500 entries Ideal Skills & Experience: - Proficient in Excel - Experience with web scraping - Detail-oriented to ensure data accuracy - Able to work independently and efficiently

We are seeking a skilled bookkeeper to assist with the conversion of our business bank and credit card statements from PDF format to Excel. This is essential for the preparation of our financial statements for tax filing purposes. There are around 290 statements, containing around 1000 pages. The ideal candidate should be detail-oriented and proficient in accounting software. Experience with financial reporting and knowledge of tax regulations will be needed. We are looking to have this done ASAP, preferably by the end of the day this week on Wednesday. If you have a strong background in bookkeeping and are comfortable working with various file formats, we would love to hear from you.

I'm conducting a survey via Google Forms and need a statistician to help analyz...Test specific hypotheses based on the survey results Ideal Skills and Experience: - Proficient in using inferential statistical methods - Able to conduct comprehensive descriptive analysis - Strong understanding of multiple linear regression - Experience in testing specific hypotheses - Excellent statistical reporting skills Please note that the survey has received 99 responses. Link to the Excel sheet of the Google form: Link to full work and methodology of what needs the done: Deadline in less than 48hours.

I'm seeking a solution to expedite job posting updates on Clasified website. I refresh my page every minute but still miss listings. I need a faster, more reliable way to track job if i update the browser every appears new ad appears for example with this message "posted 8 minutes ago"

I need assistance with reformatting my spreadsheet to improve its layout and visual appeal. Additionally, I require help with performing some statistical analyses, specifically calculating means, medians, standard deviations, and variances. Ideal candidates should have: - Proficient skills in Excel or similar spreadsheet software - Experience with data formatting - Strong understanding of statistical functions and analysis

Proposed Topic for Individual Project – Development and Presentation Masters Degree Clinical Psychology Theme: Development of a data management application for didactic processes, based on a topic of your choice. The individual project consists of two modules (files): • A descriptive module (a word-processed document) • A calculation module (developed in a d...Processing ✅ Fictitious data can be used ✅ Specify the types of data you’ve included: numerical, calendar-based, alphanumeric, etc. ✅ You can apply a questionnaire ✅ Include a graph ✅ State what you aimed to do and what you obtained ✅ Provide 2-3 conclusions ✅ Offer proposals The project files should be uploaded on the platform in Word format and the application where you processed the data (SPSS or Excel...

Refresh website and add a few things Total Access Golf Website Development Guide Total Access Golf Website Development Guide Objective To create an engaging, user-friendly website that reflects Total Access Golf's mission of inclusivity, fitness, and 24/7 access. The site should inform, attract, and convert visitors into members while showcasing the business's unique offerings. Homepage (Landing Page) Key Elements: - Hero Section: Bold tagline: 'Golf Never Sleeps, and Neither Do We.' Background video or image showing people enjoying simulators. - Introduction: Brief overview of Total Access Golf's mission and CTA buttons. - Showcase Features: 24/7 access, simulators, and community programs. - Call-to-Action Buttons: 'View Memberships' and '...

Introduction My fire door inspection reports are created on an iPhone operated template. This is available from “Safety Culture” and I subscribe to the Premium edition which allows me to export the reports “Safety Culture” created to both a Word and also an Excel format. Word Format The export format contains all of the data which I have collated in my iPhone report into a lengthy and detailed report, complete with photographs illustrating each defect which I have identified and listing remedial work which I have deemed is necessary. What I require as far as Word is concerned is the following: A Macro, triggered on the click of a button, to ensure that the report is modified to suit the attached example of how I would like the report to look after triggerin...

...technical support for mobile app users. - Providing product/service information for new sales and closing them. - Scheduling appointments. Ideal Skills: - Excellent communication skills - in english and be very fluent in english. - Problem-solving skills - Experience in customer service and must be able to be super friendly with customers. - Familiarity with VoIP systems -Must be good with excel, words, docs. Please note that specific admin tasks have not yet been defined, and will be many different admin tasks. we are looking for someone who wants to work and can wear multiple hats at anytime, doing whatever tasks given them. we are looking for someone reliable and can work at any given schdeule moment.. no excuses and no exceptions. our work hours in USA is 8am...

Hi there - I'll help you create a database for your invetor's information in Excel workbook. Thanks for your work!

...performance. Create easy-to-digest reports and visualizations for the team. Analyze trends and provide actionable insights to improve performance. Work closely with the team to optimize data collection processes. Requirements: Strong experience with tools like Google Analytics, Meta Insights, SEO platforms (e.g., SEMrush, Ahrefs), and email marketing platforms (e.g., Mailchimp, Klaviyo). Proficiency in Excel/Google Sheets for creating dashboards and visualizing data. Exceptional attention to detail and the ability to spot trends or inconsistencies. Strong organizational and time-management skills. Knowledge of e-commerce and fashion retail metrics is a bonus....

I'm looking for a skilled freelancer to set up a Mac and create an automated daily report from stock broker accounts. This project involves: - Using Python to extract and analyze stock data - Integrating with the...freelancer to set up a Mac and create an automated daily report from stock broker accounts. This project involves: - Using Python to extract and analyze stock data - Integrating with the broker API (specific API to be determined) - Incorporating volatility indicators (to be specified) - Ensuring the final product can be easily imported into Excel The ideal candidate should be detail-oriented and accurate in data reporting. Proficiency in Python and Excel is essential, as is experience in financial data analysis. If you can deliver reliable reports, I would ...

...Individuals from partner churches in Jordan, India, Malawi, Zambia, El Salvador, the Dominican Republic, and Costa Rica fill out Form 2 by a specific date to share their information and be paired with individuals from Willow Creek. - Once form submissions are closed, the program will create 1 to 1 matches between Form 1 and Form 2 based on simiar field matches, individuals will receive a ‘prayer sheet’ via email or SMS that delivers select information in a beautiful format to empower them to pray for their partner throughout the year. Requirements: - Multiple language support - Translates form fields into multiple languages - Translates form entries into recipients selected language - Emails/SMS delivery - Personal privacy (not sharing email, phone, full name) If ...

I need an expert in Artificial Intelligence, ChatGPT, Python, Machine Learning: can be expert in any of them The job is to collect data from the internet (NOT from one particular website, but from the worldwide web in general) and populate an Excel sheet that I provide The data is about businesses, and will be used on a business website

I have a matrix where it computes the sum over some zip codes and regions and a time filter and the values are correct but also I have a second sheet where I have a bar plot but you can select a month and a region using bookmark and the sum is not correct. There might be some something small or formula to fix IN the second sheet I created some measure and the issue might be there. To work in this task it is required to use any desk.

Explanation Request: Logo Redesign for HesheeKids Objective: To redesign the existing HesheeKids logo, ensuring a polished, high-quality, professional look suitable for branding purposes. The redesign should align with the overall aesthetic of brands like LuvLap and Babyhug, focusing on bold, vibrant, and appealing visuals. Key Requirements: 1. Design Enhancements: - Maintain the overall design format and essence of the original logo. - Improve color quality to be vibrant, professional, and brand-ready. - Ensure perfect alignment of text, icon, and overall elements for a cohesive look. - Experiment with capitalization styles: hesheeKids (lowercase + uppercase mix) HesheeKids (uppercase first letter + uppercase 'Kids'). 2. Icon Design: - Incorporate the icon directly into the ...

I have suppliers I have user and password to log in then I get my special discounted prices. I want a scrpit to download detials whenever required of the all items in excel or CSV format like item code, item detials and description, item price, item stock with differnt color options mentioned.

Already i check the Attachments excel sheet and i agree client timeline and budget $15.

Same as previous jobs, payment released after all corrections

...Python - Experience with Interactive Brokers platform - Knowledge about different types of trading orders Ideal Skills: - Python programming - Trading experience - Interactive Brokers expertise - Order placement automation I am looking to hire a pythan trading expert, You need to automate trade in Shoonya Broker Account, Automate the buy sell order, It has lots requirment I have attached excel file to fetch and update data, and automate trade, I can choose any interval, It need to fech candle data, more detaiil i wll give if you can provide result with my budget, Not your Expectation If you accept my term apply this task: Budget:Rs 900 I will give good review, if you complete my budget, Dont expect more money, Money will paid after complete the job successfully, dont ...

...project. The task involves pulling mixed data (both text and numerical) from an existing worksheet and setting it up so the data is automatically pulled and sorted into a new one within the same workbook. The original date is in worksheet as an example, and I need it automatically pulled and sorted in the same format as New worksheet. I need this to be a formula so New Sheet automatically populates and sorts based on the data in worksheet. The specific requirements are: - Extracting both text and numerical data - Cleaning the data by eliminating unnecessary spaces - Listing the dates in a specified format (MM/DD/YYYY) Ideal candidates for this project should have: - Proficient knowledge and experience with Google Sheets - Strong data organization skills

...payrolls in Excel Macros. Ideal Skills and Experience: - High level excel macros and VBA experience is required... Project scope: Prepare a banking Neft challan for bulk transfers and payrolls. 1. A database for vendor banking details ( infinite data feed required) 2. A database for employee banking details (infinite data feed required) 3. A payroll database , ( considering attendance , ESI & PF calculations, Salary advance, other deductions, Allowances, HRA, Salary) 4. Banking NEFT challan for vendor - button for creating print page in A5/A4 data on a company letter head based on data size 5. Banking NEFT challan for Payroll - button for creating print page in A5/A4 data on a company letter head based on data size This needs to be developed using ...

Hello! I would like to talk about possibility of rebuilding (actually re-writing from the sratch) our Google Sheet simple warehouse table. I would like to share with you the copy of the existing file, but I need to know your gmail address. What we have somehow works, because we do not have many positions. There are three main issues: - some of the products are not in stock, but are ordered (so, would be available in i.e. 2 weeks) - that should be also included in the system, - our warehouse man is not fluent with computers and he sometimes makes mistakes while typing (i.e. he wants to find a product in the sheet, but instead of CTRL-F he presses SHIFT-F and this is how he "destroys" one or a few cells, - some of the products in the warehouse is a set of other elem...

My Excel file, which I use daily for financial data management, has become heavy and unorganized. I need it to be cleaned up and made more efficient. Key Focus Areas: - Data Organization: The main issue is the disorganization of data. It needs to be structured in a more logical and user-friendly way. - Formula Optimization: While not an explicit focus, if there are formulas that can be simplified or improved, I would appreciate your expertise. Ideal Candidate: - Extensive experience with Excel and data management - Proven track record with financial data - Skills in data organization and formula optimization - Ability to enhance the visual layout and formatting of the file - Excellent attention to detail and commitment to quality I update this file daily, so I need someo...

i have a html page that has a form in it, need to create a react form similar to html. Also need to deploy the same form to my webaddress and get the inputs in the excel.