How to change column to row in excel 2007งาน
Coding vba ให้คำนวนและรายงานผลลงในแถบ status bar ที่มุมจอ โค้ดทำงานได้กับทุกชีทในไฟล์ รายงานผลคล้ายค่า sum, average ที่โปรแกรมมีมาให้เดิม ทศนิยมสองตำแหน่ง เลือกเซลล์จากชีทไหนก็ได้ (เซลล์1จากชีทa เซลล์2จากชีท(n) 1. รายงานผลหาร เซลล์1/เซลล์2 2. รายงานผลลบ เซลล์1-เซลล์2 3. รายงานผลเปอร์เซ็นต์ เซลล์2/เซลล์1*100
...Content ดังนี้ครับ 1. ให้พนักงานขาย รายงานรุ่นและจำนวนที่ขายกลับมาที่เรา โดยในเว็บจะมีสรุปยอดขายเป็นกราฟหรือชาร์ตต่างๆให้ ที่สามารถ sort เป็น สาขา เป็นเขต หรือทั้งประเทศได้ แบ้วแต่แกนที่เราต้องการ 2. มีระบบ Log in ซึ่งจะยึด user ของพนักงานกับสาขาที่เรากำหนดไว้ หมายความว่าเมื่อพนักงานกดรายงานยอดขายระบบจะ แท็กว่ามาจากสาขาไหน 3. หน้าพื้นฐาน เพื่อแจ้งข่าวสารหรือโปรโมชั่นต่างๆ และสามารถแก้ไขได้ง่าย 4. มีแพลตฟอร์มหลังบ้านที่สามารถแก้ไข เพิ่ม ลบ ข้อมูลได้ ทั้งในเรื่องของข้อมูลพนักงานข้อมูลสาขา โดยกำหนดให้ทำได้เฉพาะ User ที่กำหนดไว้ 5. สามารถ Export ข้อมูล รายงานต่างๆมาเป็น Excel 6. สามารถทำข้อสอบในลักษณะคล้ายๆ Google form 11:20 Avatar ได้ครับ 11:20 Avatar มี host หรือยังครับ 12:05 ยังครับ อยากทราบราคาก่อนนะครับ ว่าเริ่มต้นที่เท่าไหร่ 12:12 Avatar คร่าวๆ ประมาณ 1...
Existing functions still have to work with completely new templates bootstrap. I want to change the old to a new template. The duration is not more than 7 days. At a cheap price.
ทำ 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
ฉันมีไฟล์ .exe แต่ฉันต้องการเปลี่ยนให้มันรองรับกับภาษาของฉัน เพราะว่าตอนนี้มันไม่อ่านฟร้อน ไทยมันแสดงผลเป็นสี่เหลี่ยม i have file .exe but i want change language is my language
I am seeking an expert in data entry, particularly in the tasks of document conversion, data processing, and data verification. This role necessitates the management of confidential and sensitive information, hence, a demonstrated respect and understanding for data privacy is paramount. Key Responsibilities: • Document conversion • Data processing • Data verification Required Skills and Experience: • Proficient with MS Excel • Demonstrated experience in similar roles handling sensitive data • Strong attention to detail • Respect for privacy and confidentiality Note: Familiarity and experience with utilizing formulas and pivot tables within Excel are highly desirable, given the nature of tasks to be per...
I need assistance with copying & pasting data from spreadsheets. The dataset is less than 1,000 entries. Ideal skills and experience for this job: - Experience with data entry, especially from spreadsheets - Attention to detail - Proficiency in Excel - Ability to meet deadlines It's a straightforward task. The goal is to ensure the data is accurately copied and pasted.
I need an experienced Excel programmer to automate repetitive tasks and create custom VBA macros for my project. This assignment requires basic level tasks, so extensive experience in complex macros isn't necessary. Here is what I expect: - Automation of several repetitive tasks to streamline workflow and increase productivity - Creation of custom VBA macros from scratch Ideal Candidate: - Extensive experience with Excel automation and VBA macros - Ability to comprehend and successfully complete basic level assignments - High attention to detail and accuracy Please include your Excel automation and VBA macros experiences in your application. I look forward to working with you on this project.
I'm in need of a PHP specialist with extensive experience in all versions of Zen Cart to customize payment page to include additional payment methods besides paypal. This is for EXISTING ZEN CART WEBSITE USING VERSION and possible update zen cart on EXISTING website. Expertise: high level of programming expertise PHP skills are essential, including how to change php version with patches or HTacces change Cart Experience: Familiarity with Zen Cart is a must. An understanding of its architecture and functionality is crucial to ensure a successful integration and customization. Site is running very old version of zen cart customization Integrated the stripe payment page that has options for now, pay later: Stripe sup...
I need some one to clean a file that has names and addresses The field with the name has business names and first and last name combined. I need them separate. Also some time there are two name or a last name and then the first name of a husband and the first name of the wife I need all that in separate fields See attached sample
I'm seeking a Wix Velo expert to enhance my website with a focus on lead generation. Your primary task will be to integrate efficient contact forms across strategic pages to facilitate visitor engagement and ultimately, lead generation. I need somebody who can work with Velo to create the following: I have a website that I would like to create dynamic pages for all locations in the UK. I need the original template setting up, instructions how to generate the pages automatically. I need to be able to change the recipient of the form data on each of the dynamic pages. Key Points: - Your expertise in Wix Velo is essential as this platform is the foundation for the project. - You'll be taske...
...Champions for Charity. We need an illustrator to make us a new illustration for this year's shirt. Project details are below. 1. Deliverables - 1 editable illustrator file with illustration for front of shirt 2. Last year's shirt is attached for reference. 3. The illustration should be of our mascot kicking a football (American football) over the stadium through the field goal posts (see attached sketch) 4. The stadium is already drawn, pull this from last year's file (attached ). Just need to change the year inside to 2024. 5. The illustration of the mascot kicking the football should match our previous styles, I will send a zip file with reference images from past t-shirts. We want the illustration to have some motion with the mascot ...
Hello work will be done as 1 - FTP Testing status in popup 2- Show failed testing domain in the new table on same page 3- Change the PIN CODE from backend 4- Able to upload files on the root directory 'Public_html'
...seeking an experienced Excel wizard capable of making my inventory report more dynamic and adaptable. Here's what I need: - Total Calculations: The report doesn't currently update the total inventory count and monetary value when I adjust the count of individual items. I require this to be automated so the totals are accurately recalculated whenever an inventory count changes. - Regular Updates: Going forward, I will be regularly updating inventory counts on a weekly basis. I would appreciate if the system is simplistic and user-friendly for regular updates. Ideal Freelancer Skills: - Advanced knowledge of Excel functionalities - Experience on inventory management systems - Meticulous attention to detail - Ability to create user-friendly ...
I'm looking for a skilled engineer who can design a self-supported steel chimney for a metal manufacturing plant. This chimney will be integral to industrial emissions control. Tasks Include: - Tailoring the design to accommodate the specific needs of a metal-manufacturing environment. - Incorporating robust safety features and compliances for high-temperature metal emissions. Ideal skills: - Structural Engineering - Industrial Design - Knowledge of industrial emissions standards - Experience with metal manufacturing processes.
I'm in need of a skilled developer who can create an AI portal that is capable of efficiently extracting table data from PDF documents. The extracted data should be organized and saved into a customized Excel template. Additionally, the system should be designed to assign different user IDs with varying levels of access control. Key Requirements: - Develop an AI portal with the capability to extract table data from PDFs. - Organize and save the extracted data in Excel using customized templates based on the source PDF. - Implement a user management system that assigns different access controls to various user IDs. Ideal Skills and Experience: - Proficient in AI development and data extraction techniques. - Expertise in ...
I'm in need of a skilled photo editor who can change the background of a photo from orange to white. It's important to ensure that the editing doesn't alter the natural skin tone of the subject too much. Key requirements: - Change background from orange to solid white - Preserve the natural skin tone of the subject Ideal skills and experience: - Photo editing software proficiency - Experience with skin tone adjustment - Attention to detail and precision in editing - A good eye for color and tone Here is a link to the photo:
I have an html form php ...html form php file on my server. I would like a passcode (no username) added to the form that captures the user connected to the passcode when the form is submitted. I would like the data sent to Google Sheets when a user submits the form. The Google sheet is complex. I would like the form data sent to 1 of 13 sheets. It should search for the sheet name, date, and user (from the html form) to find the correct sheet and row to insert the data from 5 fields. Can you help with this? We have an form in the laravel, these are three main tasks : 1) Secure the form with 6 code passcode. 2) Update the URL of the form. 3) Save the form data in google sheet. There are various tabs in the sheet, so we ...
Hello, I will need a basic php app, for a simple petrol stations management. with 2 roles and a rest api that will support the following...support the following calls: 1. GET: Get service station data and prices of selected fuel. GET: Number of service stations (integer), maximum, minimum and average price per litre (with 3 decimal places). 3. GET: Get a price list of a service station. 4. POST: User login (the database already has users). 5. 6. GET: Receive orders of a service station from the service station owner 7. PUT: Price change to fuel from petrol station owner 8. PUT: Execution of an order by the retailer 9. DELETE: Deletion of an order by a petrol station owner or by a simple user (if it has not been executed). Analytical details docx on chat. Budget: $80 U...
...processing to create a single image that combines a user's face image with clothing overlay. The specific requirements for this project are as follows: AI Technology: - The freelancer should have expertise in image processing techniques to achieve the desired result. API Preferences: - There are no specific API preferences, and the freelancer can use their discretion in selecting the most suitable API for the task. Final Output: - The final output should be a single image that contains the user's face image with clothing overlay. - The clothing overlay should include a t-shirt from a second image and pants from a third image. Ideal Skills and Experience: - Proficiency in image processing algorithms and techniques. - Familiarity with AI te...
SEO Audit tool need to make using google lighthouse Hello, 1, We want to make an SEO audit tool, by the help of integrating the google lighthouse to generate an SEO Audit report. Here is a link to how you can do it. Here is an example how these people have integrated and using google lighthouse to generate reports. We need exactly the same. 2, need an admin panel where admin can add or import the list of the website url,and website owner name , number and email address. So report can generated by the system and keep sending the email pdf report to the owner of the website like its work in front side for this site
I am in need of detailed administrative work. It involves segmenting primary school level maths questions based on the specific skills required to answer them correctly. The task will be to review 50 past papers - containing approx 50 questions each. For each question, I need someone to: - cut & paste an image of the question into a Google slides / Powerpoint document - 1 question (or sub-question if it requires a different skill per page - 1 document for each paper - name the skill(s) that are required to answer each question - as the title for each page - create a new line in a Google Sheets / Excel document with the following information: - skill required (copied from title of Google Slides document) - page number of Go...
I'm looking for a Python developer to assist me in creating a web scraper that can extract specific text content from a website on a weekly basis. The scraped data should be efficiently saved to a CSV or Excel file for easy review. Capable of being plugged to a distribution app. Key Requirements: - Develop a Python-based web scraper that targets a website to extract text data - The scraper should be designed to run on a weekly schedule - Ensure that the code is concise and easy to understand for potential future modifications - Store the scraped data in a CSV or Excel file format Skills and Experience: - Proficiency in Python programming - Experience with web scraping libraries such as BeautifulSoup or Scr...
...looking for a proficient Excel professional to develop a multi-country income tax calculator. This tool will primarily serve individual taxpayers, and potentially other user groups. Key Requirements: The calculator should support income tax calculations for multiple countries. This requires a deep understanding of tax laws and calculations in each country. - The tool should be user-friendly and intuitive, catering to users with different levels of tax knowledge. - It should be well-structured, with separate sections for each country to avoid any confusion for the end-users. Ideal Skills and Experience: - Advanced Excel proficiency, with experience in creating complex calculators or financial models in Excel. - In...
I need an expert to develop a macro tailored to automating report production tasks in Microsoft Excel. The main purpose of this project is to streamline the process of regular report production and increase overall efficiency. Ideal skills and experience include: - Proficient in Microsoft Excel - Experience in macro development to automate tasks - Knowledge in automating report production Your role will involve designing and implementing a suitable macro for regular report production in Excel. I'm looking for someone who can provide a timely and efficient solution.
...editor to accurately insert a person from a given photo into a distinct group photo. I require precise merging skills to blend the person naturally into the intended image. Specifics Include: - I do possess both the images that need to be worked upon. - The critical change is to incorporate an individual from one picture into a group photo in an unnoticeable and flawless technique. - I want the person from the first image to be precisely positioned next to a specific individual in the group photograph. The ideal freelancer for this project must have extensive experience in photoshop or equivalent photo editing software, a keen eye for detail, and a strong understanding of lighting and shading to match the ad...
I'm seeking a skilled virtual assistant with proven communication abilities, to work specifically in US timezone. Your main duties will include: - Bidding on projects: You will need to represent our brand professionally and persuasively when bidding on projects. - Communicating with leads: You'll be responsible for using various messaging platforms to engage with potential clients and leads. Ideal candidates should excel in written communication and have a knack for sales. Proficiency in project management tools is a plus. Our preferred mode of communication with leads is through messaging platforms.
Looking for a Python & Active Directory Expert to create a script and test data to capture all meta data linked to and which describes the confined parameters of an AD account, group policy etc. and export to a MS Excel File. More information attached.
I have a black-colored, cotton garment that I want to change to white. I'm looking for an experienced professional who can accomplish this without damaging the item's quality and texture. The ideal freelancer will have prior experience with fabric dyeing, color theory, and material handling. Knowledge of best practices for color transition for cotton materials is a must.
Need 2 hours tutoring. I have a wix website and I want to understand how to add and remove blogs on the wix website. please let me know the price for 2 hours tutoring.
...have 2 products with around total 9 images, all of which are currently yellow, and I need them to be transformed into Red, Blue, and many more variants. This project is straightforward for someone who is proficient in using the Hue/Saturation filter in Adobe Photoshop. Scope of Work: - Your task is to change the color of these products to given color, ensuring that the new colors look natural and appealing. - I will provide one reference image with the exact colors I desire. You will use this reference to match the colors accurately in the other images. The main objective is to update the color scheme of our products. The new color scheme will be essential in our rebranding process, helping us to align our pr...
I need help with my Microsoft Excel project! Specifically, I require assistance with the following: - **Formulas and Functions:** - Basic arithmetic operations. I don't need anything too complex, just fundamental formula structures. - **Automation:** - No macros for repetitive tasks are required, but I need guidance on setting up conditional formatting rules within the document. I'm looking for a Freelancer who is experienced in Excel and is comfortable with basic arithmetic operations and conditional formatting. You should be able to provide clear, concise, and easy-to-follow guidance. A strong attention to detail and excellent communication skills are a must. If you're proficient in these areas, I'd love ...
I'm in need of an experienced VBA developer who can create custom macros for me, specifically to assist in automating tasks within Microsoft Excel. I'd like to streamline processes and increase efficiency within the software. Key requirements: - Proficient in VBA: You should be well-versed in VBA programming and have a proven track record of creating efficient and effective macros. - Microsoft Excel expertise: Experience in working extensively with Excel is a must. - Automation focus: The macros need to automate a variety of tasks, including data entry, report generation, and potentially formatting. While the complexity of the data manipulation needed isn't explicitly detailed, please be prepared ...
I'm seeking a skilled developer to integrate a pixel into my WordPress website that collects the names, emails, and phone numbers of leads in real-time as soon as they visit a specific page. The collected data should be simultaneously sent to GoHighLevel (GHL) CRM for automated text and phone call follow-ups, as well as to an Excel sheet for manual review and further action. Key requirements: - Pixel Integration: Develop and implement a pixel solution that captures lead data. - Real-Time Collection: Ensure the system collects data instantly when a lead lands on the specified page. - GoHighLevel (GHL) Integration: Connect the system to GHL for automated text and phone call follow-ups. - Excel Integration: Enable the system to sen...
