Vba excel program databaseงาน

I'm looking for a professional who can proficiently split Column D in my Excel spreadsheet into columns E, F, G, H . This data must remain on the same sheet post-split progression. I have provided an example in row 2 Key requirements: - Excel proficiency with experience in splitting columns - Ability to deliver quality work in a timely manner - Must respect data privacy Any freelancer applying for this project should include their relevant Excel experience to demonstrate their skill. This task needs to be completed quickly and correctly, so I need someone who knows their way around Excel. Let me know if you're up for it, I'm eager to get started on this as soon as possible.

I'm currently facing an issue on my website where frequent database connection errors are appearing. I'm seeking a knowledgeable and experienced professional who can address this problem diligently and efficiently. Key tasks will include: - Identifying the source of the database connection error. - Implementing a robust solution to eradicate these errors permanently. The ideal freelancer for the job is someone with: - Proficient understanding of database maintenance and troubleshooting. - Proven experience in debugging and fixing similar issues. - Ability to work independently and communicate progress effectively.

Looking for an efficient, detail-oriented freelancer to recreate an existing one-page design on an Excel sheet, intended solely for data entry. You must be swift but precise, ensuring all data entered is accurate and comprehensive. I will provide the design for recreating, so your task will be purely focused on data entry. Skills & Experience: - Proficiency in Excel - High attention to detail - Speed in data entry without jeopardizing quality - Familiarity with handling and organizing large data sets.

I have a database that I need to be cleaned up. The main task is to remove duplicate entries. Key Points: - Main Task: The primary goal of the data cleaning project is to remove duplicate entries in the database. - Handling Duplicates: The duplicates should be automatically deleted, not merged or manually reviewed. Ideal Skills & Experience: - Database Management: A strong background in database management is crucial for this task to ensure the data is processed correctly without compromising the database integrity. - Data Cleaning: Experience with data cleaning processes, especially in handling duplicate records, is important. - Automation: The ability to automate the deletion of the duplicates efficiently and accurately is essential. Please bid...

I'm looking for a developer experienced in pointer data structure , garbage collection, file allocation , pure C, and core C fundamentals. Your task will be to analyze and redefine the flow chart of our existing program. The program in question mainly focuses on file input and file type user interface design. However, as the details for improving are not specified, your fresh perspective is needed to suggest improvements beyond our focus. Expertise needed: - Proficiency in programming, along with C and core C basic. - Skill in evaluating and redesigning program flow charts. - Experience in user interface design is absolutely critical. - Ability to suggest elements for improvement and execution strategies. Get ready to dive deep into our code, streamline our ...

I need a software that checks me in real time an entire database of amazon ASINs in .csv format (3,000,000 asins) , and when the price of one of the asins falls below a price I choose it should notify me on telegram , all with the use of proxy .

I'm in need of a proficient data entry professional who will enter customer data into Excel spreadsheets. Key Responsibilities: - Transfer customer data accurately into Excel - Double-check data for mistakes or inconsistencies - Maintain confidentiality of customer data Ideal skills and experience: - Proficiency in Excel - Attention to detail - Experience with data entry tasks - Strong understanding of handling sensitive customer data.

I am seeking a proficient freelancer who can effectively extract data from six graphs (line and area) and reproduce the graph in Excel. Please review the attached Excel file for grahps (3 of them are already processed as an example). Ideal Skills & Experience: - Demonstrated ability in data extraction - Excel competence - A keen eye for detail Freelancers should include examples of their past work for consideration. Your bid should be reflective of your skills and experience. I am looking forward to viewing your proposals. Please make them as detailed as possible.

I urgently require a professional to help me with an operations job. The specific tasks and software knowledge required are undefined as I am currently uncertain of my specific needs. Ideal Skills and Experience: - Experience in diverse operations tasks like data entry, order tracking, and document organization - Proficiency in using a range of software like Microsoft Excel, inventory management systems, and quality control software. A willingness to adapt and the ability to quickly pick up new tasks would be extremely beneficial for this role.

...due the data in the database) developer to create a set of scripts that will synchronize data between my AuctionWizard2000 database and my Opencart (cubecart, oscommerce) database. I have a python script done by previous contractor who dropped the project for the personal reason, so there is no issues with source and target db structures, mapping of the fields. etc. Need an to refresh and do an extra polish. My specific requirements are as follows: 1) Learn the structure of AW 2000 database (old Paradox format, but work fine via Windows ODBC) - download here setup exe file, install it, run trial, restore inventory database from the link I will provide and use this data for the export-import. Paradox DB files are in database folder. 2) Lear...

I have a significant amount of physical documents that need to be transferred accurately into an Excel spreadsheet. I plan to mail these documents to you on a regular basis for entry. Your responsibilities will include: - Accurately entering the data from the physical documents into an Excel spreadsheet - Ensuring that the data is error-free - Organizing the data in a clear and logical manner - Maintaining confidentiality and security of the documents The ideal candidate will have: - Proven experience in data entry, preferably from physical documents - Excellent attention to detail - Proficiency in Excel - Good organizational skills - Ability to maintain confidentiality Looking for a reliable and meticulous person for this ongoing project.

I need an Excel spreadsheet designed for a project I'm working on that involves calculating the necessary Newton meters for a waterwheel and Newton meters of the hanging weights shafts, all while rotating. The front page of this spreadsheet will be dedicated to receiving calculation inputs. These will include: - Waterwheel dimensions: This involves measurements of the waterwheel, such as diameter, mass, etc. - Water flow rate: The rate at which water will be flowing onto the waterwheel. - Weight dimensions: Measurements of the weights that will be hung from the shaft. - Newton meters at the paddle: The unit of measurement for the Newton meters required at the waterwheel paddle. The ideal freelancer for this project should have: - Proficiency in Excel and d...

I'm looking to develop a Microsoft Access database to manage and print cage cards for laboratory mice from an existing Excel file. The Excel includes columns like Cage ID, Strain, Sex, Age, Mouse ID, and Notes, among others. Each card should group mice by their Cage ID and include relevant details such as Strain, Mouse ID, Sex, and Requirements:Database Development: Create a database from the Excel Card Design: Design printable cards with the listed Functionality: Enable direct printing from Interface: Simple UI for selecting and printing cage provide a quote and timeline for this project, along with any similar work you've done.

...to assist me in uploading my custom-made Excel Add-in to the Microsoft App Store. This involves making the Add-in available in Microsoft Office Excel's Add-ins. Key responsibilities include: - Uploading the Add-in to the Microsoft App Store: The candidate is expected to have experience with the Microsoft App Store's guidelines and processes. This includes preparing the necessary documentation, setting up the listing, and ensuring compliance with the platform's rules. - Making the Add-in available in Microsoft Office Excel: The candidate should be familiar with the process of making Add-ins available and accessible within Excel. This involves configuring the Add-in to be easily discoverable by users and ensuring a seamless integration into the Exce...

I'm looking for a Virtual Assistant with experience in lead generation for Instagram. However, I'm including in this post a training video so you under...acquiring valuable IG usernames and since my reps charge me a lot the only ones who can afford it is rich people. It also just so happens everyone who works in night life knows... rich people. :) Key Responsibilities: - Find mini partners (affiliates) in nightlife: vip hosts, promoters, club managers club partner companies, etc. - Inputing the above prospects info (names and emails) on a google excel sheet Skills and Experience: - Critical Thinking - Proficiency in using Instagram for business research - Experience in lead generation - Bonus: Experience in the nightlife industry Here's the video to watch:

As one aiming to maximize my productivity, I'm in need of a proficient data entry professional who can assist in data transcription, processing, and validation. This task revolves around: - Handling a medium scale data volume, approximately between 100-1000 records. - Processing data I have currently stored in an Excel Spreadsheet. Freelancers with the following skills are ideal for this job: - Expertise in Excel and data entry practices. - Experience in data validation. - Strong attention to detail. Your primary responsibility would be to ensure the accuracy and usefulness of my data efficiently. Your proficiency and speed are key to the success of this project.

I’m seeking a seasoned Excel macro expert with an efficient approach to task automation specifically for performing calculations. Key Requirements: - Expert-developed Excel macros that automate repetitive tasks, making my workload more manageable. - The macros created should focus on performing calculations, thus, speed and precision are of the essence. - Due to the nature of the project, potential contractors must understand Excel inside out, especially on how to configure and troubleshoot macros. No specific type of calculation was specified, therefore experience with a wide range of calculations from basic arithmetic to complex equations is integral. Your problem-solving skill will be a plus point as the ability to understand and improve current systems...

I’m seeking a seasoned Excel macro expert with an efficient approach to task automation specifically for performing calculations. Key Requirements: - Expert-developed Excel macros that automate repetitive tasks, making my workload more manageable. - The macros created should focus on performing calculations, thus, speed and precision are of the essence. - Due to the nature of the project, potential contractors must understand Excel inside out, especially on how to configure and troubleshoot macros. No specific type of calculation was specified, therefore experience with a wide range of calculations from basic arithmetic to complex equations is integral. Your problem-solving skill will be a plus point as the ability to understand and improve current systems...

I'm looking for a designer who can make one single lead-generation landing page for a website of mine. The main goal of the website landing page is to collect contact information from potential customers. from an ad campaign on click of CTA button, this landing page has to come up. I will prefer the generated leads to get accumulated on an excel sheet if its possible. I WILLNOT RESPOND BACK TO people who bid blindly by sending their portfolios.

I'm in need of a meticulous individual with strong attention to detail for a medium-scale data entry project. This particular project will involve: - Transferring and managing approximately 1,000 to 10,000 entries into Excel - Utilizing basic Excel skills such as sorting and creating simple formulas Experience in similar data entry projects and proficiency in Excel, particularly in the functions mentioned above, is a must. Budget, deadlines, and other specifics will be discussed further during negotiation. Your ability to deliver accurate and rapid results without supervision will be key to the success of this job.

I have a one-time project that involves converting a PDF file with tables into an Excel spreadsheet. The main purpose of this conversion is to extract specific information from the tables. Key Requirements: - Convert a PDF file containing tables into an Excel spreadsheet - Extract specific information from the tables Ideal Skills and Experience: - Proficiency in Python - Experience with PDF to Excel conversion - Ability to extract information from tables If you have the skills and experience I'm looking for, please submit your proposal.

I'm looking for an expert who can build an interactive excel tracker tailored for Sales, Marketing, and Finance departments. In addition, I need a 30-60-90 days plan template to help with our digital transformation process. Key Responsibilities: - Develop an interactive excel tracker for Sales, Marketing, and Finance departments - Create a 30-60-90 days plan template for our digital transformation - Ensure the tracker is user-friendly and the plan is adaptable to our specific needs Ideal Skills & Experience: - Proven expertise in developing interactive excel trackers - Background in digital transformation is a strong plus - Strong understanding of Sales, Marketing, and Finance processes - Familiarity with creating strategic 30-60-90 days plans - Excellent c...

I require a skilled and detail-oriented freelancer to assist me in organizing electronic cor...to the case. - Data Input: The extracted messages should be input into a spreadsheet and organized by topic/subject. - Spreadsheet Creation: The spreadsheet should include the following fields: Date, Message Content, and Attachments and also print and file all correspondence in date order etc. Ideal Skills and Experience: - Experience in data entry and organization. - Proficiency in using Excel/Spreadsheet software. - Familiarity with legal terminology and document handling (an added advantage). - Excellent attention to detail and organizational skills. More details will be provided to the selected freelancer. Please provide examples of similar projects you've completed in...

I am in urgent need of a professional well versed with Excel Operations to help typify a vast array of data into an Excel sheet. The data includes: - Text - Dates - Numbers A key part of this project involves adhering to specific formatting requirements, which include: - The application of currency formatting - Utilizing bold or italic text when necessary - Highlighting certain cells This is a time-sensitive project that requires immediate attention, therefore the ideal candidate should be able to commence work ASAP. Your experience with Excel, data entry, and attention to detail will be highly beneficial in executing this project.

I'm looking for a freelancer who can download pictures from an excel list that will be provided (see 2 attachments). Following are the specific project requirements: We need those pictures in 2 separate folders (f.e. zip or rar file), one for each excel list. All pictures must be saved with Superaction excel file Pictures must be saved with their code. f.e. (code is in column A). If in Column F there are more than 1 pictures, then save 2nd, 3rd etc. pictures like: , adiddv0318_4.jpg... Always in Column F (URL's for download), pictures without _a, _b... are the main picture (therefore must be saved like ). Pictures with _a, b.. etc. must be save as 2nd, 3rd ... (, ). If in Column F there is no picture without _a

I'm looking for a proficient WordPress developer to create a comprehensive relational database for my event marketplace website. This database should not only manage the product inventory but also store a range of user information and details about outdoor activities. Primary Responsibilities: - Developing a robust database to efficiently manage outdoor event organizer product inventory by sector, action, activity, and geo-location. User Information Storage: - The database should be designed to store personal identification and geo-location details of the users, including but not limited to their name, address, and contact details. - It should also be capable of storing users' preferences, which includes their preferred outdoor activities, preferre...

I'm seeking a seasoned FileMaker Pro developer to help address a few challenges with my database. The issues I'm currently experiencing include: - The 'Copy' feature is not functioning as expected. It's failing to accurately copy and paste records along with their associated data. - The 'Time Clock' element is encountering problems with incorrect calculations or logging. - The 'Sort' feature has not been set up properly to ensure consistent and correct sorting of data. Your primary task will be to rectify these issues and ensure the database is working smoothly. Ideal candidates should have: - Proven experience in developing and troubleshooting FileMaker Pro databases. - A keen eye for detail and problem-solving ski...

โปรดลงทะเบียน หรือเข้าสู่ระบบ เพื่อดูรายละเอียด

I’m seeking a seasoned Excel macro expert with an efficient approach to task automation specifically for performing calculations. Key Requirements: - Expert-developed Excel macros that automate repetitive tasks, making my workload more manageable. - The macros created should focus on performing calculations, thus, speed and precision are of the essence. - Due to the nature of the project, potential contractors must understand Excel inside out, especially on how to configure and troubleshoot macros. No specific type of calculation was specified, therefore experience with a wide range of calculations from basic arithmetic to complex equations is integral. Your problem-solving skill will be a plus point as the ability to understand and improve current systems...

I'm seeking a skilled individual to a... The spreadsheet will be primarily used for inputting income and expenses and should be updated on a monthly basis. Key requirements: - Design and development of a custom cash flow spreadsheet - Implement budget tracking, expense categorization, and cash flow projections - Ensure ease of use and understandability for monthly updates Ideal Skills: - Proficiency in spreadsheet software (e.g., Excel, Google Sheets) - Experience in creating budget tracking and cash flow projection tools - Strong understanding of financial data and analysis I'm looking for someone who can deliver a high-quality, user-friendly spreadsheet that meets these requirements. If you have relevant experience and think you're a good fit for this project, I...

I have a one-time project that involves converting a PDF file with tables into an Excel spreadsheet. The main purpose of this conversion is to extract specific information from the tables. Key Requirements: - Convert a PDF file containing tables into an Excel spreadsheet - Extract specific information from the tables Ideal Skills and Experience: - Proficiency in Python - Experience with PDF to Excel conversion - Ability to extract information from tables If you have the skills and experience I'm looking for, please submit your proposal.

I am looking for a professional with expertise in data entry a...conversion of my text-based PDFs into a spreadsheet format. Accuracy is essential in this task. Ideal Skills: • Proficiency in data entry • Experience with converting PDFs to excel or similar formats • Meticulous attention to detail ensuring 100% accuracy Responsibilities: • Convert text-based data from PDFs to spreadsheets error-free • Maintain record consistency, structure, and format during conversion • Verify the converted data for accuracy The successful candidate will have ample experience with data entry and PDF conversion, boasting a track record of impeccable accuracy. Knowledge of spreadsheet software like Excel is a must. Each transaction listed on one line, a templ...

I am in need of an individual to assist in extracting email addresses of all child care centers and compiling them into an Excel spreadsheet. Key project details: - Purpose: The extracted email addresses will be used as part of a contact database. - Usage: The contact database will primarily be used to offer services or products to these child care centers. Ideal skills and experience: - Proficient in data extraction and Excel spreadsheet handling. - Ethical data practices - the extraction must be legal and compliant with GDPR and any other relevant regulations. - Previous experience in email extraction or database creation would be a definite plus. This project will require a keen attention to detail and the ability to ensure accuracy in the data ex...

I need a freelancer to scrape text data from a PDF and output it into separate cells by paragraph in an Excel document. Key Requirements: - Extract and convert text data from a PDF into a structured Excel file. - Each paragraph should be in a separate cell in the Excel sheet. Ideal Skills and Experience: - Proficiency in PDF scraping and Excel data entry. - Attention to detail to ensure accurate data transfer. - Understanding of text formatting to ensure the data is organized accordingly in the Excel sheet.

I require a database model diagram based on a description I will provide. The diagram should serve as a basic overview, capturing key tables and relationships within a relational database. Key Requirements: - Relational Database: The diagram should be tailored for a relational database system. - Basic Overview: The scope of the diagram should be limited to key tables and relationships, providing a clear, high-level representation of the database. Skills and Experience: - Proficiency in database design and modeling - Experience with relational databases - Ability to translate abstract descriptions into structured database models Please note that I do not require documentation on the database model diagram. The focus here is on the...

I'm in need of a top-notch data entry freelancer who can accurately input data into Microsoft Excel. Working primarily with text and numeric data, the project simply requires a keen eye for detail, a high level of accuracy, and exceptional Excel skills. It's crucial to note that there will be minimal data cleansing involved - the data should just be entered as it is. This job will suit someone who: * Has proven experience in data entry * Is proficient in using Microsoft Excel * Office365 online documents editing * Can ensure accuracy with minimal supervision * Extreme organised * Perfect English written and spoken.

I need assistance with EXCEL- Working with Multiple Worksheets and Workbooks The task is quite urgent, so I need someone who can start right away and complete the project in a timely manner.

A large rewards program project. I need multiple apps and multiple websites for a points based rewards system across multiple tiers of merchants. Multi -level. Does your IT company have a working rewards program? Do you have access to pre-existing rewards system code and apps? Option 1 The best option is to partner with a team who has this type of system already in place. Option 2 Develop the rewards network Level 1 Tier 1 - Multiple merchants can register and participate in program - Merchants can add products to program - merchants accept rewards points - merchants pay for rewards points - rewards can be used for products, Tier 2 - Rewards program can be "white labelled" and used for another region - A new pr...

I need assistance transferring data between Excel sheets Key requirements: - Data transfer: I'm unsure if this needs to be a manual or automatic process. I'm open to suggestions that will make the process efficient and error-free. - Randomising 'Task Types': This column needs to be randomized each time data is transferred. The 'Task Types' should be selected from a specific range of values. Ideal skills for this job: - Proficiency in Excel )

I need an Excel expert to review and make suggestions for how they would improve a register workbook which I have already created for tracking Quality System Document and Record Control. The register is a template which my quality systems consulting customers use to track procedures, policies, and work instructions, as well as active and archived records. I expect the expert to have a strong understanding of Excel, formulas, functions, and design of excel workbooks so that they look professionally made and are also easy to use (and perhaps also customise if required). The final product should look professional and offer an effortless way to track quality system document controls as well as support the managers and users of the system. Proficiency in Excel and ba...

I need a web-based application that can automate the swapping of tags with data from an Excel sheet. Key Requirements: - The application should be accessible online and be compatible with major browsers. - It should provide an interface where I can upload an Excel sheet with the necessary data. - The application must be able to recognize specific tags in a template and replace them with corresponding data from the Excel sheet. - should work with PDF , Word document - Document / Arrangement Formatting MUST be maintained - Able to export into doc or pdf Experience and Skills Required: - Proficiency in web development, particularly in creating online applications. - Strong experience in working with Excel files and data extraction. - Knowledge of automation techn...

We are currently seeking a highly skilled Senior Web Designer to join our team on a freelance basis, with a potential pathway to full-time employment. Ideal candidates will hav...Key Requirements: Proven experience in designing sophisticated websites at a senior level. Expert knowledge of UX/UI principles, responsive design, and current web technologies. Ability to collaborate closely with our development team to ensure seamless implementation of designs. Strong communication skills and a proven track record of meeting deadlines. This role is suited for individuals who excel in a dynamic, fast-paced setting and are open to transitioning from freelance to a full-time role. We are excited to offer this opportunity to tackle engaging challenges and advance at the cutting edge of web t...

I am seeking an experienced photo editor who can help elevate my personal photos. The tasks required include: - Basic retouching to improve overall image quality. - Background removal to highlight the photo's main subject matter. - Lighting adjustment to amplify the mood of the image. Knowledge of JPEG format is necessary as all images come in this format. ...Knowledge of JPEG format is necessary as all images come in this format. Ideal candidates will have a keen eye for detail and the ability to enhance images in a tasteful manner. A sensitivity to personal photography and an understanding of image composition will also be highly regarded. The aim here is to ensure every image conveys the story beautifully. If this sounds like a project you'd excel in, I would lo...

I'm in need of a professional's help to create static line graphs in Microsoft Excel for scientific data presentations. Ideal Skills and Experience: - Proficiency in using Microsoft Excel to create line graphs - Experience with scientific data visualization - Understanding of best practices in graph creation Additional notes: - The data for the graphs will be provided to you - The graphs are expected to be clear, accurate and visually appealing - Familiarity with scientific terminology is a plus, but not strictly required.

I'm looking to move my MS-Access database to Azure Cloud. It's currently less than 1GB in size. The process will involve a few key aspects: - **Database Migration**: The primary task is to lift-and-shift the existing database to the Azure platform without any data loss or corruption. - **Data Backup and Recovery**: One of the main security requirements is to ensure that data is backed up regularly and that a robust recovery plan is in place. It's worth noting that there aren't any specific Azure services that need to be integrated, nor any special security measures beyond the data backup and recovery. The ideal candidate for this job should have experience in Azure cloud services and database migration. They should also have a good unders...

I'm looking for a MATLAB programmer with expertise in developing advanced algorithms. The ideal candidate should be able to develop a program based on the water cycle algorithm for optimizing a given function.

Seeking a skilled and experienced Data Analyst to sift through unspecified data sources. As the data type, desired insights, and current storage system have not been specified, I am looking for someone highly flexible and adept at handling all types of data, formats, and analysis needs. Ideal Skills and Experience: * Proficiency with Excel, database, BigQuery, JSON, and CSV file formats * Experience working with sales data, financial data, and customer data * Ability to identify sales trends, perform customer segmentation, and analyze profitability Please note that the specifics will be provided upon project commencement. We look forward to hearing from data analysts who can adapt to different data types and uncover valuable insights.

I'm working with an existing Excel spreadsheet that contains date data. I need help with sorting and filtering these dates. PROBLEM: I have different data set (mm/dd/yyyy and dd/mm/yyyy) in the same column exchanging every 100rows or so...data set is about 70000rows I dont want a solution I want you to teach me how to resolve this because this is something ill do for some time now and i need to know how i can do it by myself. Key Requirements: - Sorting and filtering the dates in the spreadsheet effectively. - Ensuring the sorted and filtered data can be used for additional calculations within the same spreadsheet. Ideal Skills and Experience: - Advanced proficiency in Excel, with a strong understanding of date functions. - Previous experience working with large data...

I'm seeking a skilled freelancer to assist me with basic data analysis in Excel. Ideal Skills and Experience: - Proficiency in Excel - Experience with basic formulas and functions - Strong attention to detail - Good communication skills

I'm seeking a talented designer who can make a 3D rendering for my rental units. Your tasks will be: - Create a visualization rendering of individual units. The central focus should be the interiors. - Bring the renderings to life with high attention to det...renderings to life with high attention to detail including lighting, textures, and shadows. Ideal skills: - Strong proficiency in 3D modeling and rendering software. - Demonstrable experience in creating high detailed 3D renderings focused on interiors. - Ability to adhere to a specific design brief and create visually appealing and realistic renderings. This project will be a great fit if you excel in creating lifelike 3D representations and have a keen eye for detail. I look forward to seeing your previous work in ...