Excel vba import excel sheet excel sheetKazi

...following are the steps:- a) Excel file containing Product url list of about 300 products, all from the same website b) We should be able to run a macro etc, which we need to do multiple times daily c) When we run the script, it should check if for all those 300 products, there is a MSRP pricing appearing on the website d) The products have many variations, so it should check for all the varitions e) It should create each variation entry into a seperate column and highlight that product as a variation f) If any variation does not have MSRP price appear, then it should highlight that G) If the MSRP is appearing for variation, then it should fetch and enter that number. It is very easy and simple work. Bid only if you can do within next 24 hours. See the attached excel fil...

I'm looking for a skilled C++ developer to create a Linux PDF viewer class. Here's what I'm looking for: I have a C++ stand-alone App made with Juce Framework: I need a class easy to import in my project: This class must be able to open a PDF document and show it with basic functionalities, page up/down, fit to screen and so on budget for this project is 250 USD Check the C++ project attached Skills Required: C Programming Linux Software Architecture C++ Programming If you have experience in any of these areas, I'd love to hear from you.

I am seeking a skilled Freelancer to develop a comprehensive sales dashboard on Excel. The purpose of this project is to streamline our sales data for easy comparison and analysis on a daily, monthly, and quarterly basis. Key Features Required: - The ability to compare daily sales with last day's and last year's sales. - Monitor monthly actual vs budget vs last year. - Track quarterly sales performance. - Special attention should be given to the revenue growth metric. Ideal Experience and Skills: - Excel mastery - Proven experience in creating interactive dashboards - Knowledge in sales data analysis - Ability to create a user-friendly interface where data can be manually input efficiently and effectively Your role will heavily involve the organization of comp...

I'm in need of a skilled branding professional ...versions can be used. - Typography Guidelines: Detailed information about the fonts and typography style that should be used in all our communications. - Merch Guides: Design suggestions and guidelines for any promotional or merchandise items that we may produce. - Store Design: Guidance on the color scheme, logo placement, and overall aesthetic that should be maintained in our physical store. To excel in this project, you should have a proven track record of creating brand guidelines. Proficiency in graphic design, branding, and an understanding of the pet grooming industry would be advantageous. Your work should be detailed, professional, and easy to understand. A great attention to detail and a strong sense of creativity are...

Hi Aliza I., I noticed your profile and would like to offer you my project. We can discuss any details over chat.

I am a VA myself and looking to fill a position in my VA business to help clients and team up to complete projects faster. Plus points: 1) Experience with Excel and Google sheet 2) Techy 3) Solution oriented 4) Able to make decisions 5) Willing to satisfy clients even if it means additional efforts for free of charge 6) Google search, learn tools alone and not be depended 7) Uses ChatGPT for work

...professional who can set up an Azure data storage account to store Excel data, particularly with the following key features in mind: - **Data Type and Source**: The data I'm working with is primarily Excel based, so having experience with managing structured data storage in Azure is a must. - **Frequency of Updates**: The data will be updated on a weekly basis, so the storage solution needs to seamlessly accommodate this. - **Purpose of Storage**: The primary purpose of storing this data in Azure is for data analysis. While not the only use, ensuring that the storage solution allows for easy and efficient data analysis is crucial. The ideal candidate should have prior experience with Azure data storage, particularly in managing Excel data, and should be a...

I am launching a new enterprise and require an expert in OCR technology to design a program for me. The main function of this program would be to detect and digitize human handwriting from forms, consolidating that information into an Excel sheet. There would be a subsequent function for field extraction to compile a final report. - Desired Skills and Experience: • Proficiency in OCR technology for handwriting detection • Experience in custom software development • Excel programming expertise for auto-consolidation of data • Knowledge of report generation mechanisms within software Successful execution of this task would drastically streamline data processing in my start-up. To increase accuracy, the OCR program needs to be trainable, in order ...

I have a simple flowchart in Excel that I need converted to DrawIO format. The purpose of this flowchart is for internal ISO 9001 documentation , so it needs to be clear, easy to understand, and look somewhat formal, so Font style and Color scheme should be appropriately chosen. I'm looking for a freelancer with experience in graphic design, particularly flowchart creation and DrawIO, who can give this flowchart a clean, professional look. The excell file will be provided to you, so you can copy/paste the text. I do not expect you to change the content. There might be additional flowcharts in the future, so potentially repeat business. When bidding, let me know whether or not you have experience with ISO documentation drafting, which might be a plus.

I'm requiring assistance with a meticulous task of transferring text data from a website. The data on the site is neatly arra...requiring assistance with a meticulous task of transferring text data from a website. The data on the site is neatly arrayed in table format, and I need someone to manually sift through and copy the specific fields of 'Name', 'Date', and 'Description' into an Excel file. Ideal candidate would have: - Excellent attention to detail - Proven experience with manual data entry - Proficient in Excel - Understanding of structured web content This task requires patience, a keen eye for detail, and expertise in transforming web data into organized Excel entries. Interested freelancers need to commit to high level...

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

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.

Hi Ishaq. Can you have a look at this app for us. We want to convert it from a commend line batch file to a GUI app in Python. We had one of our team build the app in C# a few years ago, but he has left and we have the source code. The app will extract an image from an excel spread sheet based on the column ref and put the image into a nominated directory with the imaged named as per another column in the source excel spreadsheet. I can send yu a full demo of the app. regards Rob

I am in need of a skilled freelancer to convert a PDF document into a Word sheet. However, the purpose of conversion isn't just limited to a format change. Here's the breakdown of what I require: - Editing Facility: The Word document should allow me to easily edit its contents, so expertise in preserving content while enabling edits is vital. - Volume of Work: The task involves meticulously converting less than 50 pages, ensuring no details are left behind. - High-Level Accuracy: Precision is key for this project. I expect the converted Word document to be an exact match with the original PDF content. Ideal freelancers would have extensive experience in PDF to Word conversions, with a sharp eye for detail and strong English language skills. Proficiency in using Microso...

I'm in need of a freelancer to convert a PDF document to a Word sheet. The purpose of this conversion is to allow for easy editing of the document's content. It's crucial that the final Word document matches the layout of the PDF exactly. The complexity of the content layout in the PDF is minimal - it consists of text only. Key Requirements: - Converting a PDF to a Word document - Ensuring the Word document matches the layout of the PDF exactly - Experience in handling text-only PDFs Ideal Skills: - Proficiency in PDF editing tools - Excellent attention to detail - Familiarity with Microsoft Word - Previous experience in similar projects

I need an innovative .NET C# MVC template. This project involves creating 3 pages, each with a button that executes a function. The function needs to perform a basic calculation (like 1+1=2) and return the result to an output on page 4. The output should be displayed as text. Key requirements: - Develop a .NET C# MVC template with 3 pages - Each page contains a button that triggers a ...template, so feel free to suggest improvements or make changes as you see fit. Full description: Create a mvc .net c# template with page 1, page 2, and page 3. Each page has a button on it called button A which will execute a function that does a calculation (like 1+1=2) then returns the value to page 4 and shows page 4 where the user will enter their contact info which outputs to a google ...

I'm searching for a freelancer with solid experience and in-depth knowledge about real estate excel modelling. I need an Australian-based freelancer who has real estate experience. We have existing excel models that with the recent departure of our CFO, need someone to drive them while we find a replacement. The inputs will be provided by the project team and a hand over with the person who built the model is also possible if needed. Whats required is someone to ensure the models are used correctly. There is both a project specific model used for analysing whether a particular feasibility meets our hurdle rates along with a fund model that rolls multiple projects together along the operation of the manager. We primarily need the freelancer to input the data and gen...

Buatkan saya kalkulator sederhana untuk menghitung jumlah keb...yang digunakan berbasis android tanpa menggunakan jaringan untuk menunjang wilayah kebun yang sulit sinyal. Konsep dari aplikasi tersebut yaitu user tinggal memasukan jumlah pohon(SPH) untuk mengetahui berapa jumlah untilan yang dibutuhkan pada setiap lahan. jadi aplikasi otomatis akan menghitung berdasarkan rumus dosis yang diinginkan. Pada lampiran sudah saya berikan gambaran aplikasinya dengan excel. Apabila nilai SPH diubah otomatis jumlah untilan besar dan kecilnya akan menyesuaikan. untilan kecil sediri merupakan nilai desimal dari untilan besar yang dihitung ulang dengan rumus lainnya sesuai dosis. Nilai desimal tersebut apabila kurang dari 7, tapi apabila bernilai 7 atau lebih maka jumlah untilan besar dibulatka...

...and detail-oriented individual to conduct targeted web research. The task involves searching a specific website, using geolocation as the primary criterion, and collating the data of various companies into the excel spreadsheet I will provide. Key Tasks: - Browse the provided website and search explicitly based on geolocation. - The geolocations of interest are predetermined and are stated within my excel sheet. Data Collection: - Oddly, I do not require some common fields like company name, address, or phone number. - Ensure accuracy and completeness of data collated into the excel spreadsheet. Ideal Skills and Experience: - Proficiency in advanced web research and data entry. - Working knowledge of geolocation-based search - Attention to detail and a ...

I'm in need of a skilled data entry specialist, specifically someone with experience in Excel and online data entry. Key Project Details: - The task at hand is small and involves less than 100 records, so the workload is manageable. - Primarily, I'm looking for someone who can analyze the data rather than just inputting it. Ideal Skills: - Proficiency in Excel and online data entry tools. - Strong analytical capabilities. - Previous experience with similar, small-scale data entry projects would be an advantage. I'm eager to work with a diligent, detail-oriented freelancer who can ensure that the data is accurately inputted and analyzed.

I'm in need of an Excel expert to meticulously update the product descriptions and prices in my catalog. The requirements include: - Updating: You'll be tasked with updating the product descriptions with new information and ensuring all the prices are current. - Catalog Size: The catalog comprises over 500 products, so attention to detail and ability to handle large volumes of data is crucial. - Formatting: Special formatting is not required, the new product descriptions and prices need to be consistent with the existing entries. Ideal Skills & Experience: - Proficiency in Excel: Successful candidates should have a high level of understanding and experience with Excel, particularly handling large datasets and using formulas. - Attention to Detail: Given...

I need a tailored Google Sheet CRM for my insurance broker company. Currently, we're managing our contacts and leads on Google Sheets, but the system isn't optimized for our needs. Key Features: - Contact Management: The CRM should help us keep track of our clients' details such as their name, phone number, and email address. - Lead Tracking: We need to manage potential clients effectively; the CRM should help us track their status. - Policy Tracking: It's crucial for us to keep tabs on the policies we're maintaining for each client. Ideal Skills: - Extensive experience in developing CRM systems, preferably on Google Sheets. - Proficiency in setting up comprehensive contact databases. - Previous experience in developing systems to manage sales leads and t...

I am seeking a Shopify professional to import less than 100 products onto my store. You will be equipped with all product images, descriptions, and prices for a seamless upload process. Here's what I need: * Efficient import of product data * Immediate start and quick turnaround Ideal Skills and Experience: * Experience with Shopify platform * Strong attention to detail to avoid errors in import * Proven track record of delivering projects urgently Please, get in touch if you're equipped to deliver this swiftly.

I'm in need of a Certified Professional Accountant (CPA) from Canada who can put their signature on my financial statements. The documents to be signed include: - Balance Sheet - Profit and Loss Statement - Cash Flow Statement There's no tight deadline for this project. You should have certified authority to sign these statements and you should be reliable and meticulous. I appreciate detailed and thorough work. Previous experience with these types of documents is a plus. Your availability should be flexible enough to complete the task at ease. Looking forward to working with a knowledgeable CPA professional!

Hello, I am looking for an experienced MS Excel programmer to enhance and automate an existing Excel spreadsheet. The primary goal is to streamline the workflow by automating calculations and consolidating rows based on unique identifiers. Project Objectives: Automate complex calculations to increase efficiency. Consolidate multiple rows based on specific unique identifiers. Ensure data integrity and accuracy throughout the spreadsheet. Requirements: Proven experience with advanced Excel functions, including macros and VBA. Ability to troubleshoot and optimize existing Excel formulas. Strong attention to detail and a commitment to delivering precise and reliable results. Please provide your rates, availability, and examples of similar projects you hav...

I'm in need of a CPA to prepare complete financial statements for me. - Types of Statements: Specifically, I require an income statement, a balance sheet, and a cash flow statement. - Software Utilized: Presently, I am maintaining all my accounts and financial data in Excel. - Data Readiness: I have all essential data and records readily available for the preparation of these financial documents. Ideal Skills and experience: - Must have formal CPA certification - Proficiency in Microsoft Excel - Prior experience in preparing financial statements - Strong knowledge of accounting standards and regulations. Your detailed understanding of accounting principles and practices will make you the ideal fit for this task.

I am seeking a skilled Freelancer to develop a comprehensive sales dashboard on Excel. The purpose of this project is to streamline our sales data for easy comparison and analysis on a daily, monthly, and quarterly basis. Key Features Required: - The ability to compare daily sales with last day's and last year's sales. - Monitor monthly actual vs budget vs last year. - Track quarterly sales performance. - Special attention should be given to the revenue growth metric. Ideal Experience and Skills: - Excel mastery - Proven experience in creating interactive dashboards - Knowledge in sales data analysis - Ability to create a user-friendly interface where data can be manually input efficiently and effectively Your role will heavily involve the organization of comp...

I am in urgent need of a Certified Public Accountant (CPA) to professionally review and sign my company's already-prepared financial statements - encompassing the income statement, balance sheet, and cash flow statement. Key responsibilities include: - Rigorously reviewing the provided financial data - Signing off these statements post-review Note: All required financial data and records have been duly prepared and are readily available for review. Presumably, no particular statements necessitate special notes or disclosures as per the prevailing accounting regulations or my company policies. An ideal candidate must: - Be a Certified Public Accountant (CPA) - Boast significant experience and a keen eye for detail - Demonstrate a deep-seated understanding of financial s...

data entry (copy EAN code, SKU, and size) from label /image 2.300 label /image to Excel spreadsheet / google sheet file.

Dans chaque fichier PDF vous trouverez des QCM où chaque question peut comporter une ou plusieurs réponses correctes, indiquées par des cases cochées. Pourriez-vous créer un tableau à deux colonnes : la première colonne co...comporter une ou plusieurs réponses correctes, indiquées par des cases cochées. Pourriez-vous créer un tableau à deux colonnes : la première colonne contiendra la question et la seconde les réponses associées. Les réponses multiples seront inscrites dans la même case, séparées par un retour à la ligne. Peux tu me faire un fichier differents google sheet ou chaque fichier pdf sera sur un onglet avec questions et ses reponse...

VBA EXCEL Bulk SMS Template

I need a detailed Microsoft Excel spreadsheet that tracks expenses related to Hurricane Ian and deducts them from my current house appraisal. Key aspects of the project: - **Expense Tracking**: The spreadsheet should offer a detailed list of expenses. These should be categorized (e.g. repairs, replacements, labor). - **Formula Integration**: It should also include formulas that automatically calculate the sum of these expenses. Ideal Candidate: - Proficient in Microsoft Excel - Experience creating detailed expense tracking sheets - Familiarity with property appraisal processes and calculations Please submit examples of similar spreadsheets you've created in the past.

I'm keen to establish a reliable import/export operation for food and beverage products in Costa Rica. I need specialists who can assist in customs clearance, freight forwarding, and documentation. The ideal professional should have the following skills and experience: - Experience in customs clearance, freight forwarding, and documentation in Costa Rica - Deep knowledge of the local market, regulations, and procedures - Proven track record of handling food and beverage products - Strong communication skills to ensure a smooth process - Time-management skills to meet deadlines I appreciate specialists who can offer insights and suggestions to optimize the process and ensure efficiency.

Se necesita personal para delegar tareas sencillas administrativas: manejar email, hacer llamadas para informar a clientes (no ventas), y otras tareas típicas de secretariado. Tendrás una persona contigo dándote el training así como módulos de aprendizaje de tus tareas. 1. Manejo de Office (Outlook, Excel y Word). Indicar si sabes usar y configurar cuentas en MS Outlook. 2. Horario compatible con España - GMT+1 (tienes que tener disponibilidad desde las 12 en la mañana) 3. Voz agradable, simpática. De atención al cliente. 4. Indicar experiencia en redes sociales, cuales tienes y qué has hecho con ellas ¿solo uso personal o para alguna empresa? 5. ¿Qué resultados lograste en términos d...

I am seeking a skilled part-time accountant to assist with bookkeeping and tax preparation tasks. Key Responsibilities: - Handling Bookkeeping: Your primary responsibility will be to maintain accurate financial records using Excel spreadsheets and Tally ERP 9. - Tax Preparation: You will also be responsible for preparing our taxes, particularly VAT. Ideal Candidate: - Proficient with Excel spreadsheets and Tally ERP 9 for maintaining financial records - Experience in tax preparation, particularly VAT - Knowledge of accounting principles and practices - Excellent organizational and time-management skills - Ability to work remotely and meet deadlines Please note that familiarity with Saudi VAT regulations is crucial for this position.

I'm in need of an experienced and reliable financial professional to handle our bookkeeping tasks. Key responsibilities will include: - Regular, ongoing bookkeeping using popular software like QuickBooks or Excel. Ideal candidates should: - Have a strong background in bookkeeping and finance. - Be proficient in using bookkeeping software (e.g., QuickBooks or Excel). - Have a track record of delivering accurate and timely financial services. This project is about maintaining our financial records with precision and efficiency. It's crucial that the freelancer is able to commit to regular, ongoing bookkeeping tasks.

I discovered the power of Google Doc in recognizing manually written data. I have typed tables with handwritten data. The problem is that when I import my data into Google Doc the formatting is not respected. I have to add that these tables I want to transfer them to excel I would like to make it an automatic process take a pciture then convert the picture to excel

...trends in commercial design, particularly in healthcare. Location Information: - The project is planned in Saudi Arabia. - The project spans over an area of 546 squared meters on two floors. The project will involve: - Creating a modern design concept for the clinic that aligns with the corporate logo. - Providing detailed floor plans (dwg and pdf formats), 3D renders, and material suggestions (excel format for each floor/room). - Ensuring the design supports a professional and welcoming atmosphere for both staff and patients. Timeline: - Project shall be handed over 30 calendar days after the Kickoff meeting date. - Project date inclusive of two review sessions. Upon award of the project, the successful bidder will be handed over three dwg file for the location which shall...

...medical records from a variety of locations and consolidating them into a master excel spreadsheet. In summary, the records include patient histories, immunization records, various diagnostic results, lab results, radiological imaging, surgical history, vision and hearing tests, and dental records. Given the sensitive nature of this data, I would ideally seek out a professional with experience in medical data collection and health-related projects with experience accessing patient data from various portals. Tasks include: - Gathering required records - Converting these records into an Excel format - Utilizing a specific organization system for collation, based on my Excel template (attached) Intermediate Excel skills are important, along with an attention...

Hi, I have an excel file that contains 190 rows and 6 columns. I need someone to sort the data for me in a text file based on a specific required. Needs to be done now, in a short time frame. Type EXCEL at the beginning of your proposal if you understand the above. Proposals without it will be ignored.

I require assistance with accurate data entry of text data from digital files into a Google Sheet. Key Requirements: - Proficiency in data entry, particularly of text data - Experience with Google Sheets is essential - Attention to detail to ensure data accuracy - Previous experience in similar projects would be highly advantageous. Please let me know if you have any questions or need further clarification.

I want to design a system to build wordpress sites automatically. My system flows will like this 1. Choose template in library 2. Fill domain 3. Create website I am looking a solution and i found Softaculous, but i cant design good one. 1. I have many template to create as backups 2. I want to import to system and show screenshots in library 3. User add domain and provide cloudflare api to setup dns and domain 4. We will download remote backup was configed in setting 5. Restore / Install backup 6. After installing successfully, we will notify to user it is finished Thank you

...currently in need of a skilled professional who is adept with Microsoft Excel to assist me in a task that involves highlighting multiple cells within a spreadsheet swiftly. The key details of this task are as follows: - The data within the cells that require highlighting are textual in nature. We're looking to apply emphasis on particular pieces of text within the document. - The focal point of the highlighting is based on specific conditions. In this case, the cells should be highlighted based on containing certain text. Skills and experience required: - Proficiency in Microsoft Excel is essential. - Familiarity with conditional formatting in Excel to highlight cells. - Experience working with text-based data in Excel. - Attention to detail to ensure ...

I'm in need of a virtual assistant to support me with a variety of tasks including online search, maintaining data in an xl file, and making cold calls to potential customers. Key Responsibilities: - Conduct online research as needed - Maintain data in an excel file - Make cold calls to prospective clients The ideal candidate should be proficient in: - Online research - Data entry using excel - Cold calling I will require daily updates or reports on the tasks completed.

I need a skilled data entry specialist to help me transfer data from printed documents into an Excel spreadsheet. The data requires careful attention as it must be accurately and consistently entered. Ideal Skills and Experience: - Proficient in data entry - Attention to detail - Ability to consistently maintain data quality - Previous experience in similar tasks would be beneficial.

...experienced freelancer to add my physical products to my Woocommerce store. The selected candidate will need to: - Handle a range of physical products: My products come in a variety of sizes and colors, so experience with variable products in Woocommerce is a must. - Manage product information carefully: As I have a significant number of products, I will be providing the product information in an Excel/CSV format. The freelancer will need to ensure that this data is accurately transferred into the Woocommerce platform, including details on variations. Some products have 10 variables some products have 5, It's between 2-15 variables no more no less, If you understand all the above please type the price per product at the beginning of the proposal with the word RED. Propo...

I'm in need of a proficient developer with experience in both Excel VBA and Selenium to create a template that enables automated sending of bulk WhatsApp messages. The core functionality I'm seeking includes: - Automated WhatsApp messaging directly from Excel - Bulk messaging support: The capability to send out multiple messages at a time. The messaging content that will be automated is primarily related to the Products and Services information. The ideal candidate for this project should have a demonstrated history of working with Excel, VBA, and Selenium. Experience with similar projects relating to WhatsApp and bulk messaging automation would definitely be a plus. This will be a unique project with potential for ongoing work and tweaks d...

Hello We are changing server and we are facing an issue to import in phpmyadmin some tables of an extension "amasty gdpr" There is lot of tables like this bottom one, those queries are giving error in phpmyadmin : Errcode: 150 "Foreign key constraint is incorrectly formed" They are talking about same problem and extention "amasty" here : We don't know how fix this It works very well on old server but we cannot migrate to new server because of this problem CREATE TABLE `amasty_gdpr_privacy_policy` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Id', `created_at` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'Date of creating', `policy_version` varchar(10) NOT NULL DEFAULT '' COMMENT 'P...

I'm interested in having an Excel template developed which uses VBA to automate the sending of bulk SMS. Major points of focus in this project are: -- Compatibility: The template should be compatible with Excel 2010, 2013, and 2016. -- Phone Numbers Input: I'd like to manually enter phone numbers from which the SMS will be sent. -- Message Customization: Depending on the requirement, both the same message may need to be sent to all recipients and different messages to each recipient. The ideal freelancer for this task should be proficient in Excel, VBA, and have experience in automation. Strong communication skills would be appreciated to better understand and implement the specifics of message customization.

I'm seeking a skilled mobile application developer to help me transform an existing Excel file into a functioning Android app. The primary purpose of this app is to perform calculations using the data inputted by users. This project requires the developer to have a strong knowledge of: - Android app development - Data handling in mobile applications - Implementing calculations It would also be beneficial for the prospective freelancer to possess prior experience in transitioning from Excel to a mobile application, ensuring the seamless implementation of these functionalities.