Vba sheet työt

Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies the Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is available and the Project needs to be done using Visual Studio. Azure SQL database management and required SQL queries are not in the scope of the Project.

Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies andthe Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is avaiable and the Project needs to be done using Visual Studio. Azure SQL database and required SQL queries are and database management is not in the scope of the Project.

Excel Add-In joka hakee ja tallentaa taulukkomuodossa olevaa dataa Azure SQL-kannasta/-taan. Lisäksi ohjelmallista Excel muokkausta ja hallintaa C#-koodilla. Osaan Excel muokkauksista valmis VBA-script, joka muutettava C#-kielelle. Visual Studio 2015 alkukoodi, SQL Azure tietokanta ja kyselyt valmiina.

I have an Excel sheet full of text data that I need typed up. The data is currently in a PDF file, so you'll have to extract it from there. Once the data is in the Excel sheet, it needs to be organized into tables. Key Requirements: - Data entry of text from a PDF into Excel - Organizing text data into tables in Excel Ideal Skills: - Proficiency in Excel - Fast and accurate typing - Attention to detail - Experience with data formatting in Excel Looking for someone who can complete this task in a timely and error-free manner.

I'm looking for a freelancer with expertise in data entry to assist with tasks in Excel. Tasks: - You'll be working to enter data into an Excel sheet. Nature of Data: - The data to be entered will be a mixture of numerical and textual. Size of Project: - You'll be handling an Excel sheet containing between 100-500 rows and columns. Required Skills: - Proficient in Microsoft Excel - Fast typing skills with a strong attention to detail. - Strong numerical and textual data entry skills.

I am based our of New Delhi and for some work, I need to submit unaudited balance sheet of my company with TO of approx 1 CR . I can support with all the data. I need it asap. All necessary financial statements will be provided to support the balance sheet preparation.

I'm looking for a detail-oriented freelancer to help me with an Excel data entry project. The task primarily involves typing text from scanned documents into my Excel sheet. **Key Requirements:** - Accurate typing of text from scanned documents into Excel - Organizing the data into tables and lists **Skills Needed:** - Proficient in Microsoft Excel - Attention to detail to ensure accuracy - Experience in data entry, ideally with scanned documents - Ability to organize data into tables and lists The ideal candidate should be comfortable working with scanned documents, have a knack for accuracy and attention to detail in typing, and be able to organize the data effectively into tables and lists in Excel.

I have a set of printed documents that need to be transcribed into an Excel sheet for easy access and analysis. The data is primarily textual, composed of various types of written information. Requirements: - Expertise in data entry, particularly with Excel. - Proficient in English to accurately interpret the text. - Experience with printed document transcription is preferred, but not required. The ideal candidate must be detail-oriented and meticulous, as the accuracy of the data entry is crucial.

I have a document that needs to be typed up. It's scanned, so you must be able to read and type from scanned documents. The document is in English, so fluency in English is essential. The final document should be in plain text format. Ideal Skills and Experience: - Fast and accurate typing skills - Experience in copy typing, particularly scanned documents - Proficiency in English language - Familiarity with converting documents to plain text format.

I have a project which involves transferring text data from PDF documents into an Excel sheet. The data is purely text-based and will need to be accurately inputted. The ideal freelancer for this project would: - Have experience with Excel data entries, especially involving text - Be proficient in working with PDF documents - Have previous experience in data import from different formats Your job will largely involve: - Importing data from PDF files into Excel accurately - Ensuring correct data input without losing any details - Maintaining the original structure and formatting wherever necessary Please ensure the completion of this project in a timely and precise manner.

I am in need of a detail-oriented professional capable of transcribing data from my digital documents to an Excel spreadsheet. Key responsibilities include: - Data entry into an Excel sheet - Dealing with less than 5 fields or columns per entry row Ideal candidate will have: - Proven experience in data entry, particularly when extracting from digital formats - Solid knowledge of Excel and its basic functions - Strong attention to detail - Ability to work in a timely manner - Good communication skills for any necessary clarifications

I'm in need of an expert who can assist with financial analysis and create a 5-year sales and expenses forecast for my startup. I'm specifically looking for a professional who can: - Perform a comprehensive financial analysis for my start...forecast using customizable templates. - Include a detailed cash flow analysis in the forecast. The ideal candidate for this project should have: - Proven experience in financial analysis and forecasting. - Proficiency in creating customized financial templates. - Strong expertise in conducting cash flow analysis. - Ability to deliver high-quality work within a reasonable time frame. Example sheet attached below (it's reference purpose, not editable) I'm looking forward to receiving bids from highly skilled and experience...

I require a meticulous individual who is adept at data entry into Excel, with precision and accuracy being top priorities. - The task involves entering various types of data, including numeric, text, and alphanumeric, ensuring it is correctly and appropriately categorized. - The Excel sheet will consist of two columns which will require careful management for data uniformity and consistency. - The entered data should be organized based on the input order, therefore, attention to chronological details is paramount. The successful bidder should have proficient data entry skills and a keen eye for detail for successful completion of this project. Prior experience in similar projects would be an advantage.

Please read the attached instruction sheet along with below details before you bid Kindly bid if you are experienced in image editing...set in pixel -900 X 700+save to .png format and webp format The sample of the requirement is attached for your reference.... your quote will be considered for 1000 products images. All the images is for grocery shop 1) All products should be cropped individually from the brochure or image or website link, The same shall be shared to you as per the required data. Any visible imperfections need to be painstakingly cleared off. Each picture will have to be improved in terms of lighting and contrast to make it more visually appealing. 2) the Size of the image should be 900 X 700 (Sample attached for your reference) 3) No Duplicates images should be c...

...confirming their details, and their current role and skills; identifying the industry or industries they can work in; and, hopefully, bringing them back to the organisation as an active candidate to place. The role will include: - Cold calling to candidate data provided based on the script provided - Gathering and confirming information based on the script provided - Updating the information in the sheet provided - Returning regular updates on progress, highlighting any active candidates open to exploring opportunities Once the initial project is completed, we may have further project requirements, to be determined....

I need an Excel 365 PowerQuery or VBA script that can fetch daily market data and handle potential data source interruptions or changes. Google Shhets example =INDEX(IMPORTXML("" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). <Where C31 = Cell containing the Stock eg GB00B8XYYQ86, LU1033663649 or GB00B0CNH163 I need an identical function in MS365 Excel - either with PowerQuery OR VBA (preferable) Ideal skills: - Proficiency in Excel 365 and PowerQuery and VBA - Experience in web scraping and handling dynamic data sources. I am after a fixed quote for this project.

I am currently seeking a virtual assistant to help me with my job hunting in the technology sector. The role of the virtual assistant will primarily involve: - Job application submissions: The ideal candidate should be proficient in submitting job applications o...senior-level positions in the technology industry. This includes customizing cover letters to match job descriptions and ensuring that all required documents are submitted. Sharable resources: - resume - guide doc. Salary: $25 per week Responsibilities: - open job board platform accounts with my profile - apply for 200 proper jobs matching my profile every weekday - record them in the google sheet. Requirements: - fluent English is a must - prior experience working on similar stuff - software engineering knowledge is a...

Dough one Sources is looking candidates for Senior Business Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 200 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good Technical kno...

I need an Excel sheet created with the primary purpose of data analysis. This sheet should have the following features: - Data Sorting and Filtering: This is crucial for making the analysis process efficient and easy to navigate. I need the sheet to be able to handle large amounts of data and allow for quick and convenient sorting and filtering. - Data Visualization: In addition to the data analysis, I also require the sheet to include line graphs. I believe that visualizing the data will make it much easier to understand and interpret. The ideal freelancer for this project is someone with a strong background in Excel and experience in creating data analysis tools. It is important that the final product is user-friendly and has a clean, professional appearanc...

I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-friendly interfaces for Excel.

Here is a brief of my requirement. What I want is when I am creating a collection page, the way I can actually sort the product is either through best selling item, product title,...product title, highest price or lowest price, new best oldest and manually. Now we have thousands of product in a collection at the moment hundreds of them. What we want to do is instead of the regular product filter which is available on Shopify, we want to have a custom one with the logic on the basis of either row as or basis on the conversion rate. So we can actually connect this with the Google sheet or we can actually have an identifier in terms of how the product would change their, how would product would look on the collection page in terms of where they are on the collection page basis of an id...

...task involves creating a new column labeled Images in both Excel sheets and inserting corresponding image links. This integration is crucial for ensuring that when uploading a CSV file to Shopify, each product will display its respective images seamlessly. Project Details: Scope: Adding image links to Excel sheets for 666 products in total. Task: Create a new column labeled Images in each Excel sheet and insert corresponding image links for each product. Requirements: Image links should open the respective product images when clicked. The CSV files must be Shopify-compatible without any issues upon upload. Deadline: Project completion required within the next 48 hours. Quality Assurance: Accuracy is paramount, as each CSV file will be cross-checked before final approval. Delivera...

I'm looking for a VBA expert who can help me automate the modeling of intermediate mechanical components in Autodesk Inventor. Key Requirements: - Automate part modeling in Autodesk Inventor - The parts to be modeled are intermediate mechanical components, such as gears and brackets - The VBA code should allow user input for customization of the parts, specifying dimensions and features Ideal Skills and Experience: - Proficient in VBA programming - Previous experience with Autodesk Inventor - Strong understanding of mechanical components and their modeling - Ability to incorporate user input into VBA code for part customization This project is perfect for someone who enjoys automating processes and has a good understanding of mechanical engineering prin...

I need an experienced freelancer to assist me in typing data from handwritten notes into an Excel sheet. Key Requirements: - Previous Experience: Please include details of your previous work in this area - Handwriting Deciphering: Due to the nature of the data being handwritten, you'll need to have good skills in deciphering handwriting - Accuracy: It's crucial that the information is entered into the Excel sheet with the highest level of accuracy Looking forward to your application.

...looking for a programmer with expertise in the Twitter API and JavaScript for Google Sheets. I require assistance in setting up the Twitter API and need a custom script written for Google Sheets. Here are the specific requirements for the project: Project Objectives: 1. Script Functionality: - Automatically fetch Arabic text from a specified Twitter account and insert it into Column B of a Google Sheet, starting from Row 2. - Retrieve and insert links for images and videos associated with the tweets into Columns C, D, E, and F respectively. 2. Automation and Updates: - The data retrieval process should be automatic and occur in real-time, ensuring the Google Sheets document is updated continuously, irrespective of whether it is currently open. - Include functionalit...

I have a google sheet with 400 exercises. I need to copy them all over to a notion document with a slightly different format. Here is the google sheet — https://docs.google.com/spreadsheets/d/1SCYzmyfXgZfhu4TFkBi0YQzbXjrzl4O-hVyZZ1eo1HQ/edit#gid=0 Here is the notion table (I will provide access to edit) — I need all of the videos from “Jen’s Exercise Demos” copied over with the name, the video url and the howToTips into the correct columns. All of the videos are vimeo links so should have “vimeo” selected in the videoType column Many of the tips have multiple number bullet points, I need there to be 2 lines between each bullet point, as demonstrated in the example rows. Equipment and

I have a number of scanned documents that contain financial figures. I need someone to accurately type these into an Excel sheet for further analysis. Key Requirements: - Experience with data typing and analysis in Excel, particularly financial data. - Attention to detail is paramount; precision in typing is crucial for the accuracy of the analysis. - Proficiency in English is a must, as the data will be in English and will need to be accurately transcribed. The ideal candidate should have prior experience in financial data entry and analysis, and comfortable working with scanned documents. Your work will be the foundation for subsequent data analysis, so precision and attention to detail is key.

I have a project where I need you to work with numbers in an Excel sheet. Ideal Expertise: - Proficiency in data entry - Strong knowledge of Excel - Attention to detail - Ability to maintain accuracy and consistency in data entry - Proven experience in similar projects - Able to meet deadlines Please let me know if this is something you can assist with.

I require a meticulous professional to help transfer text data from a series of printed documents into an Excel sheet. There's no special symbols or diagrams at all, just plain text. Ideal Skills and Experience: - Thorough understanding of Microsoft Excel - Attention to detail - Proven experience of working with printed documents - Excellent typing speed with the high level of accuracy The project needs to be completed accurately with consistency and timely manner.

I am seeking an expert in email scraping for the purpose of building a marketing database. The ideal candidate can efficiently scrape emails and the company names. Key Aspects: - Attention to detail to ensure all relevant emails are scraped accurately and co...purpose of building a marketing database. The ideal candidate can efficiently scrape emails and the company names. Key Aspects: - Attention to detail to ensure all relevant emails are scraped accurately and company name is also with. - Quick turn around, the project should be completed within a month. - Extensive experience in email scraping and database construction. I need this in a google sheet document. The approx amount of names/emails is 12.000 - 14.000 on the website. I need a fixed price offer and also time frame...

I'm currently facing some issues with my Excel tracker. - The tracker contains a VBA macro file which seems to be causing formula errors and formatting issues. I'm unsure of the exact nature of these errors, but it's clear they are impacting the accuracy and usability of the tracker. I need a freelancer who can review and rectify these issues in the tracker. An ideal candidate would have strong experience with VBA and Excel, able to handle complex formulas and troubleshoot formatting problems swiftly. Your goal is to ensure that the tracker is fully functional and error-free. Experience with similar projects will be a plus.

I need an Excel VBA code that can perform exact word matching within an Excel spreadsheet. - The code should generate a list of matched words.

I'm looking for an expert in Excel to assist with a project involving data entry and analysis. The Excel sheet you'll be working on has more than 50 columns and rows and will contain a mix of text, numbers, and dates. You'll be responsible for the following: - Accurate and timely entry of the data provided - Ensuring the data is appropriately formatted and organized - Conducting thorough data analysis, including but not limited to trends, comparisons, and any other insights that can be drawn from the data The ideal candidate for this project should have: - Proficiency in Excel and experience with large data sets - Strong attention to detail - Ability to perform data analysis and present insights - Good communication skills to provide regular updates and seek clarif...

I require a freelancer to type text data into an Excel sheet from printed documents. Scope of work: - Convert printed text documents into digital format via Excel - Ensure data is accurately entered The project does require specific formatting: - Data should be arranged in rows Ideal candidate: - Must have proficient Excel skills - Experience with data entry - Attention to detail, to ensure accuracy in work - Able to follow specific instructions for data organization

I have an excel sheet with intermediate complexity data, including formulas and charts. I need someone to transfer this data into tables, with the primary goal of organizing the information for better clarity and ease of understanding. Key Tasks: - Type the data into tables: This needs to be done with meticulous attention to detail to ensure accuracy and integrity of the data. - Apply borders and shading: To enhance the visibility of the tables and make them aesthetically pleasing. - Utilize headers: Rows and columns should have appropriate headers to aid in quick data navigation. Ideal Freelancer: - Proficient in Excel: Ability to work with intermediate level of data such as formulas and charts. - Strong attention to detail: Critical for ensuring that data is entered accurately. ...

I need a word document translated from English to Russian as soon as possible. The file has 800 words. Need high quality human translation only. Google/AI or automatic software works are not allowed and will be rejected. Need the translation back in word document format maintaining the formatting and layout of the source file. I would also need an excel sheet prepared, with source texts in column A and translation column B. Need this to be done within 5-6 hours of awarding the project. Bid only if you are available to do it now. Price: 12 CAD fixed. Deadline: 5-6 hours max Don't bid if you don't agree the price and timeframe. Thanks!

I'm looking for an Excel expert who can create a comprehensive sales target tracking spreadsheet for my customers. This spreadsheet should have several key functionalities. Features Needed: - Customer Information: It should contain a section where I can input and maintain all my customer's details. - Sales Tracking: The spreadsheet should enable me to track my sales targets daily and provide a detailed analysis of my performance. - Target Achievement: The spreadsheet should also be able to analyze the achievement or shortfall of selected items target completion by each customer. Analysis Required: - I would love to have a feature that shows how well sales targets are being achieved as per defined targets. Ideal candidate should have great attention to detail, proficiency ...

Input:- You will get an excel file as input. Step1- Sort the Excel file by site name and place data in sheet 1 Step2- Sort the Excel file by site address and place the data in sheet 2 Step3- Sort the Excel file by latlong and place the data in sheet 3. After Sorting and creating 3 different sheet, we need to apply the logic to find exact duplicate and high match. Example - means in sort by site name we will find exact duplicate and high match site(75%) match and print exact duplicate/ partial match. Then for exact duplicate and partially match we are going to compare all row and need to print what is matching like site city, site state, site country etc

**Tour Costing Sheet Structure** 1. **Tour Details** - Tour Name - Tour Code - Duration - Destinations 2. **Client Information** - Client Name - Number of Adults/Children - Contact Information 3. **Accommodation** - Hotel Name - Room Type - Meal Plan - Cost per Night - Total Nights - Total Cost 4. **Transportation** - Vehicle Type - Distance - Cost per Kilometer - Total Cost 5. **Sightseeing and Activities** - Activity Name - Per Person Cost - Number of Persons - Total Cost 6. **Miscellaneous Expenses** - Guide Fees - Entrance Fees - Other Expenses 7. **Pricing** - Subtotal (Sum of all costs) - Markup Percentage - GST (Goods and Services Tax) - Final Price 8. **Payment Details** - Deposit ...

I'm looking for a freelancer to help with a simple Excel data entry task, as well as some basic formula work. I have a spreadsheet that primarily contains numbers. Your role would be to accurately type this data into the sheet, ensuring that every entry is correct and in the right format. This task is meant for particular record-keeping purposes, so precision and attention to detail are crucial. In addition to the data typing, I need some basic Excel formulas applied. Experience with Excel and knowledge of formulas is essential to ensure the data is well-organized and easy to work with. This task is not overly complex but will require someone who is proficient with Excel's formula functions.

I am seeking a proficient Google Sheets expert to construct a live dashboard/leaderboard that visually represents daily sales tallies completed by individual sales reps. Key specifications: - Data to be pulled from a Master Google Sheet. - Incorporation of both total sales and individual rep sales. - The dashboard should display sales data for the current day while maintaining access to historical data. - Historical sales data should be visualized through a bar graph. Skills & Experience: - Attention to detail - Time management and delivery on tight deadlines - Proficiency in Google Sheets - Experience in creating dashboards. - Familiarity with data visualization and report generation - Strong analytical skills and precision Your ability to deliver this project efficientl...

I need a word document translated from English to Russian as soon as possible. The file has 800 words. Need high quality human translation only. Google/AI or automatic software works are not allowed and will be rejected. Need the translation back in word document format maintaining the formatting and layout of the source file. I would also need an excel sheet prepared, with source texts in column A and translation column B. Need this to be done within 5-6 hours of awarding the project. Bid only if you are available to do it now. Price: 12 CAD fixed. Deadline: 5-6 hours max Don't bid if you don't agree the price and timeframe. Thanks!

...The report should contain data from the MySQL database, calculations or summaries of data, visualizations or charts, and be structured as a paginated report, using SQL language. The report should be designed to be accessed as a printable PDF document. It is not required to be interactive, as a static report is sufficient for my needs. Key Requirements: - Proficiency in Microsoft Access, MySQL, VBA, PDF, Python, and Excel - Competency in SQL language for data manipulation - Experience in designing paginated reports The ideal candidate should have a proven track record of creating similar reports, with the skills and knowledge necessary to work with the specified technologies. Your ability to deliver a professional, well-structured, and visually appealing report within the give...

I need a word document translated from English to Simplified Chinese as soon as possible. The file has 800 words. Need high quality human translation only. Google/AI or automatic software works are not allowed and will be rejected. Need the translation back in word document format maintaining the formatting and layout of the source file. I would also need an excel sheet prepared, with source texts in column A and translation column B. Need this to be done within 5-6 hours of awarding the project. Bid only if you are available to do it now. Price: 12 CAD fixed. Deadline: 5-6 hours max Don't bid if you don't agree the price and timeframe. Thanks!

Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.

I'm seeking a professional who can create a product sell sheet. This will serve to attract potential customers, provide detailed information about the product and highlight its unique selling points. This sheet will mostly target business professionals and specific industry professionals, so it's essential that the information is organized, concise and professional. Key details that must be included in the sell sheet are a compelling product description and relevant pricing information. Please note that mastering the balance between being informative yet persuasive is key for this project. Ideal skills for this job: - Copywriting - Graphic Design - Marketing & Sales - Industry-specific knowledge could be an asset Experience in developing impactful se...

As a professional with high-volume data, I'm seeking a highly skilled Excel expert. You should have proficiency in: - Data analysis - Data visualization - Excel formulas, functions and macros - Visual Basics Application (VBA) I'm dealing with more than seven datasets, each one having high complexity (many columns and over 5000 rows). I will need your expertise in managing and understanding this data. Ability to quickly comprehend and adjust to new data structures would be advantageous. Proven experience with large data sets and advanced Excel usage is a must for this project. Please include examples of previous similar work in your proposal.

2 excel files with VBA macro as per customer requirement

One excel file with macro as per requirement

I'm looking for an expert to assist with an important aspect of my Autocad project - calculating the material needed for ducts from drawing to excel sheet. Your main task will be to extract the dimensions and quantify each type of duct in the drawing. Key Responsibilities: - Extracting precise information from Autocad drawings - Accurately entering data in Excel for duct types and dimensions Skills and Experience: - Proficiency in Autocad and Excel - Strong understanding and experience in drafting and design - Excellent attention to detail - Experience with duct design or HVAC systems would be advantageous. Please note, material types are not specified for the ducts. This project primarily focuses on quantity and dimensions.