Vba excel lock position data moveงาน
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 วันให้ทั้งแถวเปลี่ยนเป็นสีแดง
...สามารถ Export ข้อมูล รายงานต่างๆมาเป็น Excel 6. สามารถทำข้อสอบในลักษณะคล้ายๆ Google form 11:20 Avatar ได้ครับ 11:20 Avatar มี host หรือยังครับ 12:05 ยังครับ อยากทราบราคาก่อนนะครับ ว่าเริ่มต้นที่เท่าไหร่ 12:12 Avatar คร่าวๆ ประมาณ 15,000 ครับ รวมระบบหลังบ้าน ไม่รวม host กับ domain ครับผม 12:13 Avatar ทั้งนี้ต้องดูรายละเอียด ข้อ 1, 3 และ 6 อีกครั้งครับผม วันนี้ 15:24 ฉันสนใจจ้าง 15:25 โทษทีครับ ที่คุยไว้หลายเดือนก่อน โดนเบรคโปรเจคไป นี่จะกลับมาทำ 15:25 พอจะลดได้มั้ยครับ 15:32 อยากจะทำเว็บไซต์รวบรวมยอดขาย พนักงานให้มี Content ดังนี้ครับ 1. ให้พนักงานขาย รายงานรุ่นและจำนวนที่ขายกลับมาที่เรา โดยในเว็บจะมีสรุปยอดขายเป็นกราฟหรือชาร์ตต่างๆให้ ที่สามารถ sort เป็น สาขา เป็นเขต หรือทั้งประเทศได้ แล้วแต่แกนที่เราต้องการ export รายงานออกมาเป็น excel ได้ 2. มีระบบ Log in...
Develop Real-time Tracking Flight and show position and status on map == Frontend == - Fullmap display - Can add custom layer from backend to map - Can define color of status from backend == Backend == - Authenticate - Config map - Config Api for tracking plane - Display Data from api (Keep data to database)
ทำ excel คำนวนภาษีส่วนบุคคล 5 คน โดยสามารถเปลี่ยน variable ต่างต่างได้เพื่อทำ scenario analysis (ie ถ้ารายได้ x จะได้ x) ______________________________________________ Excel personal tax calculations for 5 people, with different variables changing for scenario analysis. (ie if income x is obtained x)
คัดลอกข้อมูลจากเว็บไซต์ คัดลอกข้อมูลจากเว็ปไซต์ลงในไฟล์excel
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
...throughout the writing process. If you’re passionate about storytelling, have a knack for explaining complex concepts, and are committed to upholding the highest standards of integrity, we want to hear from you. Please submit your resume, writing samples, and a brief statement outlining your experience with medical and legal affairs, along with your understanding of defamation issues. Note: This position involves sensitive subject matter and requires a high level of professionalism and discretion....
Make an Android app which can be installed on customer phone(new/old) and if customer defaults EMI payments, I can lock customers' phone remotely.
I need an Excel tool that can sort data by category and provide users with an interactive experience. I'm looking for an experienced Excel developer who can create a user-friendly, yet advanced, Excel tool. The tool should have the following features: - **Filtering**: The tool should allow users to filter data by category. This is a crucial aspect of the tool's functionality, as the data will be organized by this field. - **Interactive Buttons**: I would like the tool to have buttons that allow users to sort data. When a button is clicked, the data should rearrange itself based on the selected category. For example, when a user clicks on the button related to 'Category A', all data entries related to ...
I'm in urgent need of a Tableau expert who can assist me with my data visualization and dashboard/reporting needs. Your responsibilities will include: - Crafting effective and visually appealing data visualizations - Developing interactive and insightful dashboards and reports I will provide you with the specific data and objectives for these visualizations and dashboards. The ideal candidate for this position should be proficient in Tableau and have a strong background in data analysis and visualization. Experience in working with sales data would be a plus, although not mandatory. This is an urgent project, so I need someone who can start immediately and complete the work quickly.
From 2.5 lakh records, need to find the duplicate data and make different sheets with unique data. Example: In a sheet of alphabets, that have multiple A’s, B’s, C’s. Now I need separate them and make a sheet with all A’s, separate sheet with all B’s, another sheet with all C’s.
...make sure you are serious, keep having people start the job, do a few things and then all of a sudden just stop working for no reason. Must have good communication and have experience with complex fixes, when a task is assigned it needs to be resolved and whatever else is found quickly. Bugs mean the site is down or not working and dont have time for excuses or inexperience. This is a long term position as once you get use to the sites (about 12) the issues tend to be the same. DO NOT apply just to work temporarily because you need money today, please. I dont want to invest time for someone who will just fix a few tasks and then disappear. No place holders, please! I need someone who is serious and can do the work, if you are not an expert dont waste my time please! MAX BUDGET...
I'm looking for a professional who can help with Excel work, primarily focusing on formula creation and formatting tables. Key Requirements: - I need assistance in creating formulas that can automate calculations and processes in Excel. - I'm looking for a clean and simple format for my tables, in line with a minimalist style. Ideal Freelancer: - Proficient in Excel, with a deep understanding of formula creation. - Experienced in table formatting and design, with a flair for minimalism. - Able to deliver high-quality, error-free work in a timely manner.
...test result. 3. Are you able to work in USA Time? (-8 PST) working 8am-4pm or 8am-5pm? 4. What is your Sales Experience and Website Design knowledge? 5. Are you able to make 100-200 calls per day? 6. Do you have a quality mic and quiet working environment? Please submit your resume and a cover letter explaining why you're the perfect fit for this role. Note: This is a commission-only sales position. We provide the tools and training you need to succeed, but your income is directly tied to your sales performance. We look forward to hearing from you!...
...blog content focusing on relevant keywords and SEO best practices. • About Us Section: Revamp the About Us section to be concise, interactive, and visually appealing. • Live Chat Support: Integrate a live chat feature for real-time assistance and guidance to potential clients. • Enhanced Testimonial Page: Improve the testimonial page for credibility and social proof. • Scroll Bar Placement: Move the scroll bar to the top of the website for an immersive viewing experience. • Website Speed Optimization: Enhance website speed with a sleek loader for faster loading times. • Footer Design Update: Revise the footer design for improved aesthetics and functionality. • Technical Optimization: Implement cache management, Google Analytics, meta...
We are seeking a skilled Frontend Developer to integrate a staking smart contract with a React frontend page for interaction. The project involves combining a pre-existing staking smart contract, staking React page, and token contract to create a seamless user experience. The necessary components including the staking contract, staking react page and ...been prepared. Initially, we will conduct trials on the Sepolia testnet or other testnet to ensure all systems are operational before launching on the Ethereum mainnet. I have already source code for UI. If you're a skilled Frontend Developer with a passion for blockchain and smart contracts, please submit your resume and a brief cover letter explaining your experience and qualifications for the position. We look forward to he...
...detailed financial reports and dashboards, primarily based on data from Excel spreadsheets. Key Responsibilities: - Develop compelling, visually appealing reports and dashboards that are easy to interpret and navigate. - Tailor the reports and dashboards specifically to financial analysis, ensuring they provide the insights necessary for informed decision-making. Ideal Candidate: - Proven experience creating financial analysis reports and dashboards in Power BI. - Proficiency in integrating data from Excel spreadsheets. - Strong attention to detail and the ability to translate complex financial information into clear, concise visual elements. This project requires a high level of expertise in Power BI, financial analysis, and data visualization. ...
I'm in need of an experienced developer to modify my PHP/Bootstrap5 image watermark form. The current setup has the form working in the background with a preset design. I now want it to be a more integral part of the watermark process. Key tasks: - **Form Integration**: The form should be fully functional, where users can upload images, add text for watermarking, choose a watermark position, and even select an existing image for watermarking. - **Code Adjustment**: The existing watermarking code needs to be integrated and work seamlessly with the form submission. This involves adjusting the code to make it work in conjunction with user input from the form. - **User Experience**: The form should be user-friendly, intuitive, and visually appealing, ensuring a smooth and engaging...
As a small business owner with less than 10 employees, I need an Assistant and HR Manager who can handle a variety of tasks. Key Responsibilities: - Scheduling and Calendar Management: Ensure smooth and efficient scheduling by organizing appointments, meetings, and work plans. - Employee...and sourcing potential new team members. Ideal candidate should have: - Strong organizational skills and attention to detail. - Previous experience in HR roles or recruiting. - Excellent communication and interpersonal skills. - Knowledge of HR software or tools is a plus. - Ability to handle confidential information with integrity. This is a part-time role that may evolve into a full-time position as the business grows. You will work closely with me to ensure the team runs efficiently and ef...
I'm seeking a talented Photoshop artist to skillfully edit a image of me into a photo of my friends' party. Here are the specifics: - Background: The photo taken at my friends' party. - Position: I would like to be added in a relaxed, casual way next to my friends. - Mood: Convey an overall feel of joy and energy. Potential freelancers should have proficient Photoshop skills, excellent understanding of lighting, depth, and angles to make the edit look as real as possible, along with a high degree of creativity. Previous experience with similar photoshop projects preferred.
I need a skilled photoshopper with a knack for creating natural looking images. The goal of this project is to include someone who wasn't in the original photo. Your role would be to seamlessly add this person. Points to consider: - The person's position doesn't matter. They can be placed anywhere as long as the composition still looks balanced. - It's crucial that the final image looks as natural and candid as if everyone, including the added person, was there when it was taken. Skills and Experience: - Advanced Photoshop skills - Extensive experience in photo-editing and manipulation - Ability to maintain the original photo's tone and mood - Strong attention to detail to ensure alignment with the original photo's elements.
I need a skilled professional to help me with a few tasks: 1. **WordPress Template Installation**: I have the template that I'd like to use, and I need someone to install it for me onto Hostinger. 2. **Email Backup**: My email account is around 1GB-5GB in size. I need it completely backed up. I don't want to lose any of my emails as Hostinger said when I delete my old site all the emails will move too and they have a guide I can send on transferring it over. 3. **Copy Over Website Content**: I have an existing website, and I need someone to copy over some of the content from there to my new WordPress site. Ideal candidates should: - Have experience with WordPress, email backup. - Be proficient in moving content across websites. - Be able to provide efficient and secu...
We are looking for a talented PHP Laravel Programmer to join our team and work on our B2B ecommerce website and app development. The ideal candidate will have a strong background in PHP and Laravel, with experience in building and maintaining ecommerce platforms. This is a remote position, offering the flexibility to work from anywhere. Key Responsibilities: Develop, test, and maintain high-quality ecommerce solutions using PHP, Laravel, MySQL, HTML, CSS, JavaScript, and related technologies. Collaborate with the design and product teams to implement new features and improvements. Optimize and enhance the performance of the website and app to ensure a seamless user experience. Troubleshoot and resolve issues as they arise, ensuring the stability and reliability of the platform. Wr...
I'm in search of a versatile freelancer with skills in Word, Excel, programming, and graphic design. Your expertise in these areas will help me in different domains. Your main tasks will include: - Formatting documents in Word, ensuring a professional and consistent layout. - Creating Excel spreadsheets and conducting data analysis. Proficiency in Excel will be crucial to help me interpret and visualize data effectively. - Developing software or web applications. I am working with Java/Spring/JavaFX and am open to creative development ideas and solutions. - Designing logos and visuals. Your ability to create engaging and unique visuals will be a big asset to my projects. I am currently using Word 2010 and will be working with Java/Spring/JavaFX fo...
I have a list of 50000 urls, I would like to scape the pages to see if they contain references to scripts - I will provide a list of the urls and the scripts. Deliverable should be an excel with the 50000 urls and whether they contain the link for each script. Looking for fast turnaround
...proposals from experienced web scraping and data analysis firms to conduct a comprehensive data collection and analysis project. The purpose of this project is to gather detailed information on menu items, pricing, customer ratings, promotions, and deals from various food delivery mobile apps operating within our city. The goal is to mine this data for actionable insights to inform our advertising, promotional strategies, and competitive benchmarking. 2. Project Scope The selected vendor will be responsible for developing and implementing a solution to: • Subscribe to and navigate through multiple food delivery mobile apps. • Collect data on menu items including descriptions, pricing, customer ratings, and associated promotions or deals. • ...
Title: Automated Data Retrieval from Websites Using CRM and CID Numbers Description: We are looking for an experienced developer to automate the process of retrieving data from specific websites using CRM and CID numbers. The goal is to develop a script or tool that will: Look up Doctor's Specialization: Use CRM numbers to search on the website: CFM Doctors Search Extract doctor's information including their specialization. Look up Disease Descriptions: Use CID numbers to search on the website: MedicinaNet CID10 Search Extract the disease description. Deliverables: ( ) A script or tool that can take a list of CRM and CID numbers as input. Automate the search process on the specified websites. Extract
...Architecture and Finance. Everyone else is yes needed. Key Requirement: You will need to find the contact name, position, email and LinkedIn account for each and every recruitment/HR/Headhunting person within each company. This could be anywhere between 10 to 30 people per company. - The information should be accurate and up to date. - If you have a strategy for obtaining this data, please share it in your bid. Skills/Experience: - Strong research skills - Data entry and data mining expertise - Proficient in Saudi Arabian business landscape - Attention to detail and accuracy - Web scraping - Web search - Leads Results should be in an excel sheet format, outlining the name, position, email address for each contact. Contacts for each company s...
...knowledge of Android Studio and Google Firebase to design a dynamic app for me. The exact purpose of the app is yet to be determined, but rest assured, your responsibility will include implementing user login and data fetching features. Ideal Skills: - Expertise in Android Studio and Google Firebase. - Strong understanding of user authentication and data retrieval techniques. Running on a flexible timeline, I am keen to get started on the development as soon as feasible. However, missing data regarding the type of data to be fetched and the purpose of the app will be clarified as we move forward....
I'm a dual citizen in need of an accountant specializing in individual tax filing for both US and Canada. I am a dual citizen of Canada and the USA, having obtained my US citizenship in 2020. Due to a recent move to Arizona and plans to sponsor my wife for her green card, I have discovered the need to file my Canadian taxes with the USA. I require an experienced and licensed accountant who specializes in both US and Canadian tax laws, particularly for dual citizens, to get my taxes in order promptly. Responsibilities: File Canadian tax returns for the years since obtaining US citizenship in 2020. Ensure compliance with both Canadian and US tax laws and regulations. Provide accurate and timely filing of all necessary documents. Assist with any additional tax-related queries o...
I have a mobile app that i need to upgrade and make some changes to. Maybe move it to a cross platform if the price is right.
...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 – 300 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 knowledge of VBAs, Macro, MS Offic...
Hello, I need convert a PDF invoice to Excel to import to our invoices software
I'm looking for an experienced Power BI developer to create bespoke reports and dashboards, which will be integrated into Microsoft Teams. Tasks: - Handling data from Excel spreadsheets and converting it into insightful reports and dashboards. Skills and Experience: - Strong command of Power BI for report and dashboard creation. - Proven experience with Excel spreadsheets. - Good knowledge of integrating Power BI into Microsoft Teams. The goal is to make complex data easy to understand, facilitating better decision-making within our team. Your work will directly impact our day-to-day operations and strategies.
I'm looking for an experienced design engineer to f...design is needed to be implemented. To complete this project, you'll need: - Proficient knowledge in mechanical design - Expertise in working on metallic surfaces intended for functionality - Ability to make an esthetically appealing yet robust design You should be able to take my basic conceptual design, refine the aesthetics and add the necessary technical details for manufacturing, including lock and secure opening mechanism. Your deliverables will be a complete design package, suitable for presenting to potential manufacturers. Project is almost finished, just a few details to finalize are needed. Successful completion of this project might lead to more collaboration opportunities as I have more designs that need...
