Excel macros check data cell punët

EXCEL. Preferencia: Google Sheets. Tengo una sola hoja con varias columnas: Conjunto 1: columna 1 "Activo" tienen nombres que pueden repetirse. columna 2 "Categoria". tienen clasificaciones. Conjunto 2: columna 3 "Titulo" tiene nombres de Clasificaciones. columna 4 "Categoria de Activo 1" a columna 11 "Categoria de Activo 8". columna 12 a 31 "" y "" con pasos de suma 1 en 1, portan valores numericos del 0 a 5. columna 32 a 41 "D1" con paso de suma 1 en 1. Relaciones: + columna 1, 2 y 32 a 41 estan relacionadas. + columna 3, 4 a 11, 12 a 31 estan relacionadas. Se necesita crear una tabla dinamica donde aparesca cada dato de "Activo" donde se halla una coincidencia "Categoria" con...

...template. This is the template: The requirements to the output video are: - Put below mentioned sequences 01-03 into a row - Video will be displayed in this frame (check ) - Video must be in WebM format - Video background must be transparent (!!) - Video must be web-optimized - Video must run in a loop - Video must contain transparent gradient on left/right side - Video sequence 03 must contain transition animation Please check the individual sequences for more details: Sequence 01 - Smartphone - Take animation from 00:09 - 00:15 - Take screenshot - Add animation transparency at left and right corner - Do not change screens while

...seeking a skilled React Native developer to create a feature-rich messaging app for both Android and iOS platforms. What we have ready: We have the Design in react native ready - also we have many APi ready and we will provide u them App refernces: WhatsApp as refernce "use WhatsApp for android and IOS as reference. API We will provide alot of the API, that u can integreated in the API Milestone Check the Document fill it out and sent me back! Timeline: I need this project to be completed as soon as possible. Hence, a fast turnaround time is essential. Ideal Skills: - Proficient in React Native and JavaScript - Experience in building messaging apps - Ability to deliver a high-quality, bug-free product quickly - App Security End to End call and Chat Fast and secure Bat...

...method of validating and approving or denying loan applications. • Loan Disbursement Tracking: Functionality that records and monitors the distribution of approved loans. In terms of user roles, the system must seamlessly cater for three types: • Administrators: This role should have full access to all data and features. • Loan Officers: The system should allow these users to manage loan applications and approval processes. • Customers: This role will be able to apply for loans, check the status of their application, and monitor their loan disbursement and repayment schedule. The system should also effectively manage loan repayment schedules by: • Automatically generating repayment schedules for approved loans. • Providing the option ...

Dev a tool to check do people have a Netflix account using only their phone number. It must be easy to use : 1 - User add rotating proxies. 2 - User load phone numbers list. 3 - User press GO to start. 4 - Then the tool creates a .txt file including all the phone numbers subscribed to Netflix. The tool must be accurate, efficient and work fast. Please bid only if you have previously done similar project. Thank you !

a) I’ve noticed you’ve updated the title as per my request (Заклучување и означување instead of Исклучување и означување) but the same needs to be done in the first sentence of the content for the golden rule, the text in bold. b) Check the anchors in both versions. It seems that rule/anchor #9 goes to number5

...proficient Excel programmer who can assist with both data analysis and process automation. The project entails: - Data Analysis: Proficiency in sorting, filtering, and performing advanced data analysis within Excel is a must. - Process Automation: I'm looking to automate several manual processes using Excel. This would involve creating macros, custom formulas, and potentially VBA coding. - Template Creation & Modification: You should be able to both create new Excel templates and modify existing ones for the specific purposes of data analysis and automation. Skills and Experience: - Proficient in Excel: You should be well-versed with Excel's data analysis features and have experience in proces...

I need a WooCommerce expert to make some unspecified customizations to my website. -DO NOT ASK FOR CHATTING before check anything -AUTOMATIC BIDDER WILL BE DELETED -COPY/PASTE REPLY WILL BE DELETED -We only require people with excellent experience in this sector. The aim of the project is to create a customization within Woocommerce that allows the autonomous release of licenses to authorize the use of a software. The creation of licenses already takes place through our internal system, already coded and ready for use. were attach an example of generated License file (called KEY). Customer just ned to copy the Machine ID text they copy from the software (see screenshot atached) , and paste it into the field you'll put into the Woocommerce Customization must be realize...

I'm looking for a skilled individual to assist with a less than ten PDF documents data entry project. Key Responsibilities: - Copy typing of content from PDFs - Extraction of specific data points - Validation for accuracy and completeness This role will suit someone with proven expertise in data entry and validation. The ideal candidate is detail-oriented and proficient in handling PDF documents. Experience with Microsoft Excel is a plus.

1. Butter paper - its done done (check attachment ) 2. Aluminium foil 3. Cocktail tissue 4. Tissue box 5. Pocket tissues need to do 2,3,4,5 also find the logo i have attached.

Value retrieve from API is not stored properly. And check the value send to API. API is integrated, no error on API. Just save and value send issue only.

I need a freelance expert to assist in calculating heat loss and heat gain through an Excel spreadsheet. Key Responsibilities: - Conduct heat loss and heat gain calculations just for the packaged plantroom. - based on the gains find the required fan flow rate to offset those gains Must be done on excel Skills and Experience: - Proficiency in Excel is a must. - Previous experience in heat loss and heat gain calculations for commercial buildings. - Knowledge of HVAC systems and how to optimize them is highly preferred. I can provide the equipment in the plantroom and the internal and external design conditions

I would like to hire someone to assist me with setting up email accounts with forwarding to gmail and or look at possible solutions for setting up emails rather than from the hosting account, but perhaps a third party provider, one which wi...setting up email accounts with forwarding to gmail and or look at possible solutions for setting up emails rather than from the hosting account, but perhaps a third party provider, one which will not have any issue with emails not coming in due to spam filter on current hosting, and where which all emails from various website domains can be viewed from the one place or folder, without having to check each inbox individually. You will need to have extensive experience with email accounts setup and forwarding and find the right long term solution...

I'm in need of a data entry freelancer with a good command of Microsoft Excel. The task involves inputting data into a spreadsheet. The data is simple and involves just a few columns. This is an ideal project for a freelancer who is available to work from home. Ideal skills for this job include: - Proficiency in Microsoft Excel - Attention to detail - Ability to maintain accuracy while working with data Please note that I don't require any specific software knowledge other than Microsoft Excel. Looking forward to working together.

I need a freelance expert to assist in calculating heat loss and heat gain through an Excel spreadsheet. Key Responsibilities: - Conduct heat loss and heat gain calculations just for the packaged plantroom. - based on the gains find the required fan flow rate to offset those gains Must be done on excel Skills and Experience: - Proficiency in Excel is a must. - Previous experience in heat loss and heat gain calculations for commercial buildings. - Knowledge of HVAC systems and how to optimize them is highly preferred. I can provide the equipment in the plantroom and the internal and external design conditions

I'm seeking an experienced professional who excel...seeking an experienced professional who excels in sophisticated data analysis, chart creation and process automation using Excel. You'll need to leverage data visualization techniques to deliver insightful dashboards, with a key focus on developing pie charts for clear, concise, and impactful data representation. Your responsibilities will include: - Analyzing and interpreting complex data sets - Crafting well-structured and insightful pie charts - Automating repetitive processes to improve productivity Core competencies required for this role include a strong background in Excel and data analytics, proficiency in dashboard creation, a keen understanding of automation process...

I'm aiming to have a Laravel based e-commerce website that primarily generates online sales. The site will feature: - A product catalog showcasing my range of products - An efficient shopping cart for smooth customer transactions - A fully integrated payment gateway to assist easy and secure transactions - Shipping options and details integrated into the check-out process This website will specifically target a B2C market. Therefore, a user-friendly interface that enhances the shopping experience for individual customers is crucial. Ideal freelancers for this project should have a strong background in Laravel and e-commerce website development, with particular expertise in integrating payment and shipping functionalities. An attractive design that enhances brand visibility an...

I am currently looking for talented Excel, VBA, and Macros developers who can assist in editing four planning files and managing their data in one main Excel file. The duties you'll be executing are as follows: Automating data entry: This will streamline the process of inputting inventory data, making it quick and efficient. Creating formulas and calculations: To aid in the management and manipulation of our inventory data. Generating reports from the data: We need detailed, clear reports to help analyze and evaluate our inventory. You should also know how to: Use Conditional formatting Work with Data validation Create and manage Pivot tables Set up an interactive Dashboard Knowledge and experience working with &l...

...workforce. Key Responsibilities: - Develop a structured sales training program encompassing various selling techniques, customer service, and product knowledge reinforcement. - Create engaging and interactive product training sessions that educate employees about our offerings, benefits, and unique selling points. - Implement a series of on-the-job training modules that help employees grasp and excel in their roles, while aligning their efforts with organizational goals. Ideal Candidate: - Experience in designing and delivering comprehensive sales and product training programs. - Proven track record in conducting engaging and effective online and offline training sessions. - A solid understanding of adult learning principles, particularly in a corporate setting. - Excellent com...

... Key Responsibilities: As the Backend Developer for this project you will: 1. Design and develop scalable server-side applications. 2. Implement robust APIs for seamless communication with the Flutter client. 3. Integrate third-party services to enhance platform features. 4. Manage data storage solutions and optimize database performance. 5. Ensure server-side code is optimized for performance and reliability. 6. Implement security measures to protect user data. Requirements: To excel in this role, you should: 1. Have proven backend development experience. 2. Be proficient in backend programming languages like Python, Node.js, or Java. 3. Have familiarity with web frameworks such as Django, Flask, or Spring Boot. 4. Understand RESTful API des...

I am in need of a skilled professional, capable of reorganizing my database of approximately 1,000 customers. To be specific: - The Excel database contains the following data field: Name, Email, Phone number, Address, City, and Country. - The organization should be done alphabetically by name. - The new Excel template format should have each field in a separate column. For this job, it'll be ideal if you possess exceptional Excel and data organization skills and have prior experience in Database Management. Efficiency in Excel, coupled with keen attention to detail, will aid in the successful completion of this task. Anyone with a seasoned approach to the task will be greatly appreciated.

I'm seeking a freelancer who can develop an automated system in Excel to manage backorders. This system must create new data for efficient backorder handling. Specific requirements include: • Creation of an automation tool that handles numeric values, text strings, and dates and times. • The system should adequately track product lead times and inventory levels, despite not automatically generating reports. Please note, having prior experience in backorder management and Excel automation will be advantageous for this project. The ideal freelancer should have strong data handling capabilities and excellent knowledge of Excel. Proven experience in similar projects is preferred.

I am seeking a well-versed Zabbix expert capable of setting up specific health checks on a JSON response, and able to provide documentation on how to replicate these settings to other hosts. Key requirements: - Experience with Zabbix software - Understanding of health check parameters within Zabbix - Expertise in JSON response monitoring Your task would involve monitoring the following parameters: - Status code - Error message - Status for each service in this json { "jsonrpc": "2.0", "id": null, "result": { "health_ok": true, "epoch_time": 1714458226.6386402, "date_time": "2024-04-30 06:23:46", "services": { "http_ok": true, ...

I'm looking for a skilled developer who can build a Telegram bot and a website for an asset management platform. Here's what I need: - On the Telegram bot, users should be able to: - Deposit money - Check account balance - Withdraw money - Calculate returns - Receive investment analysis - Manage their portfolio - Access customer support - On the website, users should be able to: - Perform the same functions as the Telegram bot - View real-time market data - Check their investment performance history - Review their portfolio composition Ideal skills and experience: - Proficiency in building Telegram bots and websites - Experience in developing fintech platforms - Strong knowledge of stock and cryptocurrency markets - Ability to provide...

EXCEL COSTOS Y PRECIOS EN base al tipo de producto QUE SE ENUMERARARAN DEL 1 AL 10 (ELECTRONICA, SOFTWARE, ETC) , peso , volumen y costo pagamos unos ciertos impuestos de importacion SEGUN EL TIPO DE PRODUCTO NOSOTROS QUEREMOS QUE EN BASE A ESTOS DATOS QUE VAMOS A PREFIJAR PARA CADA CATEGORIA , YA NOS DE EL COSTO , CUANDO EGREGUEMOS PRODUCTOS NUEVOS COMPLENTANDO LA TABLA. CON LOS COSTOS DE ESTA TABLA , NECESITAMOS OTRA TABLA PARA CALCULAR MARGEN DE GANANCIA TOMANDO EL PRECIO DEL PRODUCTO Y NOSOTROS PODER SETEAR UN MARGEN MODIFICABLE PARA CADA ARTICULO DE NUESTRA TIENDA, ESTOS TIENE UNOS COSTOS FIJOS (FEE FIJO DE VENTA , GASTOS DE ENVIO , COMISIONES DE PLATAFORMA QUE VARIAN) ADEMAS NECESITAMOS QUE EN ESTA TABLA SE PUEDAN HACER ¨COMBOS¨ ES DECIR PONER VARIOS PRODUTOS Y Q...

Need a backend developer to implement below requirements in client's existing code base. 1. Feign clients 2. Request and the response interceptors 3. For opt in, only mobile number to be passed as param to the feign client's method - ("9199...sending sms, only mobile number and msg to be passed as param to the feign client's method - ("919999784665", "Hey there I am using whatsapp"); 4. All other query params to be inserted via request interceptor 5. userid and password to be picked from yml file, they will be different for different environments. 6. For both the APIs we'll have response interceptors which will check if the 'id' given in 'response' corresponds to one of the error codes. If they do, then we thro...

read the text of 1 driver's license

I need an experienced freelancer to create a chart with interest rates in Canada for every month between January 2015 and the current month. K...between January 2015 and the current month. Key Requirements: - The chart should accurately reflect the fluctuation in interest rates over the specified time period. - The format must be an excel which is easy to read and interpret. - No additional analytics features such as trend lines or forecasts are necessary, the primary focus is to clearly display interest rates by month. Ideal Skills: - Research historical interest rates in canada - Proficient in Excel and creating line graphs. - Strong understanding of financial data, specifically interest rates. - Eye for detail and ability to ensure the data is clearly pr...

Hi Berty J. I hope you are fine. Remember the Skyscanner project you did? I need a cmd tool to get parcel tracking histories from where the last number is the parameter I need to call the tool and I expect a JSON on stdout with either the list of events ...Skyscanner project you did? I need a cmd tool to get parcel tracking histories from where the last number is the parameter I need to call the tool and I expect a JSON on stdout with either the list of events (shipmentCourse entries) or anything they want to tell me like "expecting your shipment data soon." pls check and let's discuss availability and effort.

I'm currently facing some network challenges specifically on switching technologies and internet speed. I have experience in networking, so I will give you the diagram and the current configurations. All I need it you check the configuration and give me your recommendation on the best configuration that suits our network. plus, I need help with QoS to limit the users download to keep the bandwidth in line. Certification in CCIE/CCNP is a must-have for this job

I need an experienced freelancer who can convert Excel data to 2D DWG files on an urgent basis. Key Requirements: - Utilize the Excel data to create 2D contour plots, specifically representing the height distribution on a bridge surface and the riverbed levels. - Create these contour plots in a DWG format. - Accuracy and precision are crucial for this project. Ideal Skills and Experience: - Proficiency in AutoCAD for DWG creation. - Prior experience with data visualization from Excel. - Immediate availability to start and complete the project as soon as possible. Please include any relevant portfolio items or examples of similar projects you've done in the past. I am looking for a quick turnaround without compromising on quality.

Hola, estoy en la búsqueda de un book keeper con excelentes habilidades utilizando macros en excel esto es una de las habilidades importantes que me están pidiendo en el freelancer, indispensable también que tenga experiencia haciendo los libros para negocios en Canadá. Comunicación excelente en inglés. Me gustaría oír de ti. Saludos

...Whatsapp API interfacing will be required for sending and interacting with Patients. - Patient Web App interface to start with - Appointment for Home Collection booking system, payment of charges, and to check all historical reports for his/her tests done at lab and his/her family members. These reports database has to be built from existing lab software. Sending link for doctors review , and doctor can check these reports through bitly link received on whatsapp/sms with OTP authentication - For Lab Staff - Admin module to assign Home Collections with google map navigation, Task assignment, To check test prices and offer discount and collect charges from the patients by sending link or through QR, Send reports to referring doctor or patient why Whatsapp. - For refer...

I need someone to add a total of 50 bookmarks to my Word document. Essential Requirements: - Add 50 bookmarks to the document - create a excel; audit xls with 50 rows listing the bookmark name and the section text name (we use that as quality control and testing)

I'm seeking a proficient freelancer who can handle all aspects of setting up, running, and ensuring the success of my Shopify dropshipping account. My business focuses on a specific nich...SEO: I prefer to attract customers to my store through organic SEO strategies. Practical knowledge of SEO tools and techniques is a must. 3. Social Media Proficiency: In addition to SEO, I'd like to integrate targeted advertising on Facebook and Instagram into my marketing strategy. Ideally, the freelancer should have a track record of optimizing Shopify stores for effective dropshipping. To excel in this task, the freelancer should possess excellent SEO skills, social media advertising knowledge, and a clear understanding of dropshipping mechanics. Your bids should reflect your compet...

I'm looking for an expert with exceptional skills in Microsoft Access/Database, Excel, and VBA coding. The main focus of the project is on Access/Database, the specific tasks include: - Data Entry - Query Building - Database Design Ideally, I need someone who can efficiently handle a database containing 10-20 tables. You should be detail-oriented, experienced in managing medium-sized databases, and proficient in maximizing the functionality of Access. Excel expertise and VBA coding skills will also be highly valuable in this project. ONLY ACCEPT TASK IF YOU CAN DELIVER WITHIN 3 HOURS

Hi, I installed mediawiki and imported pages from wikipedia successfully .. but all pages are showing the following error in them: Lua error: Cannot create process: proc_open(/dev/null): Failed to open stream: Operation not permitted please check attached images.. I need a server support or mediawiki expert to fix this..

I'm in need of an experienced data analyst who can help me merge and clean up my Excel database. - Database Type: It is an Excel database that's in need of expert merging and clean-up. - Number of Files: The project revolves around a single Excel file with 4 sheets - Data Type: The data in question falls under the category of customer data. We have exported 4 databases from all our software. Basically we want all the duplicates to be deleted and the final file to be clean and able to be uploaded to mailchimp

I am seeking a proficient web scraper to extract specific data from The data I need includes venue details and contact information. I require the end product to be delivered as a well-organised Excel file. Key aspects to focus on: * Meticulous detail on venue data * Comprehensive contact information * High level data formatting skills The ideal candidate has demonstrated experience in web scraping, data management and Excel. A background in music or event-based data is a plus. Efficiency, precision and respect for the source website's terms of service are crucial for this project.

I’m in need of an Excel specialist who is adept at enhancing operational efficiency through the automation of repetitive tasks, namely the creation of reports utilizing sales and operational data. Key Requirements: - Creating a system for report generation on Excel, extracting key insights from extensive datasets. - Reports should conveniently display revenue, profit margins, sales growth, as well as production metrics and efficiency metrics. Ideal skills: - Proficiency in Excel and data analysis - Experience with big data and automating report generation - Strong attention to detail and the ability to make data actionable.

...utilizing their expertise in researching, content writing, and data entry to deliver high-quality results. Responsibilities: Conduct thorough research to identify and compile a targeted list of individuals in America relevant to our business objectives. Utilize various online resources, databases, and tools to gather accurate and up-to-date information. Organize and maintain the collected data in a structured format, ensuring accuracy and completeness. Collaborate closely with our team to understand specific criteria and requirements for the list. Requirements: Proven experience in researching, content writing, and data entry, preferably in a business or professional setting. Excellent attention to detail and accuracy in data collection and entry. Strong or...

...seeking a dedicated property manager. This position will be part-time or full-time. Responsibilities: •Gathering data from one source (Google Drive) to enter into document management (databases or partner websites by case) • Checking and reviewing documents for accuracy and completion • Attaching supporting files to the document management • Searching for additional information for documents that are incomplete • Verifying, correct, and delete unnecessary data, or combine data The requirements for the applicant include strong attention to details, college degree, access to email and knowledge of use a device (computer or phone), basic software tools (Microsoft Office - Word & Excel). We need fast, accurate and specialized mem...

...interactive dashboard that will help track and analyze market data more efficiently. It is important that the dashboard connects to Excel spreadsheets and other Power BI resources to provide an all-round perspective of the metrics. Ideal skills and experience: - Proficient in Power BI - Excellent knowledge of Excel - Deep understanding of retail market data analysis - Excellent in crunching and interpreting numbers - Strong attention to detail Responsibilities: - Gather and interpret market data - Create a user-friendly and highly interactive dashboard - Connect the dashboard to Excel spreadsheets and Power BI resources - Regularly update the dashboard with relevant market data - Identify trends and patterns based on the data p...

I'm in need of an advanced Excel VBA specialist with proficiency in data manipulation, particularly data filtering across multiple Excel sheets. The tasks required entail: - High-level manipulation of Excel data; - Expertise in filtering data across multiple sheets; - Strong understanding of data validation; - Experience in report generation. Experience in dealing with large amounts of data and creating user-friendly detailed reports from complex data sets will be crucial for this project. Excel VBA certification and verifiable previous projects in similar tasks are a plus.

...app is not necessary. If at some point the two devices are not connected and get connected later on, missed notification during the unconnected period should not be sent. The application should be able to handle any time of notifications from any applications like: SMS / Calls, whatsapp, messenger, instagra, facebook, …. Application should not send the same notification twice in a row (need to check that the new notification received is different from the one that was sent previously) Application should run in the background for the sender side at least (Mandatory)   List of all the Nice to have features sorted by priority. Description Source Priority When using the receiver side, the user should be able to pause or resume the playing music, user should also be able ...

Buenas tardes tengo un Excel de facturación y cobranza , incluye devoluciones y transferencias de productos . Deseo que se traslade tal cual como funciona a un sitio web con usuarios , permisos

...audience engagement - Adjust strategies based on data-driven insights Ideal Candidate: - Experienced in managing public-facing Instagram and WhatsApp accounts - Skilled in uploading images - Skilled in converting video to mp3 and uploading - Able to deliver innovative project proposals Apply ASAP. Include a comprehensive project proposal with your application. Your proposal should detail your Instagram and WhatsApp expertise and outline your strategy to promote our radio station. The ideal candidate will be able to hit the ground running and can start immediately. We will require average of 6 posts a day to advertise DJs shows posted to Instagram. We will also require converting mp4 video to mp3 and uploading to our Mixcloud daily. You will need to check in with DJs on ...

...audience engagement - Adjust strategies based on data-driven insights Ideal Candidate: - Experienced in managing public-facing Instagram and WhatsApp accounts - Skilled in uploading images - Skilled in converting video to mp3 and uploading - Able to deliver innovative project proposals Apply ASAP. Include a comprehensive project proposal with your application. Your proposal should detail your Instagram and WhatsApp expertise and outline your strategy to promote our radio station. The ideal candidate will be able to hit the ground running and can start immediately. We will require average of 6 posts a day to advertise DJs shows posted to Instagram. We will also require converting mp4 video to mp3 and uploading to our Mixcloud daily. You will need to check in with DJs on ...

...experience in maintaining projects and adding new features - Ability to work independently and within a team - Good communication skills, as you may need to coordinate with other team members In your bid, please include any relevant experience you have in similar projects, as well as your proposed approach to handling the bugs and adding new features. HERE IS MY EXAMPLE WHAT I NEED RIGHT NOW: 1. Check why my upload size changes for screenshot from 3mb to 15mb limit also after restart of server is still not working. 2. Solve problem with "always selected" main Topic with something like it is in my suggestion. Please see in video. Two more small update in Topic menu: Please also fix that after creating New Topic menu will not stay like it is in picture "old stat...

I need help browsing the web for text data and organizing it in Excel. - The text data is to be organized in Excel by name and other relevant information. - No specific Excel functions or formulas need to be used, you will simply need to look at the page and type the information into the spreadsheet. Ideal skills: - Proficiency in web browsing - Be very quick - Strong attention to detail - Familiarity with Excel - Time management skills The task is straightforward, but attention to detail, accuracy, and the ability to work efficiently are crucial. Please submit your daily rate.