Vba workbook pivot tables jobs

I am looking for a skilled professional who can hel...optimization techniques, custom queries and data retrieval. - Workflow management in Airflow: Custom workflow automation and scheduling tasks. - Data storage and manipulation in S3 and Hadoop: Support for large-scale data storage and processing. - Container orchestration in Kubernetes: Assistance with container deployment and scaling. Specifically, the ideal candidate should be able to set up tables on Iceberg in Parquet format. They should possess in-depth knowledge of these technologies and be able to seamlessly navigate through the intricacies of integrating them to ensure the smooth operation of our data processing and workflow management systems. Do you have the skills and experience I need? I'm looking forward to he...

I am in need of an efficient professional who can convert my mixed content PDF document into a Word document, while retaining the same format and layout as present in the original document. The PDF primarily contains text content only, so expertise in handling complex content like mathematical equations, charts or tables is not a requirement. The ideal freelancer for this job should: - Be proficient in PDF and Word processing tools - Have strong attention to detail to ensure layout fidelity - Have experience in similar document conversion tasks

I'm looking for an expert in VBA and macros to help streamline my processes in Excel. Key Requirements: Shifts: Defined two shifts in the "task tap": Morning: 6:00 to 15:30 Afternoon: 14:00 to 22:30 Quality: Updated the agreed-upon columns in the "quality tap." And remove the error code if there is no any number Delays: Ensured delays are reflected as discussed. Task Order: Arranged tasks in the "task tap" from oldest to newest. Please review the file and let me know if you have any questions or require further changes. Requirements: 1- Required an option in this file (Excel) that when the planner change the completion date of any task in column K in the TASKS tap, the color of the cell will be changed to yellow, and a not...

...with text, fillable fields and tables with fillable fields, and I'm looking for a professional who can show me a way to easily render / convert the contents into HTML. The purpose of this conversion is to be able to convert many forms into HTML so we can post them on an internal website for the forms to be filled out. Key Requirements: - Converting PDF content to HTML without compromising quality or format from the original document - Ensuring that ALMOST all text, and tables are accurately transferred. It doesn't have to be perfect but excellent and close - Compatibility with desktop devices Ideal Candidate: - Proven experience in PDF to HTML conversion, especially for documents with mixed content - Ability to accurately handle text, images, and ...

...array that contains objects. - It should have functionalities to not only add new objects but also modify or delete the existing ones. Desired Interface: - I desire a table-based editing interface where each cell is editable and represents an object property. Ideal Skills & Experience: - A thorough understanding and expertise in Vue 2.6. - Previous experience in creating and managing editable tables. - An adept knowledge of JavaScript and array manipulations. Appreciate bid from Vue.js experts who understand my requirements and can deliver a clean, user-friendly editable table element. "POSITIONS": [ { "ITEM": "Positions", "DATA": "Vice President for Research, MUSC", "DATE&qu...

I'm looking to embed an amortization Calculator within our Accounts Module in Zoho CRM. We would like it to function exactly like this example. We would like the results of the calculator, including the amortization schedule, to be added to feild/tables within the account module of zoho Crm. Can anyone help? We are zoho one subscribers.

It is necessary finish a project managemet application made in laravel. The change are: - make some change regard the flow, the links, the design, the ecommerce and report; - It is necessary experience in query, report charts, pivot builder and Business intelligence to change the reports that must have good design, many filter and cross. the charts must have drill down. Please answer only if have experiences in project management software and pivot-query-busienss intellegence. And show my the url of similar job made.

I'm looking to hire someone who can create an Excel VBA workbook to seamlessly integrate with my Zoho Desk setup. This workbook should be specifically engineered to perform the following: - Retrieve the required information from Zoho Desk tickets upon pressing a button inside Excel. Specifically, I need someone skilled in Excel VBA programming and API integration work to: - Design a user-friendly interface in the workbook where one can press a button to initiate the retrieval of ticket information. You should be able to retrieve the latest ticket, and then have two more buttons to go to next & previous tickets. - Implement secure API connections to Zoho Desk to enable the retrieval of ticket information usuing oauth. The fields I need are: Su...

I'm in need of an experienced Excel professional to help me build a secure data management system. This system will be used to handle both financial and customer information. Key Requirements: - **Data Security**: A robust system that...customer data. - **User Management**: The system should be designed for 1-10 users, allowing them to access and input data securely. - **User Experience**: While the users are expected to have advanced Excel skills, the system should be designed with clear interfaces and user-friendly features. Ideal Candidate: - Proven experience in designing secure data management systems in Excel - Proficiency in VBA and Excel's advanced features - Strong understanding of data security and privacy - Excellent communication skills to understand and mee...

Hi ART LAND DESIGN, I would like to hire you to make an environmental render with our tables and the blue chair with a yellow wire frame to represent school colors. We would like the render to be of a university cafeteria, similar to these pictures I attached on the chat.

Hi ART LAND DESIGN, I would like to hire you to create 9 table renders for me. 3 square tables, walnut veneer, maple butcher block, mushroom laminate, 3 round tables, maple veneer, walnut butcherblock, black laminate, and 3 rectangle tables, red oak veneer, cherry butcher block, and calcutta marble laminate. I would like them all standard height with the black base that I provided a picture for. No shadows, white background.

Description: We are seeking a proficient indiv...Manager. Requirements: Experience: Prior experience in data collection projects, especially via WhatsApp/SMS channels, is preferred. Accuracy: Attention to detail is crucial to ensure accurate data collection. Timeliness: Meeting deadlines and adhering to the project timeline is essential. Deliverables: Structured collection of raw data for the data points mentioned above in a specific format as tables Organized documentation of collected artifacts (pictures of classrooms). If you have the necessary skills and experience to undertake this project efficiently, please submit your proposal outlining your approach, relevant experience, and expected timeline. We look forward to collaborating with you to ensure the success of our Pi Lab...

...purposes Key Responsibilities: -Acquiring the domain (we have specific name in mind) -Recommending hosting provider for our approval -Setting up hosting after selection gets approved -Installing Wordpress -Setting up the website in Wordpress (should look like ) Content structure: -Main Page -Three subpages - 3 categories - SUV, Electric, Compact - Subpages in the form of tables (rankings) of popular car brands with a link to the manufacturer's website, according to provided lists -Implementing multi-language support: two languages supported initially, Polish and English -Implementing Google Analytics and GTM -Setting up events and conversions, according to provided requirements -Documented manual testing of events and conversions on Chrome and Safari, on both...

I'm looking for an experienced VBA coder who can focus on two main tasks. 1. **Fixing Existing Issues:** - My current VBA code has issues with execution errors and incorrect results. I need solutions to these two problems. 2. **Adding Modifications:** - I'm looking for someone who can add additional features to my existing VBA code. - Good user experience is important too so improvements on the user interface would be very beneficial. Ideal candidates will have an excellent understanding of VBA syntax, debugging, and error handling. Experience with user interface design is also appreciated. The aim here is to produce accurate calculations, formatted data or reports swiftly and easily.

I'm in need of a Pivot table in Excel to analyze my sales data. This will help me track and understand key metrics like units sold and profit margins. Key Project Details: - Data: Primarily sales data - Metrics: Primarily interested in tracking units sold and profit margins - Organization: The data should be organized by product and region Ideal Skills & Experience: - Advanced Excel proficiency, particularly with Pivot Tables - Strong analytical skills for identifying key metrics - Experience working with sales data is a plus - Ability to understand and visualize data in a meaningful way.

I need a freelancer to help convert my scanned PDF document into Excel format. The Excel should have the same layout as the original document in the PDF: - Expert in scanned document con...original document in the PDF: - Expert in scanned document conversion to Excel is required as the document isn't text-based. - Advanced knowledge in layout replication is necessary because the converted Excel file needs to have the same structure as the original PDF. - Since the PDF contains unknown special data types, ability to deal with potential complexities (like images, graphs, complex tables) would be a plus. The ideal freelancer for this project should have a proven track record in PDF to Excel conversions and dealing with scanned documents. Bonus points for experience with comp...

It is necessary finish a project managemet application made in laravel. The change are: - make some change regard the flow, the links, the design, the ecommerce and report; - It is necessary experience in query, report charts, pivot builder and Business intelligence to change the reports that must have good design, many filter and cross. the charts must have drill down. Please answer only if have experiences in project management software and pivot-query-busienss intellegence. And show my the url of similar job made.

I need a simple ...expired then navigate to page where there is no menu options only a simple page requesting to upload a file. Once uploaded redirects user to login page and show all menu options. User should not be able to navigate to any page by entering URL manually, if license is not valid. Attached project is running with login and registration. You can execute the Migration script to create Microsoft Identity tables. In the app settings file change the database connection string. The attached project currently takes user to Login screen on load. Now I want to add license service as check before going to login and only take user to Login if License service returns true. For this project you can just return true and false to reflect both scenarios when license is valid and ...

Hi Akriti, As promised, here is the new spreadsheet for the Jan-Mar 2024 pivot tables at the $30 you suggested. Could you double check there's no data in the hidden rows ... somehow we couldn't unhide them :-) thanks, Omer

Phase 2 project: I'm looking for a skilled developer to connect our custom API, which provides product inventory data, to our website. The task includes visualizing this data as a chart on the separate page. Key Requirements: - Connecting our API to the website - Displaying product inventory data - Creating interactive charts - Implementing dynamic tables Ideal Skills: - Proficient in API integration - Strong experience in data visualization - Knowledge of interactive chart libraries - Familiarity with dynamic table implementation Your role in this project will be pivotal in enhancing the user experience of our website, by making the product inventory data both visually appealing and easily digestible.

I am in need of a seasoned Microsoft Access developer to create a comprehensive database solution for my business needs. Key Project Details: - I require a robust database with more than 10 tables. - The database should feature data entry forms for easy information input. - It should have advanced error-checking capabilities to ensure data integrity. - Reporting and analytical functionalities are essential for tracking business performance and making informed decisions. Ideal Skills and Experience: - Proficiency in Microsoft Access and database design. - Strong track record of developing complex databases with user-friendly interfaces. - Experience in data validation, error checking, and report generation. - Excellent understanding of business processes and needs for effective ...

Hi, Looking for a designer to create a takeawa...takeaway menu in A2 size 10 panels using InDesign. The menu will be featuring mainly Turkish Cuisine and may need to incorporate specific branding or color schemes. The menu should include menu items, prices, and descriptions. Ideal skills for this job include proficiency in InDesign, experience in menu design, and an eye for branding and color schemes. The job needs to be completed using by Indesin tables mainly. A2 size and 10 panels. If the job is completed nicely, we are happy to give more work in future. Attached pictures just a sample, to show what kind of job needs to be done. End of the work i need all the raw indesign folder as Package (that should includes Document Fonts, Links , pictures .idml, .indd, pdf ) Thanks fo...

Hello! I am in search of a Glide App developer to help create a straightforward rental management system. This project will be developed in phases, allowing for gradual enhancement and integration of functionalities for managing assets and clients efficiently. Responsibilities: Develop and configure relationships between various data tables like assets and clients. Customize the user interface for intuitive use. Implement basic features for reporting and asset tracking. Ensure the app functions smoothly on different devices. Provide support with testing and debugging. Qualifications: Proven experience with Glide Apps, especially in setting up relational databases. Ability to design for user-friendliness. Capable of independent and collaborative w...

I'm seeking a proficient Excel VBA coder to create a system that automates data entry from Excel files. The task involves: - Creating a VBA function that can input data automatically into my current system. - Implementing a data sorting feature as part of the data entry process to ensure that all data is easily read and interpreted. The ideal freelancer should have the following skills and experience: - Proficiency in Excel VBA - Experience with automated data entry - A solid understanding of data sorting techniques. This project requires precision and attention to detail. It should not only meet the needs listed above but also enhance data accuracy and save time.

I'm in need of a proficient C# WPF developer with experience in creating dynamic user interfaces and implementing rigorous data validation rules. Your task would be to: - Develop a user-friendly interface with a modern and minimalistic design - Implement numerical data validation - Connect the system with an existing MySql database and create three new tables based on an existing description This is a very simple task, for which we preview a maximum of 6 hours working time. It's essential that you're comfortable working with MySql databases, and have a proven track record of creating visually appealing software with a focus on usability. Understanding the value of intuitive design and the importance of numerical data validation is also key. Past experience in deve...

Just a small 3 tables work, (Image, name and amount). API to pass the value

...limiting to prevent abuse and ensure security during OTP verification. JWT Authentication: Generate JWT tokens upon successful OTP verification for secure authentication between client apps and the server; Implement token-based authentication for subsequent API requests. Refer Code and Wallet Creation: Upon successful OTP verification, generate a unique referral code for each user; Create separate tables to manage user wallets, allowing users to perform transactions and manage their funds securely. Additional Requirements: Utilize Laravel 10 or 11 for development. Ensure the API endpoints are well-documented for seamless integration with client applications. Implement error handling and validation to enhance the security and reliability of the API. Adhere to best practices in ...

I have a digital PDF document containing a mix of numerical and textual data, meant for meeting diary maintenance. The task involves meticulous conversion of this document into a tabular format. Key requirements: - Proficiency in handling PDF documents and excel tables. - Understanding of the data categorization to create efficient tables. - Excellent attention to detail to ensure the accurate alignment of numerical and textual data as per the PDF. - Ability to deliver the project within a decided timeline. Ideal candidate: - Has experience converting PDFs to Excel or similar table formats. - Can handle mixed data (numerical and textual). - Excellent organizational skills for data arrangement. - Background in data management preferred but not mandatory. End goal: The c...

I'm seeking an experienced Excel VBA expert to help me automate some basic, repetitive data entry and formatting tasks. Key Requirements: - Automate basic data entry and formatting tasks in Excel - Develop VBA script to ensure automation runs smoothly Ideal Skills and Experience: - Proven experience in developing VBA scripts for Excel - Strong understanding of Excel functions and data formatting - Ability to create automation systems that run seamlessly without user interaction Please note, no user interaction is required for this project. The VBA program should be designed to run automatically once set up. This task is relatively simple but needs to be executed precisely and efficiently. Looking forward to working with a professional who can deliver ...

I'm seeking an expert in Excel and VBA who can work on an an existing financial model. The primary tasks will involve optimizing formulas, macros, and implementing data validation. I am looking for an hourly regular working engagement where the person will sit with me from time to time online and solve for things one at a time. I cant share workbooks as I have some IP related restrictions so person will have to work on my system, remotely. For Faridabad, Haryana based freelancers, we can do it in physical mode too. Key areas of focus will be: - Refining Formulas and Calculations. - Improving Data Organization and Management - Managing , improving the existing VBAs

As part of my Master's degree in linguistics, I urgently need a professional proofreader and editor to diligently review my academic paper. The paper, titled "The influence of learning a third language on interlanguage development : a systematic review," is 17,754 words in length and must adhere to APA 7th style guide. PS. Don't worry about the word length it's mostly tables. Key Requirements: - Expertise in academic proofreading and editing is a must. - Familiarity with APA style guide. The project has a tight deadline, with the work needing to be completed within a week. If you have the necessary skills and experience, I look forward to receiving your proposals.

...automating the transfer of information between those departments: linking the data, defining "trigger" events, and processing data from various inputs into "smart" trackers. I have a clear outline of what I want to accomplish - what data I need, who I need it from, and how I want the tracking of the inputs to function. My "coding" ability is a limited working-knowledge of JavaScript PDF and Excel VBA. I need someone to provide council and advise on what is possible, what tools or platform would be best for the end product I want to develop, and to advise on any alternatives. Basically, I am in the early stages of a long development process and I need an expert coder to review my outline and provide advise for the best way to accomplish what I want. ...

...specialist who can help me with a unique task. I need assistance with table extraction from financial scanned PDF Documents. The tables in these documents are complex, often containing merged cells and layouts that are more intricate than standard. Key Requirements: - Proficiency in OCR techniques, especially in relation to table extraction. - Experience working with scanned PDFs. - Ability to efficiently handle tables with merged cells or complex layouts. Your role will involve: - Utilizing OCR software to extract tables from scanned PDFs. - Ensuring the accuracy and completeness of the extracted data. - Solving any issues that may arise from the complexity of the tables. You need to be experienced in OCR and have a keen eye for detail to apply for this ...

I need a simple app developed using Microsoft Power Apps. This app will primarily serve as a data entry tool (and basic data analysis) for the employees in our organization. There are a few reference tables like Project, Category, Expense type, etc and then there is a main table called Expenses which has project, category, expense type, quantity, price as the columns. These tables are currently available as part of my azure SQL database but I am open to suggestions if you want to store this data differently. The main screen would show a list of projects on the left. The right section will show details like total expenses, expense per category chart of the selected project. Upon clicking inside the project you will see a list of expenses. This screen should have functionali...

Please Sign Up or Login to see details.

I'm looking for an google sheets / excel guru who can construct an advanced drop-down lookup system for my entire sheet. This system should include multiple variables that will inform the price from the database. Currently looking up values manually in a series of tables, tables may need reformatting to allow for efficient searching Key skills and experience: - Proficient in MS Excel Advanced Functions - Experience with both numerical and text data - Knowledge of creating drop-down lookups for entire sheets The final product should streamline our decision-making process by providing agile, accurate prices based on the selected variables. Your comprehensive understanding and application of numerical and text data within an Excel environment will be key to the success ...

I require a VBA Developer well-versed in automating repetitive tasks in Microsoft Excel. Your primary task is to automate my existing work functions to increase efficiency. Key Responsibilities: * Understand the current Excel operations and identify scope for improvement. * Develop VBA codes to automate basic standard operations. * Test the robustness and accuracy of the automation. * Combining 2 files into 1 pdf. 1st file is pdf and 2nd is excel(with selected sheets, and selected columns within sheets) Desired Skills & Experience: * Proficient in VBA, specifically for Microsoft Excel. * Experience in automating repetitive tasks. * Sharp problem-solving and debugging skills.

Seeking a proficient Excel VBA developer to aid in the centralization and automation of tasks in Excel 2010. Project requirements include: - Expertise in Excel latest version - Strong understanding of EXCEL VBA for automation purposes. Please note, specific tasks and functions to be automated in VBA have yet to be defined. Flexibility and broad knowledge in different Excel functions will be considered an asset.

I am looking for a professional with strong data entry skills to assist in transferring text data from digital documents into an excel sheet. The successful candidate should possess: - Reliable accuracy in typing - Fast typing speed (numeric keypad advantageous) - Proficiency in Excel (VLOOKUP, SUMIFS, Pivot Tables, etc.) - Able to interpret written information swiftly - Excellent attention to detail for proofreading entered data. This task will require someone with experience in handling large volumes of data entry, with absolute prioritization on maintaining the integrity and accuracy of the inputted data. Any previous involvement in similar projects handling text data is highly desirable. Understanding of and/or a background in just managing digital document data will...

I'm looking for a skilled and enthusiastic Nursery Teacher, specifically for the age group of 3-5 years old preschoolers. The main educational approach should pivot around musical instruments, precisely piano. Key Responsibilities: * Introduction and constructive teaching of the piano to preschoolers. * Creation of a fun, creative environment that supports play-based learning. * Foster social-emotional development through musical education. Skills & Experience Required: * Previous experience teaching piano to children. * Great versatility to translate music into a playful learning approach. * Background or strong understanding of child development, especially for preschool-aged children. * Past experience in nursery or music education is preferred. In summary, if you...

As part of my project, I'm searching for an adept mobile app developer who can build a social network app available for both iOS and Android. Key Requirements: - The pivot of the app is to enable social networking capabilities. - A crucial feature of the project involves designing and implementing robust User Profiles. Ideal Candidate: - You are proficient in both iOS and Android app development. - You have previous experience in creating engaging social networking platforms. - You're highly skilled at implementing user profile features, with a keen focus on UI and UX design. I look forward to your innovative ideas and potential collaborations on this exciting project.

I need a Word document created from a PDF file. This isn't a simple text extraction but requires keen attention to detail as the formatting of the original PDF must be maintained meticulously in the Word document. The PDF is mainly text, so you won't need to worry about handling complex elements like tables or graphs. Ideal candidates for this gig should have: - Proficiency in PDF and Word - Eye for detail to replicate exact formatting - Solid command of English and document formatting skills to ensure no loss of content or meaning in the conversion.

...be working with the Microsoft SQL server, experience is preferred but not essential to be an expert. Anyone with generic database experience (with different databases) can also apply. Skills already acquired from previously doing this work: - Understand database schema - understand database structures - create database tables based on bespoke requirements (training included) - Working with relatively large sets of data - has exporting skills into SQL - Excel and VBA, - Has experience in different querying languages - Proficient in Microsoft SQL Server Management Studio - Familiarity with Windows OS - Experience in handling multiple databases with SQL - Strong troubleshooting skills I currently manage over 11 databases via Microsoft SQL Server Management Studio, and ...

I'm seeking an expert in Excel and VBA who can work on an an existing financial model. The primary tasks will involve optimizing formulas, macros, and implementing data validation. I am looking for an hourly regular working engagement where the person will sit with me from time to time online and solve for things one at a time. I cant share workbooks as I have some IP related restrictions so person will have to work on my system, remotely. For Faridabad, Haryana based freelancers, we can do it in physical mode too. Key areas of focus will be: - Refining Formulas and Calculations. - Improving Data Organization and Management - Managing , improving the existing VBAs

...PHPSpreadsheet. My Excel data is not being imported correctly into MySQL as tables are not being created. Despite no error messages alerting me to these issues, the hiccup persists. Below is a more detailed description. After login, the user uploads 4 required and 2 optional Excel files on the dashboard page. The files are uploaded to an “upload” folder on the server and the file names and other info are stored in the “files” table of the mysql database. All of the above works with no problems. Once the actions above are complete, a button at the bottom of the dashboard page is activated. When the button is pressed, PHPSpreadsheet is used to move the data from the Excel files in the “upload” folder to tables in the database. This ...

Currently in need of a proficient freelancer for converting my book from PDF to Word format. As unsure if the final Word file should retain the formatting of the original PDF, passages in the book do not seem to need specific attention to detail like conversion of images, tables, graphs, etc. Ideal Skills and Experience: - Proficiency in PDF and Word. - High attention to detail. - Excellent command of the English language. - Prior experience in book or similar document conversions. Please bid if you have the experience and skills to undertake this project.

I’m looking for an expert with MySQL skills to help me write a query or script. This task involves calculating the sum of items across three tables.. The complexity lies in filtering the said items between a certain date range and by a specific field value. Ideal Skills & Experience: • Proficient in writing SQL queries • Knowledge on MySQL, specifically on data manipulation among multiple tables • Excellent understanding of database design and principles • Problem solving ability to handle complex programming scenarios. Please note, I didn't provide the names of the fields to be summed in each table. So, the chosen freelancer will need to work with me and understand the complex structure of my database in order to pull this off. Therefore ...

I'm looking for a skilled individual who can create a pivot dashboard for my business. This dashboard needs to be updated daily and needs to include comprehensive sales data, material costs, labour costs, and profit and loss. Ideal Skills: - Data management - Ability to create and maintain pivot dashboards - An in-depth understanding of business financials. The main users of this dashboard will be the Management Team. Therefore, it needs to be designed in a user-friendly manner and should meet the needs of a strategic managerial perspective. The ultimate goal is to help us make more informed and data-driven decisions. Your expertise in data handling and visualization is much needed for this project. If you've created similar dashboards in the past, we would l...

I need a knowledgeable Excel VBA specialist, with a background in data manipulation and analysis, to create a custom macro for my spreadsheet. - The macro's primary function is to automate the creation of new rows based on certain numeric values, namely the ones found in columns E to L on a specific sheet in the workbook. - Upon row creation, data from columns A to D should be copied over to the corresponding new row on another sheet. - Additionally, the macro should automate the assignment of values in cells from L to Q based on the count of numbers in rows created. The assignment of values is to be done using a simple addition or subtraction formula. The ideal freelancer should have solid experience in creating advanced Excel VBA macros, and a strong unders...

...experienced MS Access developer to assist with my form development tasks. The ideal candidate is proficient in VBA (Visual Basic for Applications) coding and has the ability to design and implement forms based on my specifications. Key Responsibilities: - Designing and developing database structures based on my project requirements - Implementing VBA code for basic functionalities such as form submissions and data entry automation - Creating forms in MS Access based on a specific design I have in mind - Ensuring the database and forms meet quality standards and are user-friendly Ideal Skills and Experience: - Proven experience in database design and development using MS Access - Proficiency in VBA coding, particularly for basic functionalities - Previous experienc...