Vba separate data rows columnsงาน

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 วันให้ทั้งแถวเปลี่ยนเป็นสีแดง

...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-depth knowledge of income tax laws and calculations in various countries. - UX/UI design skills are an added advantage to ensure the calculator is user-friendly. I&#...

I need help with data entry and formatting for a Google Sheet. The data is to be sourced from ONLY 1 Website. Key Tasks: - Copy-pasting text information and images or screenshots from Website 1 into a Google Sheet. - Formatting the data in the Google Sheet with columns and tables. Ideal Skills: - Proficiency in data entry, specifically with Google Sheets. - Strong attention to detail to ensure accuracy and completeness of the data. - Ability to organize data efficiently using columns and tables along with images etc for capturing the User flow in a tree form . Example the website has Question 1 and N number of responses. Based on the responses there are different questions based on the responses. Need to capture that in a tree ...

...form will be used to enter essential information to properties by our data entry operators. This will be one (1) html page only, no backend development necessary (php receiving the form optional, see below). „Nice Admin“-Template must be used: Project Requirements: - Convert Microsoft Word Document (2 pages) to Web Form: Transform the content and layout of the Word document into a web-based form. - Responsive Design: Ensure the form is fully responsive and looks great on all devices (desktop, tablet, and mobile). - Form Fields: Create all necessary form fields as outlined in the Word document, including text fields, dropdowns, checkboxes, addable rows table, etc. - User-Friendly Interface: Design a clean, user-friendly interface

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 to work on tasks ranging from basic calcul...

...agencies to sign up for by showcasing its comprehensive toolset. Video Specifications: Length: Approx. 2 minutes Format: High-definition quality, suitable for both web & social media platforms and mobile viewing. Style: Modern, professional, with a direct focus on walkthroughs and screen captures of the platform in use. The color scheme for the video and logos will be attached as a separate document. Audio: Background music should be uplifting but not overpowering. Music should be royalty-free or licensed. Budget: To be negotiated based on freelancer’s rate and estimated hours. Additional Notes: Be prepared to make revisions based on feedback to ensure the video meets all specified requirements. A thumbnail image for the video....

...form will be used to enter essential information to properties by our data entry operators. This will be one (1) html page only, no backend development necessary (php receiving the form optional, see below). „Nice Admin“-Template must be used: Project Requirements: - Convert Microsoft Word Document (2 pages) to Web Form: Transform the content and layout of the Word document into a web-based form. - Responsive Design: Ensure the form is fully responsive and looks great on all devices (desktop, tablet, and mobile). - Form Fields: Create all necessary form fields as outlined in the Word document, including text fields, dropdowns, checkboxes, addable rows table, etc. - User-Friendly Interface: Design a clean, user-friendly interface

I'm in search of a talented individual who can create a series of GIPHY designs catering to two separate businesses. The ultimate goal is to offer a range of animated logos, product animations, and custom illustrations. Business one- body composition and metabolic testing business. showcase the brand and products etc Business 2- breathwork, mindset Key Points: - You'll be working on GIPHY designs for two distinct businesses - The designs should encompass a mix of animated logos, product animations, and custom illustrations - The animated logos should carry elements of modernity, playfulness, and professionalism Ideal Skills and Experience: - Proficiency in GIPHY design and animation - A strong portfolio showcasing a diverse range of design styles - An understandin...

I'm in need of a Power Automate expert who can create a workflow system for me. This project involves getting tasks from rows in Excel and mapping them to individual tasks on a Planner board. Ideally, each row in Excel would correspond to a separate task on the Planner board. Skills & Experience: - Mastery in Power Automate - Solid experience with workflow creation - Strong knowledge in data management - Familiarity with Excel and Planner integration - Ability to deliver tasks promptly and accurately Your job is to ensure a seamless process of data management, with all tasks neatly organized and displayed on the Planner board. With your help, task automation will come to life, enhancing my productivity level.

I need a professional to convert the information in the attached document into an organized, well-formatted Excel sheet. The project will require you to: - Copy all the text content of the document into corresponding cells in the Excel sheet. - Transcribe all tables and cha...need a professional to convert the information in the attached document into an organized, well-formatted Excel sheet. The project will require you to: - Copy all the text content of the document into corresponding cells in the Excel sheet. - Transcribe all tables and charts in the document accurately into the Excel. - Maintain the original formatting of the data in the document. The Excel document should: - Include all columns and rows from the original document. - Not require any additiona...

I'm in immediate need of a skilled data entry operator located in Pune, India, to rectify a Microsoft Office Word document. This task is essential as it requires meticulous attention to detail. Key Tasks: - Rectify the formatting errors and spelling/grammar mistakes in the document. - Make necessary table and layout adjustments for improved readability. - Remove the 'Year' field from one of the rows in the table. This project demands: - Proficiency in Microsoft Office Word. - Exceptional eye for detail to correct formatting, spelling, grammar, and table-related issues. - Ability to follow instructions meticulously. - Excellent communication skills for any clarification or feedback. Please only apply if you're located in Pune, India, and have the necessa...

I have an edited Excel spreadsheet that needs some final touches. I have a macro that needs to be created to hide and unhide rows in the sheet. Key tasks include: - Creating a macro that enables the user to hide and unhide specific rows using a button Ideal Skills: - Expertise in Excel macro creation - Proficient in data manipulation and Excel functions - Experience in creating user-friendly interfaces - Attention to detail to ensure the macro functions correctly and efficiently This project is straightforward and should be quick for an experienced Excel user.

I need an experienced data entry person to perform research on Twitter(X) for crypto/stock twitter influencers/posters with over 1,000 followers who make predictions on crypto/stocks. @CryptoCapo_ is one example of a desired crypto influencer account. I also want you to find stock and crypto prediction Substack accounts, there is no subscriber minimum. It is your job to find other similar accounts and make a spreadsheet with two sheets, one for twitter and one for substack. the twitter sheet will include the twitter handle and the link to their profile for each account. The substack sheet will include the link to the main substack page, the number of subscribers, and whether the substack is free or paid. if the substack is paid, please have different columns for the differ...

...potential investments Data Source: 200+ proprietary historical records with up to 90 parameters Mentoring requested (to be worked with tech project lead and data engineer): • Data-Preprocessing (missing values, normalization, outliers) • Implementation methods for feature selection (e.g. correlation Analysis, feature importance, etc.) • Identify and run different algorithms (e.g., logistic regression, decision trees, random forests, gradient boosting, neural networks) • Details and rationale behind algorithms selection • Hyperparameter tuning and optimization • Cross-validation • Performance metrics (e.g., accuracy, precision, recall, F1 score, ROC-AUC) • Score Calculation and thresholds • Deployment and Monitoring Too...

I need to make updates to userform so that empty dates do not affect filter on table. Right now leaving date field empty hides all the rows of table. Few more updates needed and more details will be shared with selected freelancer.

...audience as well as out of town visitors, offering content related to the immediate area, tourism, and local businesses. - Expertise in creating engaging, polished and professional magazine layout designs is required. - Familiarity with rv parks, glamping, and outdoor activities is a bonus, as it will enhance the content of the magazine. For the Ad Campaign: - The ad campaign should be separate from the magazine, but still aligned with the magazine's target demographic. - I am interested in promoting our rv resort using billboard and signage. Thus, experience and creativity in creating compelling outdoor advertisements is crucial. - The campaign aims to drive traffic to purchase or read the magazine, so understanding of effective call-to-actions and market strategie...

...two main areas: - Creation of PowerPoint presentation using a CSV data file - Automate the process via a public URL to upload the CSM file Creation of Powerpoint Presentation The CSV file will feature data-points in columns. A powerpoint presentation template will be provided for reference. The graphs and tables should be present as per the data-points present in CSV file. Automating the Process This is the secondary part of the job. Once we have are successfully able to convert a CSV data in PPT format, we should create a public secured link to upload the file. It should be auto-converted and file should be ready for download. The ideal candidate should be a proficient Python Developer with a solid understanding of data analysis and autom...

...search of a professional to create monthly sales reports in Excel. We need to create several tables starting from the attached files starting from input file 1 1- In input file 1 you need to filter the data in column B and take into consideration only "Pagamento ordine" and "Rimborso". Make the sum using the formula in column J "totale ordine" of the attached “esempio output” file 2- Filter the rows of input file 2 (attached), column D "Dettagli prodotto" so that the different product details appear only once and report them in the VAT output file so as to have only 2 Product Name columns (in which the "dettagli prodotto”of input file column 2 are listed. (example VAT file attached) 3- The app must che...

Seeking an experienced animator who can help create two separate video pieces for my product, a concealed cistern. The videos will be a detailed installation guide and a service video. Your job will be: * Create a storyboard that highlights the essential details for each video * Incorporate animated product close-ups to showcase crucial features * Execute an aesthetic style that is educational, professional, and attractive Ideal candidates should have: * A strong understanding of graphical explanation methods * Experience designing instructional videos * A solid grasp on animation to accurately portray systems and operations Please review the product before bidding and provide a brief approach on how you'll tackle this project. Your understanding of the project requirement...

I have a PDF version of a brochure, and I require the double page spreads to be split into separate A4 pages. There are 8 double spreads to be split into separate A4 pages. The content should be kept exactly the same.

I'm seeking an expert in Excel w...expert in Excel who can help me with a few diverse tasks, such as data entry, creating formulas and functions, and conducting data analysis. The dataset I'll be working with is medium-sized, ranging from 100 to 1000 rows. The primary goal of this project is to organize and structure the data. Ideal skills for this project include: - Proficiency in Excel, including using formulas, functions, and pivot tables. - Excellent attention to detail for accurate data entry. - Experience with data analysis and the ability to draw meaningful insights from the data. - Strong organizational skills to structure the data effectively. Ultimately, I'm looking for someone who can help me streamline my ...

I am searching for a skilled 3D modeller to create strikingly detailed character models for an animation project. - You will be tasked with creating high-poly character models. - Your creations will serve as the centerpieces for our animation and visual effects projects. I need it to be rigged I need the body separate from clothing The perfect freelancer for this project has a strong portfolio that shows off their capabilities in creating high-poly, detailed character models. Experience in animation and VFX would definitely be a plus. A knack for realistic rendering is crucial to this project, as these characters will be showcased in high resolution animation. If your skills align with these requirements, I can't wait to see your proposal.

I'm in need of an Excel expert who is well-versed in Excel and has experience in creating detailed and visually appealing dashboards for project management purposes. The primary goal of this dashboard is to help me track the effort and progress of my project. The information that I'd like to track includes: - Time spe...well-versed in Excel and has experience in creating detailed and visually appealing dashboards for project management purposes. The primary goal of this dashboard is to help me track the effort and progress of my project. The information that I'd like to track includes: - Time spent on tasks - Percentage of completion - Deliverable status The excel is small and has only 15 rows its more like visualization task so that all data can be projec...

...video in general: entertaining and highly engaging. I am looking for a person that can be my full time editor for the next 6-12 months with the possibility of consistent pay-raises when the agency experiences growth. You will be paid 7usd for every video-edit. The process is super streamlined. All videos are tailored by me -> you get the raw footage, edit it and upload the edited videos in a separate folder. I expect a simple thumbnail that fits the ratio 1:1 on Instagram feed. All videos should be edited in 9/16 format for fullscreen experiences on IG Reels + TikTok. Please reach out to me here on “platform-name” and tell me a bit about yourself, your current situation and show me previous work. Important: I expect a sample to quality check your work, if I f...

...form will be used to enter essential information to properties by our data entry operators. This will be one (1) html page only, no backend development necessary (php receiving the form optional, see below). „Nice Admin“-Template must be used: Project Requirements: - Convert Microsoft Word Document (2 pages) to Web Form: Transform the content and layout of the Word document into a web-based form. - Responsive Design: Ensure the form is fully responsive and looks great on all devices (desktop, tablet, and mobile). - Form Fields: Create all necessary form fields as outlined in the Word document, including text fields, dropdowns, checkboxes, addable rows table, etc. - User-Friendly Interface: Design a clean, user-friendly interface

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.

...for job seekers. - Candidate Database: It should have a database where potential employees can create profiles, upload their resumes, and apply to job postings. - Customizable Forms: I require the ability to add customizable forms for job applications, contact information, etc. - About the Business: A page dedicated to the information about the recruitment business. - Legal and Privacy Policy: A separate section for legal and privacy policies. Key design elements I'm looking for include a modern, sleek design, a user-friendly interface, and a mobile-responsive layout. The website should be visually appealing and easy to navigate on both desktop and mobile devices. Experience in creating job portals or similar websites would be a big plus. Please provide examples of your pre...

...expertise will help steer the physics of the underlying calculations for a more streamlined functionality. Key Tasks: * Calculation optimization focusing primarily on code efficiency * Commenting and providing a succinct documentation The project is expected to be wrapped up in two days. The whole source code will be provided by me, and note that there's no Git involved in this project - that is a separate endeavor. Consequently, proficiency in managing source code manually is essential. Electronic mathematics and cpu. Ideal Skills: * Proficient C programming * Comprehensive understanding of electromagnetism calculations * Exceptional skills in writing efficient code * Ability to comment on code and provide useful documentation * Previous experience with manual source c...

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

...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 should be grouped together, end file should be in 1 sheet, not separate sheets. Send me: 1- Your strategy in finding those companies and collecting names and emails of relevant employees, 2- Total number of expected V...

...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 Office skills to dr...

I'm in search of an Excel expert who can assist me with complex tasks in Excel. Specifically, help is needed in two key areas: - Formulas & Functions: While basic arithmetic operations are simple for me, I need assistance with text and date functions. - VBA Macros: I'm looking for someone who can develop advanced user forms and interfaces. This requires a high level of VBA expertise. The ideal candidate would have a strong background in Excel, with a focus on formulas, functions, and VBA. Previous experience working on advanced macros and a deep understanding of text and date functions will be a huge plus. The ability to communicate effectively and understand my specific needs is essential.

I need a professional to convert the information in the attached document into an organized, well-formatted Excel sheet. The project will require you to: - Copy all the text content of the document into corresponding cells in the Excel sheet. - Transcribe all tables and cha...need a professional to convert the information in the attached document into an organized, well-formatted Excel sheet. The project will require you to: - Copy all the text content of the document into corresponding cells in the Excel sheet. - Transcribe all tables and charts in the document accurately into the Excel. - Maintain the original formatting of the data in the document. The Excel document should: - Include all columns and rows from the original document. - Not require any additiona...

I have a series of medical bills that need to be entered into a spreadsheet. The data is primarily textual, numeric Ideal Candidate: - Must have a keen eye for detail to ensure accurate transcription of the printed text into a digital format. - Proficiency in spreadsheet software for the efficient and organized entry of the data. I have attached an example bill and the expected excel format. I have 34 such pages of bill. Overall you will have ~200 rows to be entered.

I'm in need of an Excel expert to enhance my files. The tasks include: - Removing duplicate rows - Fixing formatting issues - Merging two sheets into one Additionally, I would like to incorporate a corporate branding style in the file, utilizing appropriate colors and logos. Ideal Freelancer: - Proficient in Excel with experience in data cleaning - Skilled in formatting and merging multiple sheets - Familiar with incorporating corporate branding within Excel

I have a substantial Excel table and I am in need of a skilled data analyst to help with correlation analysis between Column 1 to 9 of my dataset, which contains more than 4200 rows and 9 columns. Need the source file of xls with formula too Key Responsibilities: - Perform accurate correlation analysis on specified columns - Generate line graphs to visualize the correlation Ideal Skills and Experience: - Proficiency in Excel and correlation analysis - Solid understanding and experience with line graph creation - Excellent problem-solving abilities - High attention to detail I'm looking for accurate and efficient work so I can understand the relationship between my data points and act accordingly. Your experience could be the key to enhancing my pr...

I'm in need of a professional who can convert both scanned documents and photos into simple data in Excel format (language is not in English workable when one can use translate and understand the few terms that are there). The ideal candidate will have the following skills and experience: - Proficient with MS office - Expert in handling MS Excel - Ability to follow a specific Excel template provided - Attention to detail to ensure accurate data entry ***The task is very simple and just requires attention to detail. I need mainly 4 Data Rows: 1. Date 2. Payor/Payee 3. Amount 4. Short Description of Transaction (if given in the doc) Please message me to talk about the project and the realistic bid price per Job. Your responsibility would be to ensure...

Separate the alto saxophone sound track (layer) from other tracks (layers) and produce a clear accompaniment audio file The audio file is in the attachment

... All should have minimum 5x4 M and opens to outdoor landscape setting area Another bathroom with washing area for ladies. Kitchen minim 5x5 with store minim 2x3 U shape stairs Elevator Master room minim 3x3 Clothes washing area with open area for clothes drying Two entrances from north and from east 1st Floor Main master room minim 5x7 including closet area 2 other master rooms minimum 4x6 2 separate rooms with bathrooms in between Seating area with a terrace (balacony) Stair to second floor 2nd Floor (50% of ground floor foortprint) Apartment with 3 rooms and 2 bathrooms + setting area + kitchen + one master room It should have standalone stairs that connects with 1st Floor stair so there is possibility to open it to 1st Floor or isolated as standalone apartment...

I'm in need of a professional CV writer to create two separate CVs for me. One will focus on my expertise in IT, the other on Project Management. Key Requirements: - The CV for my IT specialisation should include all relevant technical skills, IT certifications, and programming languages I possess, to ensure they are ATS compliant and keyword-rich. - The CV for my Project Management specialisation should highlight my experience in managing projects, leading teams, and achieving project milestones. - Both CVs should be designed in a traditional format. - My level of experience in the respective fields is mid level, so the content should reflect this.

Hi there! I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.

I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.

...available at my time between 7am-9pm PDT, Pacific Day Time, / USA – Los Angeles. There are 4 computers that I need help, you post your bid, that you get pay for each pc. If you are able to help wit 2 units, you get pay for two SO INCLUDE IN TEXT IN YOUR PROPOSAL, WHICH COMPUTER SUPPORT HOW MUCH COST: # 1, HP, $.. #2, LENOVO, $.. #3, DELL, $.. #4, ACER, $.. We will post for the winner 4 separate jobs, each will be separate awarded before start! If same computer we can’t fix, is no pay, of course To start communication you need to answer with: “4 computers” so I know you read my listing 1, I have on older HP laptop, have not used since 2021, run on Microsoft Office Enterprise 2007 Can’t go online: “YOUR CLOCK IS BEHING” - I go to ...

I need 1 photo modified. The photo that needs to be changed = Model-car-photo1-8bit.jpg. The edits I need are as follows, and I attached images that describe the edits i need. Recover Dress Highlight Details but keep the skin exposure bright. (). Fix models arm marks and tan line. (). Remove Bright Reelections on c...lights look like they are on. (). Edit the license plate so it says THT GIRL. Make it look real. () After those edits are done, please make the subject stand out from the background.. Maybe darken the car and background, to put more emphasis on the model.. Final Deliverable: I need the layerd PSD file with the various edits on separate layers.

...management skills to complete the project in a timely manner more details--- ### Task Description: Google Sheets Data Entry Expert for Cricket Schedule **Objective:** Create a comprehensive cricket schedule for the English summer season using Google Sheets. The schedule should include fixtures for various tournaments and teams, organized by date and start time. **Scope:** The schedule should cover the following: 1. England Men 2. England Women 3. England Disability 4. Vitality County Championship 5. Vitality Blast 6. Metro Bank One Day Cup 7. Charlotte Edwards Cup 8. Rachael Heyhoe Flint Trophy 10. The Hundred **Details to Include:** For each match, include the following columns: - Date - Match Number - Teams (Example: Team A vs Team B) - Match Format (Example: T20, OD...

I'm looking for a talented freelancer to help me automate a complex process. As of now, I manually gather numerical data from a variety of unstructured sources like images, text, and PDFs. This data includes formulas and is stored both on my local computer and the web. At present, I get ChatGPT to convert this data into a table which I then paste into excel. I do calculations in excel to find out what percent each ingredient is of a total formula. Then I create a new entry into a table in Airtable and paste this data into a different table in Airtable which references the first table. I need someone to automate this data extraction process, calculations and entry into two separate Airtable tables so I can do it repeatedly myself. I work in a s...

...be able to automatically calculate the total number of jobs done and the total payment owed to each installer. **Requirements:** 1. **Job Tracking:** - Columns for the date each job was completed. - Columns for the job details including customer address and account number. - Columns for the installer assigned to the job. 2. **Payment Calculation:** - Ability to input the payment rate per job. - Automatic calculation of the total number of jobs completed by each installer. - Automatic calculation of the total payment owed to each installer based on the number of jobs completed. 3. **Customer Information:** - Columns for customer name, address, and account number. 4. **Summary:** - A summary section that provides totals for jobs comp...

I am looking for an expert who can assess and modify an existing Excel macro for compatibility with Excel for Mac 2019 or later. The current macro mainly handles formatting tasks within the Excel file. Key Requirements: - Assess the current macro...the current macro's compatibility with macOS - Modify the macro to ensure compatibility with Excel for Mac 2019 or later I don't have a strict deadline for this project, so you can work on it at your own pace. However, I am looking for someone who can get this done efficiently and effectively. Feel free to ask any questions for more information. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compatibility. - Knowledge of macOS compatibility issue...

THIS IS NOT A NORMAL PROBLEM.... so I need a REAL expert! I'm currently fa...I'm currently facing issues with tax display on my WooCommerce store. The tax is not appearing for customers in the front end, and it's also not showing on the invoices. I'm not using any additional tax plugins or extensions. 1) Tax is configured 2) Tax rates are set 3) Ive tried turning off all other plugins 4) Ive tried changing theme Key Requirements: - Ensure that tax is displayed as a separate line item during checkout. - Include tax details on customer invoices. Ideal Skills: - EXPERT ONLY experience and understanding of WooCommerce / wordpress - Proficiency in managing taxes within WooCommerce. - Attention to detail to ensure that tax information is displayed correctly. site...