Vba script import excel tablavori

I am currently in need of a proficient Excel expert capable of aiding me in data analysis for my investment data portfolio. The Ideal Candidate Should: - Have in-depth knowledge and experience in Excel, particularly in handling and managing large amounts of data with efficiency. - Be familiar with investment-related data and understand trends to aid in analysis. - Be able to demonstrate past work on similar projects, ideally in the investment sector. Project Scope: - The task involves in-depth data analysis of my investment portfolio which encompasses various types of data. - The freelancer will need to interpret and analyze the data using advanced Excel formulas and techniques. The successful freelancer should include their past work in their application. An unde...

I'm looking for a VBA programmer to help me with creating custom functions and macros for data analysis in Excel. Key Tasks: - Creating Macros: The project involves developing macros that can automate repetitive tasks and facilitate data analysis. - Building Custom Functions: I need custom functions to aid in data cleaning and manipulation, as well as report generation. Ideal Skills: - Proven experience in VBA programming, especially in Excel. - Strong background in automating tasks and data analysis. - Ability to develop custom functions for data cleaning and report generation. Output: - The generated reports should be in an Excel spreadsheet format, as well as a PDF document. Please provide samples of your previous VBA work, specific...

I have a powershell script that is made to work as a DNS utility that will allow me to create/delete/update DNS entries. It is not currently able to handle CNAME as i think it was made to handle A records based on the create scetion of it. I need it be able to do all 3 fuinctions on different record types with thier individual required inputs. One of the main problems im running into is it is not able to handle a hostname instead of IP4 when trying to run it. I need it done very promptly. Preferably today.

I'm looking for a skilled MS Excel professional who can work on a multi-sheet file that requires data analysis, formula application, and design enhancements. Key Requirements: - Data Analysis: The primary aspect of this project is to analyze the existing data. - Formulas and Functions: Implementing formulas and functions to drive accurate calculations and insights. - Formatting and Design: Enhancing the visual appeal of the sheets, ensuring they are user-friendly and professional. The file contains 2-5 sheets, and I anticipate that the work will involve a mix of data analysis, formula implementation, and design adjustments. Since I've opted to complete the project, I'm open to any additional suggestions you might have to enhance the overall functionality of the she...

I'm looking for a skilled developer who can create a custom trading script in Pinescript on the TradingView platform. This script will be based on identifying and monitoring market trends. Key Project Details: - The script should be able to accurately identify a trend based on the definition of "higher highs and higher lows". - When a trend is identified, the script should take no immediate action but continue to monitor the market conditions. Ideal Skills and Experience: - Proficiency in Pine Script and experience with TradingView platform. - Strong understanding of technical analysis, particularly in the context of identifying trends. - Previous experience in developing trading scripts or bots is highly advantageous. - A background in ...

In order to effectively drive my ongoing project, I'm in need of someone skilled at gathering specific data and preparing it into a highly organized spreadsheet. The data needed include: - Name - Email - Job/Business - Phone number(Whats app) of (NRI) Non Resident Indians in UAE The ideal ca...specific data and preparing it into a highly organized spreadsheet. The data needed include: - Name - Email - Job/Business - Phone number(Whats app) of (NRI) Non Resident Indians in UAE The ideal candidate for this task should demonstrate: - Proficiency in data collection, and data management. - High level of accuracy and attention to detail. - Proven experience in sourcing data and utilizing Excel or similar spreadsheet software. Looking forward to advancing my project with ...

I need someone to transcribe the content of the picture to a excel as the same way. I have 100 picutures like this one. How much for this job?

My Excel file is very heavy and unorganized. I want it to get cleaned and effecient

I’m looking for a freelancer proficient in Excel who can create a dynamic tool for my restaurant business that helps in managing my food costs and menu pricing calculations. Key responsibilities include: 1. Cost Analysis: Crafting a spreadsheet that can factor-in: - Food cost percentage - Gross profit margin - Break-even analysis 2. Menu Pricing: The spreadsheet should provide calculations on: - Menu item profitability - Menu item pricing based on the desired profit margin Ideal candidates are detailed-oriented and have substantial knowledge in cost analysis and pricing strategy in the restaurant industry. Excel expertise including functions and formulas is paramount. Past experience in successfully building such tools will be a definitive plus.

I need a simplistic, one-page website linked to a database. This page will have limited content, including a logo and a 'check authenticity' button. The database will be provided in an Excel sheet format, and must be integrated seamlessly into the page. Key Requirements: - Develop a one-page website - Integrate an Excel database for product authentication - Provide a clean, simplistic design Ideal Skills and Experience: - Experience in web development, particularly one-page websites - Proficiency in database integration, specifically Excel - Ability to create clean and minimalist designs - Strong understanding of web security and authentication processes

I'm seeking an expert in data analysis to help with profiling and analyzing our financial data. The ideal professional will have the following experience and skills: - Proficient in financial data analysis - Able to generate comprehensive analytical reports - Experienced in Excel for data presentation

...users, such as consumers and business users. - Access Control and Content Restriction: Depending on their membership level, users should have access to different sections of the site, with content being restricted accordingly. - API Integration: I currently do not have an API set up for accessing data from WebFlow's MySQL. This will need to be implemented on the WebFlow side. - Data Import: I'm looking to import specific data from the API into the WebFlow site. This includes membership level information and orders submitted. Ideal candidates for this project should have: - Proficiency in WebFlow and a strong portfolio demonstrating membership system integration - Experience working with API integrations, especially those involving WebFlow's MySQL - A keen e...

I need an experienced PHP developer to help with customizing a PHP script. The specific details of the modifications are: - User Authentication: Implement an effective user authentication system. - Database Integration: Ensure seamless integration with our existing database. - UI/UX Enhancements: Enhance the user interface and user experience of the script. Please note that the specific PHP script has not been disclosed, and further details regarding the script's functionalities have not been provided. The successful freelancer will need to be able to navigate and modify PHP scripts efficiently and have a good understanding of user authentication, database integration, and UI/UX principles. Your expertise in PHP and familiarity with various scripts and their m...

I need a Pine Script expert to create an alert for my custom indicator. Key Requirements: - Develop a set of codes to let my custom indicator to send signal - Mainly, I use daily chart but I want the signal to create an alert before the bar close. For instance if the daily bar close at 4:00 am, it has to calculate everything around 3:45 am and then send the signal immediately after that. - Please note that I have my custom indicator finished written so you might like to create the signal only when the conditions are met. Ideal Skills: - Strong Pine Script and Trading Indicator experience. - Excellent understanding of trading and financial markets. - Ability to optimize code for performance. - Effective communication and support for the project.

summarize in a specific table in Excel

Hi Ravi Ranjan K.,I have a task of import of purchase excel to tally prime for now .

...- 300.00 EUR. I am looking for an experienced developer to create a bot (on the telegram platform) capable of instantly buying and selling Solana tokens on Raydium, Jupiter DEX. You will need to develop a bot that will perform transactions fully automatically, without the need for manual approval. Key features: Telegram platform Seamless integration with Raydium. Orca. Jupiter. Phantom wallet import Instant execution of buy/sell orders (swap in less than 1 second) Copytrading Full automation of operations. The ideal candidate should have: Experience in programming trading bots. Excellent knowledge of Solana and its DEX platforms (Serum Dex). High level of accuracy and attention to real-time changes. More details will be provided upon receipt of the assignment. Required Skills...

I'm in need of an expert in Excel for data entry and cleaning. The tasks involve handling text-based, numeric, and date & time data. Key Responsibilities: - Perform accurate data entry - Cleanse and format the data as needed Ideal Skills and Experience: - Proficiency in MS Excel - Proven experience with data entry and data cleaning - Attention to detail - Ability to work with various data types, including text-based, numeric, and date & time data

I am currently using ZOHO Books and am looking to migrate to Odoo Accounting. I need an Excel expert to help with the migration process. Key Tasks: - Migrate complete set of invoices and bills from ZOHO Books to Odoo Accounting. - Transfer all customer and vendor details accurately to Odoo. - Ensure that financial reports are maintained and migrated correctly. Ideal Candidate: - Proficient in both ZOHO Books and Odoo Accounting software. - Excellent experience in data migration and Excel. - Familiar with maintaining and handling large databases. - Detail oriented, ensuring data integrity throughout the process. This is a large scale project as my current ZOHO Books database exceeds 1000 records. I need someone who can efficiently and effectively handle the migration proc...

I am seeking an experienced Laravel and VueJS developer who can customize an already developed script to fit our specific needs. Although the user chose to skip a few questions outlining the exact changes needed, we expect the developer to be proficient in: - User authentication - Dashboard layout design - Payment integration - Permissions - SaaS Development - Laravel and Vuejs expertise Ideal candidates should be able to confidently handle these listed tasks and possess the ability to suggest and implement improvements. Prior experience customizing these elements and a keen eye for detail are highly desired, to ensure the finished product aligns with our vision. Please approach this task with adaptability and a problem-solving mindset, as specific customization requests will b...

I am looking for a video editor to edit our existing UGC footage into high-converting direct response video ads, for use across Facebook, Instagram and Tik Tok. I am looking for you to provide creative strategy / script ideation with customer research + direct response video editing (and sometimes using AI voiceovers). Ideally we set up a process of 3-4 new videos per week. In summary, you need to: - Edit existing footage to create high converting video ads - Do audience research and craft scripts for creative video concepts tailored to our customers - Create new video scripts/ideas weekly Please provide some examples of the most recent videos you have created.

Answer the attached question correctly, and briefly explain. using principles of subnetting. I'm looking for an expert in networking who can provide correct answer and clear and concise explanation of the attached question. Answer the attached questions, the provide table of the subnets Accepted file format Excel or Word

I'm in need of a professional to write concise yet comprehensive reports. Details regarding the purpose and type of reports were not specified. Ideally, the freelancer should be adept in creating performance analysis, expense tracking, project updates, financial, sales, and progress reports as all these may be requested. T...were not specified. Ideally, the freelancer should be adept in creating performance analysis, expense tracking, project updates, financial, sales, and progress reports as all these may be requested. The frequency of generating these reports is also yet to be confirmed, so preparedness to deliver on a daily, weekly, or monthly basis is essential. Superior skills in data analysis, proficiency in excel or other relevant software and report writing is a must fo...

I am seeking a skilled freelancer with proficiency in Excel, especially in performing statistical analysis using frequency distribution and creating informative visualizations. To get specific, the scope of work involves: - Converting my Excel sheet data into meaningful insights via statistical analysis - there is 12 workbook, represent date palm trees five varites. - each tree has branches which is recorded in the cell. -some trees did not produce - need a colorfull charts that represent branches . IF BRANCH IS 0 MAY BE WE COLOR RED. IF ONE WE GIVE OTHER COLOR, IF 10 MAY BE GREEN. - NEED TO HAVE THE SUM OF BRANCHES TOTAL NUMBER IN EACH WORK BOOK - BRANCHES MAY PRODUCE 4 KILO OR 5 KILO: NEED TO HAVE A FORMULA THAT I CAN CHANGE AND KNOW THE TOTAL PRODUCTION OF EACH WORKBOOK...

...seeking a Python developer who can automate certain calculations in my existing Excel files. The calculations that are currently done manually in Excel need to be automated. This means the Python script you develop will need to accurately and efficiently perform these calculations every time it runs. As for the frequency, the system should run calculations on demand. This way, I can trigger it whenever I need the numbers updated. The calculations are based on the data currently stored in my Excel files. So the script will need to read this data, perform the necessary calculations and update the files with the new results. The ideal candidate should have: - Proficiency in Python - Experience in working with Excel files - Understanding of a...

I need assistance with entering inventory data into Quickbooks Desktop from an Excel file. - I'm looking for a professional who has experience with Quickbooks Desktop. - The job involves bulk data entry, focusing specifically on inventory. - You will be provided with an Excel file containing the inventory data. - Attention to detail is crucial to ensure accurate and efficient data entry. Ideal skills: - Proficiency with Quickbooks Desktop - Experience with data entry, particularly inventory - Attention to detail and accuracy in data entry - Familiarity with Excel files and their import into Quickbooks

We are facing a challenging issue with our existing Python scripts that deal with data processing, automating tasks, and communication with other services. - Problems: These scripts have been producing incorrect results and running slow, affecting the overall performance of our project. - Scope: The project consists of 1-5 Python Scripts that need to be diagnosed for the errors, fixed, and optimized for better performance. - Key Skills: An ideal freelancer would be well-versed in Python programming, task automation, and capable of identifying and rectifying issues relating to communication with other services. Experience with rabbitMQ is mandatory as it's part of our current code base. We are eagerly waiting for a Python wizard who could breathe life into our scripts and bring ...

I'm in need of a web scraping wizard who can help me extract text data and profiles from Twitter website. Key Requirements: - The ability to scrape text data and profile information efficiently and accurately. - Experience in ...Requirements: - The ability to scrape text data and profile information efficiently and accurately. - Experience in web scraping, with a strong portfolio showcasing past work in similar projects. - The time for scraping a post and profile must be less 3 seconds without using Twitter API. The final deliverable should be in a format that's easy for me to analyze, but I'm flexible on whether it's a CSV file, Excel spreadsheet or a database format. Please describe your past work examples with your application. Write "Blue" on th...

I have a 500MB XML file that I need loaded into SQL across approximately 20 tables. I'm in need of a Python script to handle the transformation. The script will need to handle normalization of the data. Key requirements: - Develop a Python script to read the XML file and transform the data into a normalized structure across 20 tables. - You will need to create the SQL tables as part of the normalization process. - Experience with large data transformations and SQL is vital.

I'm looking for proficient freelancers who can effectively input both text and numerical data into Excel from physical documents. The task does not require any formulas or calculations, but attention to detail is crucial to ensure the accuracy of data. Key tasks include: - Manual entry of text and numbers from physical documents into Excel - Ensuring accurate data entry and quality checks Ideal freelancers should: - Have experience in data entry tasks, particularly with Excel - Be detail-oriented to ensure accuracy - Have strong organizational and time management skills.

I require the expertise of a part-time remote accountant who can commit to less than 20 hours a week. The core tasks involve: - Bookkeeping: Systematically recording and organising my financial transactions. - Payroll: Managing payroll functions to ensure that employees are paid in a timely...can commit to less than 20 hours a week. The core tasks involve: - Bookkeeping: Systematically recording and organising my financial transactions. - Payroll: Managing payroll functions to ensure that employees are paid in a timely and accurate manner. - Financial analysis: Monitoring, identifying and interpreting financial trends. The ideal candidate should have a good command of QuickBooks and Excel spreadsheets. Familiarity with these tools is crucial for performing tasks efficiently and a...

I'm looking for an expert in Excel who can help me with applying conditional formatting and creating complex formulas that involve multiple conditions. Please watch this video for what i need Key Requirements: - Applying Conditional Formatting: The Excel file will require conditional formatting to visually represent data based on specific criteria. - Creating Complex Formulas: The project includes creating formulas that are not limited to basic arithmetic, and instead, involve multiple conditions. Ideal Skills and Experience: - Proven expertise in Excel: The ideal candidate should have a strong background in working with Excel and creating complex formulas. - Understanding of Conditional

I'm looking for assistance with online data entry to Excel. The task is not overly complex but will involve working with reference numbers and ensuring accurate data entry and cross-referencing. Full training will be given and I will explain all. Budget is hourly and $3 max need to have good understanding of English

...processing to build a cryptocurrency trading signal application. The core of this project will be to implement an LSTM (Long Short-Term Memory) neural network that utilizes techniques like Fourier transform among other signal processing methods to generate buy and sell signals based on historical cryptocurrency data. Key Project Requirements: - Data Handling: The application should be able to import and use cryptocurrency data from this Kaggle dataset: Binance Full History. - Signal Processing: Integrate Fourier transform and other signal processing techniques to analyze the data. - Model Implementation: Develop and train the LSTM neural network model to predict potential buy and sell points. - User Interface: Design a user-friendly GUI that displays graphs, essential text-base...

I am looking for an efficient data entry expert to assist me in entering textual, numerical, and image-based data. The project involves a medium amount of data that needs to be meticulously transferred to an Excel file. Your responsibility will include, but is not limited to: - Inputting textual data while maintaining accuracy. - Adding numerical data precisely. - Uploading images correctly. An ideal freelancer for this job would have a keen eye for detail, substantial experience with Excel, and the ability to handle different types of data. Prior knowledge in image uploading and handling is a plus. You should also pride yourself on accuracy and efficiency. In your proposal, please share a brief summary of your experience, including one to two data entry projects you hav...

I'm in need of a talented script writer to craft a comedy rap script for an all-ages audience. The main theme of the rap is about overcoming adversity. Good afternoon I hope you are having great day, Thank you for applying for this freelance opportunity! Your portfolio looks very impressive and we would like to invite you to complete a short trail task as part of the recruitment process Firstly, a little bit about Crealon Media. We are a dynamic, innovative, and ever-evolving company that operates primarily in the social media landscape. Over the past few years, we have established several incredible brands and continue to grow at an accelerated pace. We aim to produce varied content to delight and engage millions of viewers in a host of popular niches, while also bui...

Automated report using dashboard in Excel The report interface should be similar look to the pic attached. The Excel file for data source should be able to be used for Power BI. Two dashboards: 1- for multiple project management status reporting 2- for ad-hoc task management The data source is in an Excel sheet with a manual entry

!RUNTIME FOR SHORT FILM: 15 MINS! !SCRIPT, CONCEPT ART, STORYBOARD AND TIMELINE IN ATTACHED ZIPFILE! I'm on the lookout for a talented 3D animator who can interpret my specific vision of a cell-shaded, arcane short film. I have a detailed storyboard ready to go, as well as characters and settings waiting to be brought to life. Here's what I need: - Creation of cell-shaded 3D character models based on provided concepts. (ie Spiderverse, Arcane) - Development of an atmospheric, arcane environment. - Implementation of texture projection mapping to achieve the desired artistic style. The ideal freelancer for this job should: - Possess solid knowledge and experience in 3D animation, particularly with cell shading techniques. - Be capable of working under a tight schedule, a...

Necesito combinar un archivo excel que lo extraigo de un programa extranjero (1r archivo), y que debe añadir de otro archivo (plantilla proveedores) un dato para obtener una excel final (plantilla). El programa debe permitir insertar el archivo inicial, que consulte otro excel para añadir su CIF (el software es extranjero i no lo incluye) i transformarlo en el final (plantilla). Lo suyo sería, inserte archivo inicial, para extraer el archivo final

Technical Knowledge For Front End You can create it using Nextjs For the backend side, Express Create a responsive form website layout that adjusts seamlessly across various devices. (Web, Tab, Phone), and explain how would you approach designing a layout that maintains consistency and usability across different screen sizes, from desktops to smartphones? Create a validation in each form field please create a minimal 6 field (Plus point if the validation from back end side). For example: Name should contain the alphabet, not a number. (If it’s number show error message) The phone number contains a number. Etc. (you can create your field & own rules) * Create a reusable component. Add CSS animations to enhance user experience. Design and create an API to provide above...

I'm looking for a skilled software engineer. THis task is too large for excel power query, however i want it to operate in a similar fashion. The main purpose of this project is to develop a self-updating database of every racehorse in the state of NSW, Australia, via the website. Key tasks and responsibilities: - Determining the best platform for the software (Web-based/Desktop-based/Mobile application). - Creating a software solution that will automatically update and manage a database of racehorses. Skills and Experience: - Proficiency in at least one high-level programming language i.e., Java, Python, C++ - Experience with automation software - Familiarity with database management - Ability to recommend best software platform based on project requirements. Thanks :

I need a custom WhatsApp script built in PHP. The script will quickly send messages to the numbers in my database list. The script should: - Interface with my database to access numbers. - Be efficient and scalable for reaching a large number of contacts. Ideal skills and experience for this job: - Proficient in PHP, with experience in building similar WhatsApp scripts. - Familiarity with database connectivity in PHP. - Understanding of WhatsApp API and message sending limitations. - Prior experience in handling bulk messaging. Please note that the script should adhere to all WhatsApp's terms of service, including message limitations and privacy regulations.

2 pages of data sheet need to be recreated with zero mistakes and dito copy i am attaching the 2 pages i need to be recreated same to same, the top logo will change which i will provide you the screw picture and the text i am attaching with this for your review the sheets should be totally editable either make in word or excel or it should be edited in PDF the lowest quote below the price of $15 will be awarded the project thank you

When replying, reply with the text: "Forensic 4 Project"...qualifications you have? 7) If you have any experience in working in Singapore financial projects do highlight those as well. 8) What do you understand of the SIBOR / SOR / LIBOR scandal and how could it have affected borrowers? Work scope: Go through letter of offers and loan statements, find the faults, calculate the excess paid, calculate damages All works should be done in Google Sheets or Microsoft Excel with formulas to prevent any calculation errors. Your output should clearly show what was charged, what should have been charged, difference and damages. Need someone who has a decent amount of time available, if you do not have alot of time to spare, this may not be ideal as this will take some time to co...

We're on the lookout for skilled animators adept at infusing life into our milkbag persona through captivating and witty Instagram Reels and animated content. Our ideal candidate possesses a solid grasp of animation principles and ...caliber of content we're aiming for. We aspire to achieve a similar level of ingenuity and amusement in our mascot character Instagram Reels. How to Apply: If you're passionate about animation and possess a talent for crafting entertaining Instagram Reels and understand cryptocurrencies and trading we're eager to hear from you! Please include your portfolio and a brief statement outlining why you'd excel in this role in your application. Additionally, feel free to share any relevant experience or ideas on bringing our mascot c...

I am in need of a freelance MIS Executive with strong skills in data analysis and database management. Responsibilities: - Conducting detailed data analysis using the provided tools - Proficiently manage and maintain a database Ideal Candidate: - Proficient in Microsoft Excel and SQL Server - Experience in database management and data analysis - Strong analytical skills - Excellent attention to detail This project requires someone who can work independently, has a good eye for detail, and can deliver high-quality results. A background in MIS or similar field would be a big plus.

I need a dedicated professional to assist with a crucial data entry project. The work involves: - Encoding textual data sourced from digital documents. - Delivering accurately encoded data into an Excel spreadsheet. This task requires keen attention to detail to ensure the absolute accuracy of the data entry. The ideal candidate must have extensive experience handling textual data and an aptitude for meticulous data entry work. Proficiency in Excel and working with digital documents is also vital.

I'm in need of a seasoned Apache Solr professional to help me implement search functionality for my project. The ideal candidate has excellent expertise in Apache Solr and can effectively optimize search functionality for text documents. Key responsibilities: - Upgrade from Apache Solr 3.6 to a version supporting wildcard search, Windows server - Multi cores with replication - bulk import via CSV - core creation/deletion across master and slaves Ideal skills and experience: - Prior experience implementing Apache Solr for search functionality - Proficiency in data indexing and faceted navigation with Apache Solr - Strong understanding of optimization techniques for search functionality - Excellent problem-solving and analytical skills - Good communication and collaboration ab...

I have a data transcription and cleaning/validation project that requires a skilled individual. All data will be provided in Excel and PDF formats. Key Responsibilities: - Transcribing data accurately from multiple sources - Cleaning and validating the data to ensure accuracy - Working primarily within Microsoft Excel Skills/Experience Required: - Proficiency in data entry, transcription, and data cleaning - Strong command over Microsoft Excel - Attention to detail and accuracy are key I am looking for a detail-oriented individual with relevant experience to help me complete this task efficiently and accurately. Please include examples of similar projects you have completed in your proposal.

I'm looking for an Excel expert to help me refine some of my current templates. The ideal candidate will have experience with building templates for dashboards, organizing data, generating reports, and analyzing various types of data including sales, financial, customer, and inventory data. Key Requirements: - Experience in building templates for dashboards is a must. - Adept at organizing and analyzing complex sets of data. - Ability to translate data into clear and visually appealing reports. - Proficiency in working with various types of data, including sales, financial, customer, and inventory data. - Understanding of creating customizable templates in Excel. - A keen eye for design with a focus on clean and simple layouts would be appreciated. The project involves...