Vba workbook pivot tablesproiecte

Suntem o companie multinationala care presteaza servicii in industria automotive si cautam ingineri pe teritoriul Romaniei pentru testarea soft-ului auto. Se va lucra remote dupa perioada de training. Cunoasterea limbii germane este obligatorie, iar engleza reprezinta un plus. De preferat sa aiba cunostinte de Matlab / Simulink, VBA or Python.

Se da urmatorul scenariu: Incazari in data de x,y sau z la locatia x, y sau z cu un echipaj variabil de 1, 2, 3 sau mai multi. Am nevoie sa extrag(copiez) informatia si sa o pun la fiecare om din echipaj in sheet separat. am incercat cu filtre si macro dar imi copiaza doar informatia de la prima coloana de echipaj. se poate cu alta formula sau cu VBA (cod)

Am nevoie sa modific / imbunatatesc cateva fise Excel pe care le folosim zi de zi in munca noastra. Am nevoie de cineva cu cunaostinte foarte bune de programare in Excel sau VBA

Proiectul va avea o prezentare scrisă, care va include enunțul și obiectivele pe care și le propune aplicația și modul de rezolvare, cu indicarea organizării datelor în foi de calcul, a funcțiilor și formulelor utilizate și altor informații relevante în acest sens (se vor capta ecrane sugestive). Nu se fac descrieri pas-cu-pas, se prezintă CE s-a făcut și ce s-a utilizat, NU se ...AVERAGEIF sau COUNTIF - Utilizarea formatării condiționale (in 3 feluri, cu cel putin o formula) - Construirea a minim 2 grafice diferite (pot fi mai multe ) cu semnificație și explicațiile necesare (nu simple valori puse intr-o diagramă) - Explorarea datelor dintr-un tabel prin sortare și filtrare (se filtrează cu opțiuni de la Text/Number Filters) - Realizarea a minim un tabel cu subtotaluri sau ...

Dezvoltare Aplicatie Excel/VBA prin dezvoltarea unor module noi conectabile la aplicatia deja existenta. Aplicatia in cauza gestioneaza activitatea de comenzi, pregatire, expediere si facturare marfa, intr-o companie mica.

I am Shubheem here given to you work Dezvoltare aplixatie -Excel- VBA pentru optimizarea, activitatii ,depozitare,gestiune see transport here work is Vrem sa optimizam si sa dezvoltam in continuare o aplicatie pe care of folosim pentru optimizarea activitatii in firma

Vrem sa optimizam si sa dezvoltam in continuare o aplicatie pe care o folosim pentru optimizarea activitatii in firma. Avem de nevoie de o persoana cu cunostinte de programare VBA . Aplicatia pe care o folosim lucreaza in tandem cu aplicatia WinMentor asa ca sunt necesare si anumite cunostinte despre acesta din urma.

Vreau sa creez o funcție (VBA) care sa convertească un fișier txt în Excel la apasarea unui buton. (function)In acelasi timp sa se poata Introduce manual calea de unde se ia fisierul txt respectiv, unde va pune fisierul excel, anumite informatii adaugate manual. Am anexat mai jos cum arata fisierele text (2 tipuri de format) si de asemenea cum trebuie sa arate pentru fiecare (example 1 si 2).

Buna ziua. Am un proiect personal, care implica realizarea unui tabel excel complex, (1000linii) si as dori sa filtrez aceste date, conform cerintelor mele. Se vor folosi macros si vba, deci am nevoie de cineva care chiar stie sa lucreze in excel. Cei care stiti sa faceti o comparare intre doua coloane, dar asemanarea sa fie de 85%, puteti sa ma contactati.

Salut Sergiu, Am gasit profilul tau pe Freelancer si am vazut la sectiunea Skills ca stii VBA si Excel. Am un proiect despre care as vrea sa discut cu tine. Ma poti contacta la adresa de email @

Buna ziua. Am un proiect personal, care implica realizarea unui tabel excel complex, (1000linii) si as dori sa filtrez aceste date, conform cerintelor mele. Se vor folosi macros si vba, deci am nevoie de cineva care chiar stie sa lucreze in excel. Cei care stiti sa faceti o comparare intre doua coloane, dar asemanarea sa fie de 85% ca si caractere, puteti sa ma contactati.

cod vba excel , sa copii valoare din pagina 2 in pagina 1 cu indeplinirea 3 criteri , vezi imaginele atasate

Am nevoie de cineva care sa ma ajute sa transcriu o problema de mecanica in VBA. Multumesc.

ENGLISH: (I need it by May 27th, end of day GMT) I would need a tablespace with 6-7 tables: - with some alternative and repetitive structures; - treating some exceptions (implicit and explicit); - 3-4 functions, 2-3 procedures and including them in packages - 2-3 triggers; - a small application in APEX with about 4 different pages. ROMANIAN: (Am nevoie de el pana cel tarziu Miercuri, 27 May) Criterii minime: A. Descrierea problemei şi prezentarea schemei conceptuale a tabelelor. B. Interacţiunea cu serverul Oracle prin intermediul comenzilor SQL (LDD şi LMD) C. Structuri alternative şi repetitive. D. Tratarea excepţiilor. (minim 2 implicite, 2 explicite) E. Gestionarea cursorilor: impliciţi şi expliciţi (cu şi fără parametri) F. Funcţii, proceduri, includerea aces...

...cameras, software, gaming, electronics (3 products per category with photos, details and price) Clients should have a client account in which they can manage their history order The admin should be able to : Add/modify/delete photos Manage orders through changing the status order from "in process" to "delivered" Manage stocks Generate reports (aproximatively 20) Data base- at least 10-20 tables or how many are possible ...

Only Romanian developers can apply. Please do not apply if you are not from Romania. Site responsive (wordpress sau custom made code) de prezentare pentru diverse magazine. Sunt necesare cunostiinte despre: baze de date, folosirea datelor din baza de date in paginile de prezentare, tabele cu filtre bazate pe baza de date, nested tables, html5, richsnippets, rating system, cat mai putin CSS, valid markup, SEO module, permisiuni admin, sitemap etc etc. Am enumerat o parte din cele necesare, pentru o idee de ansamblu. Documentatia tehnica (+20 pagini) este pregatita, va fi distribuita in private celor selectati. Presupune colaborarea prin Skype, date fiind cerintele detaliate. Recomandat pentru echipa de IT - luand in considerare ca este nevoie si de design.

Only Romanian developers can apply. Please do not apply if you are not from Romania. Site responsive (wordpress sau custom made code) de prezentare pentru diverse magazine. Sunt necesare cunostiinte despre: baze de date, folosirea datelor din baza de date in paginile de prezentare, tabele cu filtre bazate pe baza de date, nested tables, html5, richsnippets, rating system, cat mai putin CSS, valid markup, SEO module, permisiuni admin, sitemap etc etc. Am enumerat o parte din cele necesare, pentru o idee de ansamblu. Documentatia tehnica (+20 pagini) este pregatita, va fi distribuita in private celor selectati. Presupune colaborarea prin Skype, date fiind cerintele detaliate. Recomandat pentru echipa de IT - luand in considerare ca este nevoie si de design.

Am un proiect neterminat, am nevoie de cineva care stie VBA Excel sa il poata incheia. Liciteaza doar daca ai experienta in VBA, proiectul nu este chiar usor de inteles si realizat, pentru cine are experienta insa dureaza f putin de incheiat.

te rog sa ma anunti daca esti disponibil in a ma ajuta intr-un project excel vba. e un singur elgoritm de corectat. chstie de cateva minute. mersi

Am nevoie de ajutorul tau pentru o eroare.

Am un proiect aproape terminat si abandonat. Nu este foarte amplu, Am nevoie de cineva care il poate incheia. Este in Excel VBA si voi trimite specificatii pe mail celui interesat. Multumesc!

Locatia de realizare a proiectului: Brasov la sediu firmei Consultanta si suport pentru: Migrare aplicatie realizata din VBA in C# Migrare de la lucru cu tabele excel la tabele Access si SQL Realizare Interfata Profesionala in C# Realizare legatura intre Interfata relaizata in C# si tabele realizate in Access sau SQL Realizare strucura logica de organizare interna a datelelor din tabelele in Cccess sau SQL Relizarea "Relationships" intre tabele in access Teste

Pot completa tabele in excel (cu formule de calcul )sau scrie in word, preferabil in romana,engleza sau italiana. De asemenea, pot face diverse situatii in excel...depinde ce doreste fiecare. Can fill tables in Excel (with formulas) or write in Word, preferably in Romanian, English or Italian. They can also make various situations in excel ... depends on what each wants.

Hi Kusmin K., I am trying to typeset a book on hajj but i need your help to setup a table settings at 90 degrees sideways because the page size is very small. Also i need help to setup a factbox. Also for some reason whenever i create a new text frame , there is a dark background and a dashed border . I just need help with the tables and the factboxes. and i will do the tepseting myself.

I'm seeking a professional with extensive experience and expertise in APA (7th Edition) formatting to assist with my assignment. The project is a case study and requires a meticulous eye for detail. For successful completion of this task, the chosen freelancer will be expected to: - Format the Title and Abstract - Format the Main Body including tables, figures, and referencing, all in keeping with the APA 7th edition guidelines. - Format Appendices and References The requirement is for an immaculate output that aligns seamlessly with APA 7th Edition specifications. Therefore, a deep understanding and experience of academic writing and formatting standards is essential. The paper must be polished and generally free of errors in mechanics, spelling, usage, and sentence struc...

I'm seeking an expert in .NET framework for a project that involves setting up a multi-tenant database. My preference is to have a separate database for each tenant, with the databases themselves being simple and containing only a few tables. Key Responsibilities: - Develop a multi-tenant functionality in .NET entity framework - Implement a separate database for each tenant - Design a simple database with few tables Ideal Skills & Experience: - Extensive experience in .NET Framework - Proven expertise in multi-tenant database setup - Proficiency in designing simple databases

...be to rigorously test the relationships between the variables I've collected data on, as well as assess the moderation effect. - Report Writing: I expect a comprehensive and detailed report of the hypothesis testing results. The report should be clear, well-structured, and easy to understand, as the results will be crucial for my research. I also want the statistical results from the software (tables) and dataset. Ideal Skills and Experience: - Proficient in Structural Equation Modelling (SEM) and SmartPLS: It's essential that you have a deep understanding of SEM and specifically experience using SmartPLS, as this is the software we'll be using to conduct the analysis. - Strong Statistical Background: Sound knowledge of hypothesis testing and moderation analysi...

I need a wordpress plugin with a custom backend (API) The plugin is bascially a step by step registration form. Form must be made responsive. Data must be saved in seperate tables not in wordpress. The form must be a step by step form, with the design and colour i will show. Partical data must be encrypted into the database using non reversal encryption. I will explain more into details for the right coder.

I'm seeking a skilled developer to create a website where users can generate customized Excel tables. Below are the key project requirements: Key Functions: - The website should allow users to generate customized Excel tables based on specified criteria such as user input, date range, and data filters. - Implement a user registration and login system to secure user data and table generation history. - Incorporate export options to enable users to download the Excel tables they generate. AI-driven Automation System: - It's important that the system integrates an AI-driven automation system. This will streamline the table generation process while providing accurate and efficient results. Subscription Offering: - The system should offer a subscription model w...

...some moderate data analysis in Excel. PowerPoint: - Your role will be to make my content visually engaging through simple transitions and animations. - Creativity and a good eye for design are essential to make the presentation impactful for the audience. Excel: - You will also be tasked with handling moderate levels of data analysis and visualization. - I will require you to work with pivot tables, conditional formatting, and possibly other mid-level Excel skills. Ideal Skills: - Proficient in PowerPoint with a strong design sense. - Comfortable working with Excel and able to handle moderate data analysis tasks. - Excellent communication skills to understand and translate my content into engaging visuals. - Organizational and time management skills to deliver the...

...should also be optimized to assess strategy effectiveness and make necessary adjustments while trading. Strategy uses pivot points - the pivot points highlight a certain candle, specifically the high and low of that candle.

 A box is then drawn from that high and low of the candle all the way to the right until price trades back into it, then box stops and trades are entered. In a short trade for example with a risk/rewards set at 1:1, when price comes up to the low of that box we would enter short and the stop loss would be the high of the box and the take profit would be equal to the size of the box, but down. So if the candle which defines the Low and high of the pivot/ box is 10ticks in size from high to low then when we exit that trade the take profit wou...

I'm seeking an expert in Flutter and Firebase to develop a robust restaurant management app. The desired application will incorporate features for order management, table reservations, and menu displays. Key Features: 1. **Order Management:** This function will allow users to manage customers' orders easily. 2. **Table Reservations:** Users should be able to reserve tables via the app. 3. **Menu:** To enable customers to view different meals and their prices, the app will need a menu feature. System Integration: The app needs to seamlessly integrate with a POS system and an online reservation system. Your experience in API integration is desirable. User Roles: The app should support multiple user roles to accommodate administrators, managers, and waitstaff. Each role w...

I'm looking for a competent draftsman to assist in the creation of technical drawings for different pieces of residential furniture. This includes beds and wardrobes, tables and chairs, as well as cabinets and shelves. Although we have not finalized on a specific style or design as yet, the draftsman needs to be versatile and capable of adapting to changes. Ideal Skills and Experience: - Proven experience in drafting residential furniture - Proficiency in CAD or similar drafting software - Strong attention to detail and understanding of construction methodologies - Ability to translate design ideas into technical plans - Proactive communication

...responsible for designing the space. This involves arranging furniture, selecting wall materials, deciding on color schemes, and any other design elements necessary to create a cohesive and functional interior. 3. **"WITH AVAILABLE RESOURCES THAT I HAVE IN MY FURNITURE SHOP"**: The design should incorporate furniture and other items available in my furniture shop. This could include sofas, chairs, tables, lighting fixtures, and other furnishings. 4. **"AND WALL MATERIAL LIKE LOUVERE CHANNEL, PVC ETC"**: The design should also utilize available wall materials such as louvre channel, PVC panels, or any other materials we have in stock. These materials can be used for wall coverings, partitions, or other decorative elements. 5. **"OR IF ANY WALLPAPER DESI...

I need an expert to proofread a 200-page document intended for consulting in the Law Enforcement area of Public Safety. The task involves: - Correcting spelling and grammar, - Ensuring the logical flow and consistency of the narrative, - Checking alignment with charts, figures, tables, maps, and other visual aids. The ideal freelancer should have: - Exceptional English communication skills, - Strong attention to detail, - Experience in Law Enforcement or Public Safety consulting, - Familiarity with proofreading educational and research materials. This is a valuable opportunity to polish a crucial document that aids in developing efficient and effective public safety practices.

On our Django project, we're in need of a skilled professional that can help with small tasks improving the existing Django based Customer Register back-end solution and front-end - Frontend Development with Minimalistic Design: Some small form, text etc changes. - Database Management: Some new fields and tables must be added to register. - Django REST Framework Integration and API Development, we are interested in having REST based API on our Register back-end to have more flexible front-emd development. So wondering if "Django REST Framework" is the right one. So , we're looking for a Django specialist with deep understanding of frontend development, database design, and REST frameworks. The ideal candidate must have a keen eye for minimalist design, an i...

I need a diligent individual to assist with meticulous data entry into less than 25 tables and slides. The data to be entered is a combination of text and numerical data which I will send. Ideal freelancer will have: - Proficiency in data entry with strong attention to detail - Proficient use of PowerPoint Your primary task will be to enter data and headings into already-created table/slide templates. Typical table will have three columns and 3-5 rows. See attached examples. Successful completion of this task requires precision and accuracy to ensure the information is captured correctly.

I am looking for a full stack web developer to create a Network Management System (NMS) website that can be deployed on any cloud or local hosting. Main Functionalities: 1. Loginpage login (create user/password in the backend) 2. Dashbord one - prints rows of a table (buttons to add/delete/update table rows) 3. Dashboard two will have 6 tables, each of the table entries will have few configurable(will be configured through pop up window) , stats, logs , status 4. One of the table could have a flow table just for read only 5. THere should be back end persistent DB which saves all the data 6. THere should be method to bring down this and powered back any time Acceptance criteria 1. NDA signing 2. Web page working conditions and exceptions taken care on AWS/

Înregistrează-te sau Conectează-te pentru a vedea detaliile.

Înregistrează-te sau Conectează-te pentru a vedea detaliile.

...skilled graphic designer with experience in creating compelling training materials. We are hosting a workshop geared toward holistic well-being, catering to a general audience with a focus on spiritual development. We have a book that will serve as the foundation for the content of the workshop. What We Need: - Creative layouts and designs for the whole set of workshop materials which include: workbook, slides, trainer script, exercises, handouts, and training guidelines. - Graphics that can engage adults in learning and meditative practices. Ideal skills and experience: - Graphic design experience specifically in creating educational/training content. - Knowledge or interest in topics like holistic well-being, meditation, mindfulness, and self-reflection. - Strong understandi...

...stock alert mechanisms to notify users when inventory levels fall below a certain threshold. - Alerts can be sent via email, SMS, or displayed within the software dashboard. This software solution would require a database backend to store all relevant data and a user-friendly interface for easy interaction. You could develop it using Microsoft Access, incorporating forms, queries, reports, and VBA (Visual Basic for Applications) for automation and customization. Consider consulting with stakeholders and users throughout the development process to ensure the software meets their specific needs and requirements. Additionally, thorough testing and refinement will be crucial to ensure the software operates smoothly in real-world scenarios. Key Features and Requirements: - Strea...

...necesitará conocer varios aspectos: Conocimientos básicos de Excel: Deben estar familiarizados con las funciones básicas de Excel, como la creación de hojas de cálculo, el formato de celdas, la creación de fórmulas, etc. Macros en Excel: Deben comprender qué son las macros en Excel y cómo funcionan. Esto incluye la capacidad de grabar y editar macros, así como comprender el lenguaje de programación VBA (Visual Basic for Applications) utilizado para escribir y modificar código de macros. Requisitos del documento: Deben comprender claramente los requisitos y objetivos del documento de Excel que se está creando, incluyendo las funciones específicas que se espera que realice y los datos...

I am seeking a professional writer who can produce business report writing samples and blogs. The specific topics and industries are not yet confirmed, so your ability to pivot and adapt to a wide range of subjects is essential. The volume of required content is also still to be determined. The target audience could be anyone from executives to students to entrepreneurs, so the writing must be versatile and engaging to a broad spectrum of readers. - Skill Set: Excellent research skills, adaptability, versatility in writing, ability to write for a diverse audience - Experience: Proven experience in business report writing and blogging, ideally across multiple industries.

We require a professionally typeset document using Microsoft Word to give it a polished appearance. Please use British English, for example, change "analyze" to "analyse...polished appearance. Please use British English, for example, change "analyze" to "analyse". Kindly use track changes to highlight any modifications made. We prefer not to make any edits except a glossary of terms, an index, and an FAQ section. Additionally, please ensure that the cited references are numbered appropriately. Convert the "Risk Analysis" section into an editable table. Make sure that Tables in Appendix 1, 2 & 3 have a professional appearance. Please use multi-level numbering. Don't forget to number the pictures. If possible, include a glossary ...

Hi. I need help to setup the binding for a RichTextBox .NET Control so that data is retained. There may be use of VBA that is needed. This is within a FactoryTalk View SE version 14 application. I don't know .NET or VBA, I am a FactoryTalk guy though. Example use case: Lets say a factory has 100 valves. If a user opens popup for Valve #3, I need a text box field in that popup for the user to enter data, and then data is preserved/saved. That popup should be one common FTV display that references the Valve_# that was selected (using parameter files, or...). This example is the main objective. I need a simple and easy solution to this, and I need to understand how to do it myself afterwards. This is perhaps a 1 hour job. My name is Marc. I'm ready to s...

I need a Python expert to scrape tabular data from a series of PDFs and store it in a database. Ideal Skills and Experience: - Proficiency in Python. - Strong experience in web scraping with PDFs. - Familiarity with database management. The PDFs are consistent in format and all contain tables. The scraped data needs to be stored in a database.

I am in need of a skilled individual who can meticulously extract table data from approximately 7500 pages of PDF files and transfer the data to Excel. The PDF tables are consistent across all pages, maintaining a fixed column structure which you need to duplicate in the Excel spreadsheets. The data you will be working with is primarily text-based as opposed to numerical. Necessary Skills and Experience: - Excellent attention to detail - Proficiency in optical character recognition (OCR) processing - Experience with data scraping or extraction - Valuable skills in MS Excel - Familiarity or experience with PDF data extraction software Swift and accurate execution is essential for the successful completion of this project. Please only apply if you are comfortable handling a high vo...

...website that needs fine-tuning, I am in dire need of a developer with top-tier skills in Reactjs and MUI to rectify several issues and implement updates across the site. Key elements of the project include: - Fixing inconsistent layout and spacing issues present throughout the entire website. - Enhancing the design by making more consistent use of grids for content arrangement. - Improve tables. - Improve form controls. The ideal candidate has significant experience in working with layout designs, from analyzing potential issues to implementing solutions that have a noticeable impact. Your ability to improve usability and, thus, user experience, is essential. This project may require detailed reviews of website features, so a keen attention to detail is a plus. S...

...Style and visibility should be similar to trading view indicators. indicators name are follows- Moving Average (MA) Exponential Moving Average (EMA) Relative Strength Index (RSI) Moving Average Convergence Divergence (MACD) Bollinger Bands Stochastic Oscillator Fibonacci Retracement Ichimoku Cloud Average Directional Index (ADX) Parabolic SAR Volume Weighted Average Price (VWAP) Pivot Points Aroon Indicator Williams %R Chaikin Money Flow (CMF) On-Balance Volume (OBV) Average True Range (ATR) Commodity Channel Index (CCI) Accelerator Oscillator Alligator Indicator Force Index Standard Deviation Money Flow Index (MFI) SuperTrend Indicator Trix Indicator Keltner Channels Hull Moving Average (HMA) Donchian Channels Triple Exponential Moving Average (TE...