Excel vba combine dataKazi
Neme Deepak kumar s/o bhagwan das vill saraiya bhood post araul kanpur nagar
i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry ...
hi hi hi hi hi hi h h h h h h h h h h h h h h h h h h h h h a sakjsa ;ls dsaj slk s sdskssd sj skskl
I'm in need of a professional who can create a Classified Balance Sheet in Excel for internal review purposes. The balance sheet should be comprehensive and include the following sections: - Assets and Liabilities - Current and Non-Current - Equity The ideal freelancer for this project should have extensive experience in Excel, finance, and balance sheet preparation. The ability to present complex financial data in a clear, understandable manner is crucial.
I need help with data entry into my CRM system. The data consists of customer contact information, which is currently stored in Excel spreadsheets. Please note that the specific CRM system has not yet been determined, so flexibility and adaptability are key for this project. Ideal Skills: - Proficient in data entry - Familiarity with various CRM systems - Strong attention to detail - Excellent knowledge of Excel - Good understanding of customer contact information
I'm looking for an Excel expert to create a comprehensive workbook for analyzing our sales data. The primary purpose of this Excel book will be to aid in sales forecasting. Key Requirements: - Design and build an Excel workbook tailored for in-depth sales data analysis - Incorporate advanced Excel functions and techniques for accurate sales forecasting - Ensure user-friendly layout and functionality for office use Ideal Skills and Experience: - Proficient in Excel with a strong background in data analysis - Experience in creating tools for sales forecasting - Able to present complex data in a user-friendly manner
I need help with extracting text from a PDF document and organizing it into specific columns in an Excel spreadsheet. The task involves: - Text extraction: Pulling relevant text from a PDF file - Data organization: Sorting this text into designated columns in an Excel spreadsheet. The ideal freelancer for this project should have experience in data entry, particularly with PDF to Excel conversions. Attention to detail is crucial as the data needs to be accurately placed into specific columns.
...to guide me through analyzing data in Excel in a structured and professional way. My goal is to improve my Excel proficiency and learn practical techniques while working on my existing data. What I Have: • An Excel sheet with data ready for analysis. • Basic knowledge of Excel. What I Need: • A professional to guide me step by step in: • Data cleaning and preparation. • Using advanced formulas and functions. • Creating pivot tables and charts. • Analyzing trends and insights. • Other relevant professional techniques based on my data. Requirements: • Expert-level proficiency in Microsoft Excel. • Ability to teach and explain concepts clearly and patiently. ...
...decisions by local health departments (LHDs). I have multiple datasets that need to be cleaned, merged, and prepared for statistical analysis. I would be looking for: Data Cleaning: Remove duplicates and inconsistencies. Handle missing data appropriately (e.g., imputation, removal based on criteria). Standardize variable names and formats across datasets. Possibly collecting the data for me if there is any missing from data files I have. Data Merging: Combine datasets from multiple sources (e.g., 2016 and 2019 NACCHO Profile Studies, socioeconomic data). Use shared identifiers (e.g., zip codes, county names) to match data accurately. Resolve mismatched or ambiguous records during the merging process. Variable Development: Cr...
Position Summary: We are looking for a rigorous and competent data entry professional to ensure the entry, processing and management of data in our systems. The ideal candidate will be proficient in office tools such as Word, Excel, Google Sheets, and will also have skills in data security and the use of Adobe InDesign. Responsibilities: - Enter, verify and update data accurately in databases or documents. - Organize and structure files and databases for optimal accessibility. - Use tools such as Microsoft Word, Excel, and Google Sheets for data management. - Respect data security protocols to guarantee the confidentiality and integrity of information. - Create or modify graphic documents and media using Adobe In...
I'm in need of a s...thorough skip tracing. Currently, my focus is on six counties in my state: St. Louis City, St. Louis County, Lincoln County, Jefferson County, and Warren County. However, as my business expands, so will the scope of this project. This is an ongoing opportunity, with added cash bonuses for quality work. The data I require for each lead includes: - Name and last known address - Phone number and email - Property details and foreclosure status - Date of foreclosure All leads must be delivered in an Excel spreadsheet. Accuracy is paramount, and I'm looking for someone who can grow with my company. Ideal skills for this job include: - Proficiency in skip tracing - Experience with mortgage foreclosure overages - Exceptional attention to detail - Abil...
We currently use MS Fabric to house Procore analytics; however, bidboard does not have analytics and we must download an excel file. I'd like to set up a Lakehouse to manually import these excel files and then give our data analyst access to query the information. As a bonus it would be nice to be able to set up this information to share with Salesforce. This would be our first bit of outside data that we would be able to collaborate with our Procore data so I'd like some help setting it up correctly the first time. I'd also like to set it up with the Powerbi model so that when we add a new excel file it removes duplicates and I am able to slice by month, quarter, year. and custom date range.
I'm looking for a financial tracking solution that automatically links and consolidates my expenses from my credit cards and bank accounts...financial tracking solution that automatically links and consolidates my expenses from my credit cards and bank accounts in both Argentina and the USA into a single Excel sheet or similar. Key Requirements: - Automatic linkage of all my checking, credit card and savings accounts. - Consolidation of expenses into a clear, comprehensible format. - Support for specific banks from Argentina and the USA. Ideal Skills and Experience: - Proficient in financial software and Excel. - Experience with linking bank accounts and credit cards for expense tracking. - Knowledge of specific Argentine and USA banks. - Ability to present data...
I need assistance with my Excel VBA and Python integration. I can open a Colab Notebook from VBA, but I'm having trouble getting the code to execute automatically upon opening the Notebook. VBA-code: Sub StartColabScript() Dim colabLink As String colabLink = "" colabLink End Sub I cant get this code to run my Python-script. I also tried: # Add code to Colab Notebook !python /path/to/ !python (I dont know if the Notebook is called the right way. The name of my workbook is: Ny241028Hent33Tickers3Blokke5y I guess its .py How do I refer to this workbook from VBA, and how do I get to autoexecute
I'm looking for a Microsoft Excel expert to create a macro-enabled workbook for me. This workbook should have the capability to calculate CRC8 and CRC16 on user-specified hexadecimal strings. Key Requirements: - The CRC8 polynomial is x8 + x2 + x + 1. - The CRC16 polynomial is X16+X12+X5+1. - The workbook should be semi-automated, meaning it prompts users at certain stages but doesn't require constant interaction. - I want the hexadecimal strings to be inputted in user-specified cells upon execution, rather than fixed cells or a designated input sheet. As an example, this input string 20 00 00 C1 58 99 7D 3B 9F 00 01 yields a CRC8 value of 51 (all in hex) This input string 31 AF 20 00 00 C1 58 99 7D 3B 9F 00 01 51 yields a CRC16 value of FE 81 (both can be checked usi...
...operations and coordinating logistics. This includes managing a system where users can log in, upload documents, and access shared resources. Key Responsibilities: - Oversee login system which includes standard email and password login and Multi-factor Authentication (2fa) for enhanced security. - Facilitate the upload of various document types including PDF files, Image files (JPEG/PNG), and Excel sheets. - Manage access to uploaded documents, ensuring they're available to designated specific user groups. Ideal Skills: - Experience in operations coordination. - Proficiency in managing document systems. - Understanding of security measures in login systems. Please note, a crucial part of this role is to ensure smooth operation and coordination of logistics, wh...
...marketplace, can distribute his songs via our platform and get daily & monthly reports on his tracks using official SPOTIFY API. User can also pay to order a custom artwork for his album/single. Can withdraw his stream earnings and so on. Must be done a complete & custom back-end to handle users modules such as distributed songs, stats and so on and admin modules such as earnings, reports, stats, excel exports, invoices and settings. Payments gateway, social logins etc must be integrated and implemented. Multi languages support. Laravel 8 & latest tecnologies must be used. Supporting cross website and devices. Eloquent Master & Seo friendly. Modern stylish & material design website. Must be used only up-to-date libraries. Must be provided an API to connec...
I have a project requiring data extraction from a PDF file and input into an Excel spreadsheet. The data includes: - Text - Numbers - Tables The challenge is that each page of the PDF has a different layout. Your tasks will involve interpreting the varied formats and accurately transferring the information into a single sheet in Excel. Ideal Skills: - Proficient in data entry - Excellent attention to detail - Familiarity with Excel and PDF handling - Able to interpret varied data formats Experience: - Previous experience in data extraction and entry - Able to complete task in timely manner A big factor in winning this contest will be who gets me the data back by 5pm EST 1/19/2025 or sooner
I have 2 different sheets in one workbook. I need to lookup item number in the first one on the second one, and return the count qty. I am struggling because on many, it is bringing in the exact same qty. I will also need a sum on both sheets to make sure they match the original data source.
- online exam software -user & admin not open -not opening in moblie
I'm in need of a meticulous professional for mI am writing to express my strong interest in the Data Entry Specialist position at ByteCraft. With my exceptional attention to detail, strong organizational skills, and passion for data accuracy, I am confident that I would be a valuable asset to your team. anual data entry from digital files into Word documents. Key Requirements: - Proficient in handling digital files, especially PDFs and Excel. - Excellent attention to detail to ensure accurate data entry. - Familiarity with Microsoft Word for formatting documents. Ideal Skills: - Previous experience in manual data entry. - Strong organizational skills to manage and sort data effectively. - Ability to meet deadlines without compromis...
...4: Post-Production Editing** 6. **Appendices** - A. Sample Prompts - B. Notes on Avoiding Confusion in Messaging - C. References and External Links --- ### **1. Workflow Overview** 1. Use **Midjourney** to generate high-quality static images of the FT and traditional trailer in various scenarios. 2. Animate the static images using **RunwayML** to create short, dynamic video clips. 3. Combine the animated clips into a cohesive video using post-production software, adding overlays, sound, and transitions. 4. Ensure the messaging focuses on real-world benefits, avoiding theoretical confusion (e.g., raw numerical advantages like 1600x). --- ### **2. Chapter 1: Instructions for the Artist** #### **Objectives** 1. Demonstrate the FT’s ability to glide over obstacles...
I'm in need of a meticulous professional for manual data entry from digital files into Word documents. Key Requirements: - Proficient in handling digital files, especially PDFs and Excel. - Excellent attention to detail to ensure accurate data entry. - Familiarity with Microsoft Word for formatting documents. Ideal Skills: - Previous experience in manual data entry. - Strong organizational skills to manage and sort data effectively. - Ability to meet deadlines without compromising on quality.
...integrate smoothly with our existing systems. Collaboration with our team is essential to deliver valuable solutions. If you have a passion for problem-solving and a track record of successful Power Apps projects, we want to hear from you! You will be taking an existing Excel formula spreadsheet and converting it into a portal for external access. Consideration of the following is essential: Features of Power Apps Portals External User Access: Power Apps Portals are specifically built to provide external users access to select data and capabilities within a custom application, without requiring them to have a full user license for Dynamics 365 or Power Apps. Custom Domain Names: You can configure Power Apps Portals to use a custom domain name, making the portal...
...lush gardens. Design Style: Elegant and minimalist: I want the logo to be clean and sophisticated, with simple yet impactful lines. Nature-inspired: Incorporate visual elements such as ferns or other plants to reflect the garden theme. Color palette: Dark blue and gold to convey exclusivity and warmth. Logo Requirements: Visible name: Include the text "Los Jardines del Valle". Visual elements: Combine plants or ferns with a design that evokes calm and nature. Versatility: The design should work well in different formats (stationery, social media, signage, etc.). File format: High-resolution files (AI, EPS, PNG, JPG). Inspiration: Think of a cozy, modern space that blends the charm of a boutique tea room with an enchanted garden. If you have experience designing logos ...
Crear base de datos personalizable para introducir datos y consultar mediante busqueda especifica de palabras. Crear base de datos, para poner en servidor. Php mysql. Front end y backend, puede ser en laravel , CodeIgniter o cualquier. Usuarios. Admin y usuario invitado, en niveles. Ti...que se podra personalizar en el menu o en el codigo fuente. 2 secciones principales, primera, introduccion de datos, segunda buscador de palabras clave, indicando donde y cuantas hay en coincidencia. Y que se pueda acceder, ya sea en nueva ventana o lo mas practico. Pero que no se pierda la busqueda. Posibilidad de impresion en pdf, a valorar coste. Posibilidad de exportacion de datos, en doc o excel, a valorar. Visor de inagenes de datos adjuntos. Cualquier duda. Se prepara idea en grafico. Y text...
...user experience with seamless social media integration for easy sharing and interaction. Set up a system for managing and redeeming discount codes efficiently. Contact Us Page: Integrate a live chat feature that connects users directly with customer support for real-time assistance. Pages: Design an 'All Collections' page with a dynamic layout that prioritizes new arrivals and bestsellers. Combine Membership and Rewards into a single, cohesive page with clear calls to action for user registration and login. Establish a Blog page that includes a comprehensive catalog and social sharing options to enhance engagement and reach. Search Functionality: Implement an intelligent search engine that tolerates spelling variations and recommends products based on user input...
I'm seeking a proficient Excel specialist to consolidate multiple spreadsheets into a comprehensive master template. The current spreadsheets contain real estate tracking data and your task will involve: - Merging data on property values, insurance replacement costs, and financial statement information. - Implementing key formulas to facilitate future analysis. This includes: - Sum totals for each category - Average values across properties - Percentage changes over time The ideal freelancer for this project should have advanced Excel skills, particularly with formula implementation and spreadsheet consolidation. Experience with real estate data would be a significant advantage. Please ensure that the master template retains all necess...
I need an Excel sheet for tracking vacation plans in my department. The sheet should be divided into three categories: resident, specialist, and consultant, each having its own separate sheet. The tracking should be done on a weekly basis for 2025 Key Features: - Under each category, there should be a count of the total remaining persons available. - I need to track for each person: their name and the dates of their vacation. - The sheets should use specific colors for each category: Red for residents, Green for specialists, and Blue for consultants. Ideal Skills: - Advanced Excel skills and experience in creating complex spreadsheets. - Knowledge of color coding and formatting in Excel. - Excellent attention to detail to ensure accurate tracking.
Quiero poder ordenar de manera alfabetica la lista de estudiantes, pero que estos al ordenarse mantengan las notas que tienene en las otras columnas. para esto ocupo una macro. tambien otros arreglos en macros diferentes.
I'm looking to create a small, colorful and vibrant eBook. The project entails preparing the cover, designing the interior pages, and writing down instructions and recipes as per the attached file. This will be written by Arabic and English Key Requirements: - Creating a captivating, colorful and vibrant eBook cover - Designing balanced interior pages that effectively combine text and images - Incorporating photographs of recipes into the designs Ideal Skills & Experience: - Proven experience in eBook design - Strong graphic design skills - Ability to create vibrant and engaging designs - Experience in using photographs effectively within a balanced design - Familiarity with recipe writing and formatting Please refer to the attached file for further instructions and rec...
...websites. The project involves researching and organizing product data, including pictures and descriptions, into a professional catalog format. Project Scope: 1. Review the websites of approximately 10 suppliers (the exact number may vary). 2. Extract and organize the following information for each product: • Product Name • Product Description • Specifications (if available) • Packaging Sizes (if applicable) • Images (downloaded from the website or product sheets) 3. Prepare one catalog per supplier, ensuring clear formatting and organization. 4. Deliver the catalogs in Excel, PDF, or another agreed-upon format. Requirements: • Strong attention to detail and ability to accurately extract and organize product data. • E...
...construction management workbook in Excel that requires some enhancements. The enhancements include improved data analysis tools, a user-friendly interface design, advanced reporting features, and syncing with QuickBooks. I also want to integrate a construction schedule into the workbook. Specifically, the types of data analysis tools I want to improve are custom formulas, pivot tables, and data visualization techniques such as charts and graphs. Ideal Skills and Experience: - Expertise in Excel, specifically in creating and modifying workbooks - Experience with construction management tools or software - Proficiency in designing user-friendly interfaces - Knowledge of QuickBooks for potential syncing - Ability to create advanced reporting features...
Excel Data Cleaning: Removing duplicates, errors, and inconsistencies for accurate analysis. Excel Data Formatting: Organizing data into a clear and professional layout. Excel Dashboards: Creating interactive and visually appealing dashboards for data visualization. Excel VBA: Automating repetitive tasks and creating custom macros to save time. Pivot Tables and Charts: Summarizing and visualizing large datasets effectively. Data Analysis: Performing advanced calculations and trend analysis for insights. Conditional Formatting: Highlighting important data with rules and color coding. Formulas and Functions: Using advanced formulas (e.g., VLOOKUP, INDEX-MATCH) for dynamic calculations. Data Validation: Ensuri...
I'm seeking a skilled Python programmer to automate the handling of mixed data inputs into an Excel spreadsheet. The data, which encompasses both text and numerical components, needs to be updated on a weekly basis. Key Requirements: - Proficiency in Python, specifically in automating Excel processes. - Experience in handling and processing mixed data. - Ability to set up a weekly data update system. Ideal Skills: - Python programming - Excel automation - Data processing and handling I look forward to your bids.
I'm looking for an Excel expert with strong skills in data analysis and financial modeling. Key Responsibilities: - Conduct thorough data analysis using Excel - Build and implement valuation models - Utilize market data and economic indicators for the analysis Ideal Candidate: - Proficient in Excel with a focus on data analysis - Experienced in constructing and using financial models, specifically valuation models - Capable of sourcing and interpreting market data and economic indicators - Strong attention to detail and analytical thinking skills - Excellent communication skills to explain complex data in a simple way.
I'm looking for an experienced app developer to create an Android application for data collection specifically aimed at tracking inventory. Key Features: - The app should allow for the input of data in the form of photos and manual entries. - It should combine this data and output it in the form of Excel spreadsheets and embedded graphs with pictures. - The app should generate pie charts based on the inventory data. Ideal Skills and Experience: - Strong background in Android app development and data collection apps. - Experience with integrating multimedia data (photos, manual entries) in apps. - Proficiency in creating apps that can output data into Excel and generate graphs. - Knowledge of designing apps with vi...
I'm seeking assistance in creating an Excel tracking sheet designed for work in the office. This sheet will primarily handle project timelines and needs to incorporate various advanced features such as macros, RAG rating codes based on project phases, and the ability to grey out areas or flag items. Key Requirements: - The tracking sheet will need to have macros to achieve RAG rating codes. These codes should categorize tasks based on the project phase. - The sheet should allow for grey-out of certain areas, specifically those marked as 'Task on Hold'. - There should be a separate sheet that automatically flags items marked as 'In Play'. Ideal Skills: - Advanced knowledge of Excel, particularly in creating and implementing macros. - Prior experience...
I'm in need of a professional who can prepare a comprehensive project progress report, to be delivered weekly in an Excel format. Key Components of the Report: - Task Completion Status: I want to know how far we've come in terms of task completion. - Deadlines and Milestones: It's crucial to track whether we're hitting our deadlines and milestones. - Resource Allocation: An overview of how resources are being used is also necessary. Ideal Skills and Experience: - Proficient in Excel with experience in project management reporting. - Strong understanding of task tracking, milestone setting, and resource allocation. - Excellent attention to detail and ability to present data clearly and concisely.
I'm looking for a Photoshop professional who can help me combine two images into one for a social media post. The final image needs to be a realistic blend, with particular emphasis on making my face and the faces of others in the picture stand out. Ideal skills for the job: - Proficient in Photoshop - Experience with realistic image blending - Ability to highlight specific elements in an image I look forward to seeing your bids and hopefully working together on this project!
I'm looking for a unique, clean logo for my facility management company. The logo should used on gray or white cars as well. Budget 30$. I want to use: "Novafix FM" or "Novafix" or "Novafix Facility Management" . Depend on the style I received. The logo should be a combination of both text-based a...received. The logo should be a combination of both text-based and icon-based elements, with a modern and minimalistic style. Key aspects: - A blend of company name and a symbol. - Use of a blue and green color scheme, reflecting professionalism and environmental awareness. Ideal candidates for this job should have a strong portfolio in modern and minimalistic logo designs, particularly those that combine text and icons. Experience in facility ma...
...construction management workbook in Excel that requires some enhancements. The enhancements include improved data analysis tools, a user-friendly interface design, advanced reporting features, and syncing with QuickBooks. I also want to integrate a construction schedule into the workbook. Specifically, the types of data analysis tools I want to improve are custom formulas, pivot tables, and data visualization techniques such as charts and graphs. Ideal Skills and Experience: - Expertise in Excel, specifically in creating and modifying workbooks - Experience with construction management tools or software - Proficiency in designing user-friendly interfaces - Knowledge of QuickBooks for potential syncing - Ability to create advanced reporting features...
Looking for a person who can do accounting data entry in Tally and Excel and some easy to use software. Person should have his laptop and prior experience of tally and Excel. Monthly fee around 7000 depending upon profile..Only from India
I'm looking for a skilled developer experienced with the Whisper JAX model for audio transcription. Primarily, I need this for translating audio recordings of conversations into written text. Key Requirements: - Transcription of audio file with accurate timestamp in English and Hindi - A static website to upload audio file either single or in batch. - Delivery of transcriptions in an Excel file Ideal skills and experience: - Proficiency with the Whisper JAX model - Experience in developing web-based transcription services - Excellent understanding of English and Hindi for accurate transcription - Ability to deliver transcriptions in a specified format.
I'm seeking an Executive Technical Assistant who will prim...Technical Assistant who will primarily support me with technical tasks, project management, and data analysis. The role will require a strong proficiency in MS Word and Excel, particularly with their advanced features. Key Responsibilities: - Call the clients - Follow up for data - Preparation of reports Essential Skills: - Proficiency in MS Word and Excel - Experience with technical support, project management and data analysis - Ability to prepare comprehensive reports Preferred Excel Skills: - Simple excel tables and summary The ideal candidate will have a strong ability in data interpretation, with a focus on operational metrics analysis. Experience in interpr...
I need a modern style logo for MKW PRODUCTS. The logo should combine both image and text. In addition to the logo design, I am also looking for someone to create professional tone website content for our brand. Ideal Skills: - Graphic Design - Logo Design - Content Writing - Web Content Creation - Brand Development
