Database manipulation vba macroงาน

Coding vba ให้คำนวนและรายงานผลลงในแถบ status bar ที่มุมจอ โค้ดทำงานได้กับทุกชีทในไฟล์ รายงานผลคล้ายค่า sum, average ที่โปรแกรมมีมาให้เดิม ทศนิยมสองตำแหน่ง เลือกเซลล์จากชีทไหนก็ได้ (เซลล์1จากชีทa เซลล์2จากชีท(n) 1. รายงานผลหาร เซลล์1/เซลล์2 2. รายงานผลลบ เซลล์1-เซลล์2 3. รายงานผลเปอร์เซ็นต์ เซลล์2/เซลล์1*100

1. ใส่ VBA ให้รายการที่ Tickแล้ว ย้ายจากtabแรกย้ายไปเก็บใน tab2 (done list) และให้วันที่ในtab2 เป็นวันที่ที่ย้าย 2. ใน tab ถ้าวันที่ในรายการ ไหน <3 วันให้ทั้งแถวเปลี่ยนเป็นสีแดง

หลังจากลูกค้าโทรเข้ามาเมื่อคุยเสร็จแล้วลูกค้ากดวางสาย หรือ พนักงานกดวางสาย อยากให้หลังจากนั้นประมาณ 20 นาทีให้โทรศัพท์กลับไปหาลูกค้าเพื่อประเมิณความพึงพอใจ โดยใช้ macro-survey เป็นเมนูที่จะโทรออกอัตโนมัติ

ต้องการสร้างแอพ Xamarin (Cross Platform) เชื่อมต่อฐานข้อมูล Mssql ดึงข้อมูลจาก แสดงข้อมูลจากฐานข้อมูลพร้อมรูบ และ ทำระบบ Login

Windows อื่นๆ หรือไม่แน่ใจ Macro excel

Application ที่องค์กรใช้ มี ระบบ Database ใช้ MS SQL

ต้องการซื้อ database ท่องเที่ยวในประเทศไทย

ต้องการข้อมูลที่ติดต่อได้จริง ของร้านสปา และร้านขายส่งผลิตภัณฑ์เกี่ยวกับสปา ทั่วประเทศไทย (มากที่สุด) ข้อมูลที่ต้องการ -ชื่อร้าน -เจ้าของ/ผู้ดำเนินการ -หมายเลขโทรศัพท์ -หมายเลขแฟกซ์ -หมายเลขโทรศัพท์มือถือ (ถ้ามี) -อีเมล์ -ที่อยู่จัดส่งเอกสาร ***เป็นข้อมูลที่ update ใช้ได้จริงเท่านั้น

I'm in need of an expert to assist with the cleanup of our Medicine database. The goal of this project is to accurately remove all duplicate entries improving the overall accuracy of the data. Ideal Skills & Experience: - Strong background in Database / Excel /CSV management, specifically in the medical field. - Proven track record of similar past work. In your application, please include details of similar projects you've worked on. Efficiency and precision are pivotal for this task. Looking forward to a neat and streamlined database!

...Implementation of robust security measures to protect sensitive user data, including payment and commissioning information. Ensuring that the referral and commissioning system is secure and protected against fraud or manipulation. 5. Tecnologias Utilizadas: Frontend: Use of technologies such as HTML5, CSS3, JavaScript, along with frameworks like React.js or Vue.js to develop responsive and dynamic interfaces. Backend: Use of languages ​​such as PHP or Node.js, with frameworks like Laravel or to develop business logic and data management. Database: Use of relational database management systems like MySQL or PostgreSQL to store and manage system data. 6. Testes e Qualidade do Código: Development of automated tests to ensure the correct functionality of the s...

...primary goal of this project is to generate high-quality images of humans wearing handbags. - The system should accept both images of handbags and models as input. - I'll need the model to adjust the handbag size on the model and simulate different lighting conditions. Skills and Experience: - Strong background in machine learning and computer vision, particularly in image generation and manipulation. - Experience with virtual try-on systems or similar projects will be highly advantageous. - Proficiency in handling image processing and customization would be a plus. It's important that the outcomes of this project are user-friendly, accurate, and of high quality. A successful completion would involve the ability to generate realistic images of handbag mode...

Hi Sir, I can create the macro as per instruction shared . Thanks Arun

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 a database for the UK market, with a focus on company names and Email ID. Key Points: - The project primarily involves creating a comprehensive database for the UK market - The main data points to be included are company names and Email ID's - Information can be extracted from Yellow Pages, Business Pages, Associations, Business Chambers and similar. - Accuracy of data, specially Emails - Sample File of Required database is attached - To start with we require 10,000 records. - Will pay INR 0.60 per record. Ideal Freelancer: - Prior experience in creating detailed databases - Proficiency in data gathering, scraping and organization - Familiarity with the UK market would be a plus Please include your relevant experience in your application.

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 need assistance with PowerFX list expressions, specifically on formulas and data manipulation for PowerApps. Here are the specific requirements: - Assistance with PowerFX list expressions, focusing on formulas and data manipulation - Help building efficient and effective list expressions in PowerFX for PowerApps Ideal freelancer for this project should have: - Proficiency in PowerFX, specifically in the context of PowerApps - Experience in working with list expressions, formulas and data manipulation - Ability to communicate technical concepts effectively

I'm looking for a Python script that uses PyAutoGUI to control keyboard inputs, with a specific focus on interacting with a Firefox web page. I am open to creative ideas on how to do this differently then I have described below. Key Requirements: This is basically like a macro, or autohotkey, (if you do a gui then I can determine the winner as soon as whoever finishes first with working code, wins. The gui for the python code is up to you but maybe it could work well if I can have section one establish focus on right scrolling panel and ignore the left panel. Second section: because this is sendkeys basically we will use the keyboard to navigate. A text box stating how many tabs until we get to the first web object button to select, Then a second text box to state how man...

I need a skilled professional to assist with a data entry task. The project involves the following: - The task is primarily image data entry. - The images will be provided in digital photo format. - The entered data should be compiled into a database. Ideal candidates should have experience with data entry, particularly with image data. Proficiency in database management is also essential. A keen eye for detail to ensure accurate data entry is a plus.

...such as the number of recipients, percentage of capitals, and URL presence. Analyze this data to explore variable relationships and determine SPAM/HAM status. Generate visual representations of the data and analysis findings. Provide a detailed report on the methodologies used, results obtained, and insights gained. Required Skills: R Programming: Must be highly proficient in R for complex data manipulation and analysis tasks. Data Extraction: Experienced in skillfully extracting and processing data from large datasets. Statistical Analysis: Capable of applying statistical methods to analyze and interpret data. Machine Learning: Should have a foundational understanding of machine learning techniques relevant to classification. Data Visualization: Expertise in creating clear and i...

I am seeking a skilled image editor to help me create a photo that gives the illusion of me having a twin. Need done ASAP Key Details: - Utilize Photoshop or other advanced photo editing tools to merge my face with another person's face. - The second individual's face will be provided by me. - I am open to suggestions for the final setting or background of the photo. Ideal Skills and Ex...Ideal Skills and Experience: - Proficiency in Photoshop or equivalent software, with experience in advanced photo editing techniques. - A creative and imaginative approach to merging two faces convincingly. - Strong communication skills to discuss and propose suitable background settings for the photo. Please share your relevant portfolio to showcase your previous work in image editing and ...

I'm in need of an individual with advanced expertise in Linear Algebra and R programming. Your critical role will encompass: - Solving complex linear equations - Matrix manipulations - Implementing statistical analysis Skills and experience sought: - In-depth knowledge and experience in Linear Algebra and R programming. - Proven ability in solving complex equations and matrix manipulation. - Experience in statistical analysis using R. - Dear skill and background in integrating R programs with other software. The specialist I'm seeking should be able to critically solve problems and integrate solutions with existing software. Ultimately, the aim is to achieve efficient results through advanced linear algebra and R programming.

I'm looking for a proficient professional who can create a report in Microsoft Access from a MySQL database. 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 wit...

I am searching for an experienced app developer who excels in designing and implementing Android-based applications. The main functionality required for this task is the creation of a comprehensive employee database system. Key Functionalities: • Instant tracking of employees' online and offline status • Storing and displaying contact details of each employee • Categorizing employees based on their department The developer should have a strong understanding of database structuring and management for Android systems and a proven track record of delivering similar projects. Familiarity with real-time data sync and user-friendly UI design are also desirable.

I need assistance in compiling a large, extensive database of more than 5,000 working professionals earning a salary under 3 lakhs per annum. The data profile will include: - Name and contact details - Education and qualifications - Current job title and company Interestingly, these professionals should spread across various industry sectors such as Technology and IT, Healthcare and Medicine, as well as Marketing and Advertising. Particular skills and experience that would set freelancers apart for this job include: - Proven experience in data mining and data scraping - Familiarity with the mentioned industry sectors - Ability to accurately cross-reference and verify data - Excellent attention to detail Freelancers with extensive experience in maintaining data integrity and c...

I'm in need of someone with the expertise, resourcefulness and knowledge to draw up an email lead list from public domain databases. The focus of this project is identifying professionals, specifically those with active websites for contact. Key requirements: - Extraction of email leads from public domain databases - Target demographic: Professionals of various walks with active websites - Experience with large-scale data extraction - Proficiency in managing information databases Your past work in email lead generation will be beneficial for the successful completion of this project. Your ability to provide clean, organized, and verified email lists will also be very important. Please only bid if you have the experience and know-how to deliver on the stipulated requirements.

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.

I'm looking for an expert in Adobe Photoshop who can significantly enhance the quality of a set of images. The key tasks will involve: - Manipulation and improvement of image features - Enhancement in image clarity and quality - Tweaking and heightening image details wherever necessary Post-editing, the final images should be delivered in PNG format. The ideal freelancer for the job will be adept at closely working on minute image details, with an eye for visual aesthetics and master-level skills in Adobe Photoshop. Proven experience in a similar project is a must.

2 excel files with VBA macro as per customer requirement

One excel file with macro as per requirement

The objective of this assignment is to develop a comprehensive database system. The Database should support, among others, member registration, subscription tracking, member services management, and trade references. The system should facilitate data import from Excel and accommodate online and offline accessibility based on the user’s capacity to meet online hosting costs. Member Registration: Develop a module for member registration capturing key details such as Name, address, and any other contact information. Village, group, area, district, province, sub-group affiliation (e.g., Study circle, VSLA, commodity association etc.) Demographic information (age, gender, household size, etc.) Implement functionality to adapt and import member data from Excel sheets. Enab...

I need an experienced Laravel developer to integrate and manage the database for my existing project, www.getyourhomes.in. The task is not only basic CRUD operations but also extends to admin panel updates and AJAX call filters. - Database Management: You should be adept at advanced database management with stored procedures, triggers, and optimization. - Language Proficiency: Strong language skills in either Bengali or Hindi is essential. Your role would be crucial in improving the functionalities of my project. Prior experience in similar projects would be a bonus.

Hello to all talented SQL freelancers! We are seeking an advanced SQL specialist with proven experience in handling multi-level marketing (MLM) databases, as well as knowledge of Dolibarr ERP. We need someone who can understand the complex terms associated with MLM compensation plans and create effective SQL queries to extract the necessary data, as well as integrate with Dolibarr ERP systems. Responsibilities: Develop advanced SQL queries to extract data from MLM databases. Understand and apply concepts of MLM compensation plans. Collaborate closely with the team to understand project requirements and goals. Integrate SQL solutions with Dolibarr ERP systems. Optimize query performance and ensure data integrity. Requirements: Demonstrable experience in SQL and PHP. Deep knowledge of re...

I'm in need of a specialist in Linear Algebra and R programming. Your role will entail solving complex linear equations, matrix manipulation, and statistical analysis. Given this is R programming related, a strong technical understanding and experience in this area is non-negotiable. You should primarily possess the following attributes: - Proficient in Linear Algebra and R programming - Solid proficiency in executing statistical analysis in R For an application to be considered, it should contain a comprehensive project proposal detailing how you intend to approach and solve the tasks. Although experience is essential, a gameplan on how you'd approach these tasks in R coding is more significant. Please note, the resulting work will be for a yet to be disclosed R rela...

One excel file with macro as per the customer requirement

I'm in need of a highly skill...highly skilled photo editor who's proficient in advanced editing techniques. The ideal candidate should be able to perform the following tasks: - **Color Adjustments:** The ability to adjust colors in a way that enhances the overall aesthetic of the pictures. - **Object Removal:** The capacity to seamlessly remove subjects from the images without leaving any noticeable traces. - **Retouching and Manipulation:** Advanced retouching skills and the ability to manipulate images in a sophisticated manner. The edited photos will be used for both social media posts and print materials, so attention to detail and quality is of utmost importance. If you have a keen eye for detail, a creative mindset, and a strong background in photo editing, I'...

I have a dataset with textual data in English and I need a professional who can perform a sentiment analysis on it. An ideal candidate would be someone who has: - Extensive experience in data analysis, specifically with textual data - Proficiency in English language for accurate understanding and manipulation of data - Proven experience in sentiment analysis, capable of providing meaningful and actionable results The main output for this project should be a comprehensive sentiment analysis, which might inform decision making or strategy development. The ideal freelancer should prioritize accuracy and detail in their outputs while ensuring timeliness.

I need to gather emails from: https://alaskabar(.org)/for-lawyers/member-directories/ Need it in CSV

I need a seasoned graphic designer with a strong background in creating high-detail SVG files from PNG images. This project requires an expert understanding and application of digital image manipulation. Specifically, these tasks need to be performed: - Convert low-definition PNG logo files into scalable SVG files. - Sharpen the images before the conversion to ensure they retain the high level of detail. - Despite the logo being a single colour, it must remain consistent throughout the graphic. You must have a keen eye for detail, vast experience in using graphic design software, and an in-depth understanding of image file formats, particularly PNG and SVG. Demonstrated experience in similar projects will be an added advantage. Your ability to meet deadlines without compromising...

I'm in need of an ASP.NET developer with a strong background in database integration. The primary purpose of the website will be system development, focusing on certain essential features. Key Responsibilities: - Develop the website using ASP.NET - Integrate databases seamlessly System Development Features: - Implement user authentication and authorization - Ensure efficient data management and storage - Set up robust reporting and analytics functionalities Ideal candidates should have experience in ASP.NET development, particularly in integrating databases and building system development projects. Previous work on user authentication, data management, and reporting within ASP.NET is highly desirable. Please provide examples of your work or specific experience in these area...

I am in need of a skilled photo editor who can effectively blend two images ...hair. Remove the woman in the white dress and the woman in the beige dress. - Blending Style: I want a partial blend where the two images remain distinct in certain areas. It's important that the end result keeps elements from both photos obvious and easily visible. - Layout: The images should be oriented from left to right, side by side. - Lighting: Consistent lighting Proficiency in image manipulation software is a must. Demonstrated experience in photo blending will be highly beneficial. Preference will be given to freelancers who have an eye for composition and can suggest creative arrangements for the most impressive outcomes. Please attach examples of your past photo blending projects in your ...

We're in need of an experienced photo editor to refine pictures from our wildlife safaris - both local and inte...particular style or willingness to learn and adapt to it is crucial. - **Utilization of Edited Photos**: The final edited images will be used mainly for our social media platforms and website. It's important that the images are optimized for these mediums and in line with our company's branding and communication strategies. Ideal candidates should possess: - Proficiency in photo editing and manipulation software. - Experience in photo editing for wildlife or nature images. - Strong understanding of color correction techniques. - A portfolio that showcases previous work in a natural and realistic style. - Ability to ensure the photos are suitable for soci...

I'm in need of a profes...editor that can automatically crop selected areas within a PDF document and save them in the same format. Here are the details: - The selected areas that need to be cropped haven't been specified, suggesting this should be a flexible feature adaptable to varied project needs. - The freelancer should showcase experience in similar projects, demonstrating their knowledge and capability in PDF manipulation or editing using PYPDF2 library. Your role will entail the creation of a bespoke solution to cater to this scope. - The project requires an intermediate level of expertise in managing and manipulating PDF documents. I look forward to seeing your bids and discussing how we can move this project forward. Previous experience in similar projects i...

I'm looking for a skilled trainer to deliver a comprehensive Excel training targeted towards beginners. The training will cater to a larger group of participants, around 15-20 individuals. Key Learning Objectives: - Understanding of Excel formulas and functions - Mastery of data analysis and manipulation The ideal candidate for this project would have a strong command of the above topics, with a proven track record in delivering effective training to large groups. Experience in breaking down complex concepts for beginners is essential. Practical demonstrations and hands-on activities should be incorporated to ensure the understanding and application of the learnt skills. Please, when making a bid, provide a brief outline of how you plan to structure the course. Looking for...

I need a skilled python developer to create a JSON to Excel converter. Key Requirements: - You'll be working with Flat JSON data - How to handle missing data is up to you - Mapping of JSON fields to Excel columns is flexible Ideal Skills: - Proficient in Python - Experience with JSON parsing - Excel manipulation skills I'm open to suggestions on the best way to map the data, so please include your ideas in your bid. Let me know if you have any questions.

I need a skilled professional to assist with a data entry task. The project involves the following: - The task is primarily image data entry. - The images will be provided in digital photo format. - The entered data should be compiled into a database. Ideal candidates should have experience with data entry, particularly with image data. Proficiency in database management is also essential. A keen eye for detail to ensure accurate data entry is a plus.

I have a photo that I'd like to alter. This is purely a personal preference. Ideal Skills: - Strong image editing and manipulation skills - Proficient in Adobe Photoshop or similar software - Experience with photo restoration is a plus The photo is taken indoors. The task involves removing one person from the photo and replacing it with another. I would prefer the final version to be in JPEG format. I want the girl in the orange dress removed and replaced with the bride

...with overlays for composition or guidance. Apply various enhancement features to improve the photos, such as: Brightness and contrast adjustment Color correction Applying filters Cropping and resizing Save the edited photos to the device's storage. Technical Skills: Proven experience in Flutter development Familiarity with camera access and integration in Flutter apps Experience with image manipulation libraries in Flutter Knowledge of implementing custom overlays on the camera preview Bonus Points: Experience with integrating image editing SDKs Experience with cloud storage for saving edited photos (optional) Project Timeline and Budget: Please outline your estimated timeline for completion and your project rates in your proposal. Please Include in Your Proposal: A bri...

I am seeking a freelancer who can efficiently develop an ER (Entity-Relationship) model for a targeted domain, specifically incorporating the relationships and entities of Customers and Orders. Key requirements include: - Proficient expertise in ER modeling - Ability to capture and incorporate Customers and Orders as specific entities and relationships in the model. - Ensure that the 'Customers' entity accurately stores 'Name and Contact Information'. Ideal candidates should have a solid understanding and experience in designing ER models, with a sharp eye for capturing accurate details in such systems. Timely delivery of the project will be a critical factor to consider. Kindly include your relevant skills and experiences in your bid. Looking forward to working with...

I'm looking to improve my existing business's data management by integrating a new API into AG Grid. The primary objective of this integration is to enable the system to retrieve dat...system to retrieve data from external sources, as well as manipulate and process it efficiently in real-time. Key requirements include: - Incorporating the new API with AG Grid - Ensuring the system can retrieve data from external sources - Designing data manipulation and processing functionalities - Enabling real-time updates of processed data Ideal skills and experience for this project includes: - Proficiency with AG Grid and API integration - Strong understanding of data management systems - Experience in designing data manipulation and processing functionalities - Knowledge of ...

I'm looking for a talented professional in Adobe Photoshop to train 2 of us physical way and not online - Photo Retouching: I need someone who can enhance the quality of my photos, make them more appealing and professional. - Graphic Design: A key component of this project will involve crafting graphic elements, such as banners or logos. - Image Manipulation: I might require some photos to be altered or transformed in a way that's creative and original. Please note that this project is flexible, and the tasks may vary depending on the needs at the time. Thus, the ideal candidate will be able to adapt to different design needs and have a solid understanding of design principles. I'm looking forward to seeing your portfolio of past work, and please feel free to inclu...