details

  1. S

    Need help with a Match / Vlookup type formula

    I have this data, it has too much details in one column. I'm trying to write a formula that will find only certain contents based on cell A on another tab. If it matches whats in one of those cells, then pull that name or details. How would I go about writing a formula for this? I looked up...
  2. A

    Some VBA to beat a repetitive task

    Hi All, I have a task that's very time consuming that I was hoping I could get help with some VBA code. I don't think it's all that complicated, except maybe for the pop-up box I was envisioning, that's a bit beyond me. I'm just not that quick on my feet to get it all written myself. I have...
  3. A

    how to get combobox multiselect results to specific worksheets

    hi all. I have a userform in which people can select trips/events from a multi select listbox. The list box's row source is a named range containing the name of all trips. each trip has its own tab. The tab names are an abbreviated version of the trip name. I need to have the details of the user...
  4. JazzSP8

    Dont' display rows based on certain columns being empty?

    Hey All I've built a Query that pulls in details about certain products in our range. The problem I've got is that the details for each product live in a text file, it contains details for every product we've ever stocked including some obsolete ones. Because of this my Query is returning...
  5. K

    Mark a cell based on latest date (Excel 2013)

    Hello Excel Guru's, I need your help on how to do this in Excel 2013. I have 2 tabs, 1 for details (source data) and 1 for my summary (target). In the summary tab, I need to mark the Name of the animal with X if in the Remarks column the cell value is blank based on the latest End date. Hope...
  6. Dazzawm

    Send Emails In Bulk From Spreadsheet

    I have a spreadsheet as below. Is there a macro that will open my email client and send an individual email in bulk to all in the sheet? Thanks <colgroup><col><col span="2"><col></colgroup><tbody> Body 1 Body 2 Title Email JMatear sdgdfbxfb Login Details example@gmail.com JBrowning fsfbdfb...
  7. danhendo888

    How to transpose(?) column to desired output

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col width="25px" style="background-color: rgb(218,231,245)" /><col /><col /><col /><col /><col /><col /><col /><col...
  8. F

    VBA: Copy specific cells to another worksheet

    Dear all I am having trouble trying to put together a macro. In Sheet1, I have my data table. I put a simplified version below: <tbody> Gender Breed City Council Microchip Number Status M Dog Council A 1030999876287540 Adopted F Dog Council C 4425588004585700 F Cat Council B...
  9. R

    Adjusting stock data on stock usage spreadsheet

    Hello All I am trying to automate a task that is completed every day on a spreadsheet. I have an inventory tab, which contains the stock details of some 1200 different products. Each day we consume some of these products and update the inventory sheet using the find function and manually...
  10. W

    VBA vlookup if value not found

    Hello, I have this bit into my code, that should return simple "Yes", "No" values present in the range. inclusion = Application.VLookup(Dest, details, 10, False) All variables are defined, inclusion as Variant, Dest as String, details as Range. The problem i am encountering is that when the...
  11. J

    Message box to display details of a Pivot Table cell.

    I would like to write a macro to display the details of cell in a pivot table when the cell is double clicked rather than having them come up on a new sheet. I want to keep the workbook locked so other users cannot access the hidden pages. The purpose ids to determine if the value is the sum...
  12. H

    Pivot data details in same sheet as pivot

    Hi, I've created a pivot of a data matrix to get an easy readable overview. I also use this pivot to get to the details of interesting data by double click on the data. Every time I do this Excel opens a new sheet with the detailed data. I was wondering if t's possible to show these details on...
  13. N

    Pivot Table - Show Details VBA - Multi Row and Column

    Hello, I need assistance, please! I have an excel document that has multiple worksheets. On one of the worksheets, I have multiple pivot tables that are manually created, based on the data being used. The primary use for this document is to take a "Big Data" file and provide the "customer"...
  14. M

    Cell contents based on another cell data

    Hi All I have a worksheet that shows a whole load of data summarised in the table below. Worksheet 1 <tbody> Code Sub Code Sub Sub Code Details A Title A 1 Sub Title A1 a Sub Sub Title A1a b Sub Sub Title A1b B Title B 1 Sub Title B1 a Sub Sub Title B1a 2 Sub...
  15. Z

    Sum multiple rows with changing column

    Hi, I've seen variations of this question but haven't found anything that solves what I am trying to accomplish. I have 2 worksheets, a Summary worksheet, and a Details worksheet. The summary worksheet summarizes what is on the detail worksheet (pretty crazy eh??). The Details worksheet is...
  16. M

    VBA get current system login details with Email id

    Get current system login details with Email id and update in Excel sheet by Vba
  17. J

    VBA coding

    Hi. I'm working on coding to automate filling details in users form. Before entering into user form I need select a form name from drop down list. Once selected IE page loads and wait time is around 3 secs. Then need to update details. Now I'm trying to automate this process by using VBA script...
  18. T

    Macro to copy last row in range

    Hi Everyone, I add my sales into sheet "Quotes" Range is D27:O51 The data for each sale is two rows, row1 the details, row2 Notes, (Not all sales have notes) so what I want is a macro that will copy the last "Row1" sales details and paste it below but it needs to place it 2 rows down to miss...
  19. C

    Worksheet calculate using formulas

    Hi all. Could anyone please help with formulas using the worksheet calculate event. In column A of sheet1, product codes are scanned. This then brings details of the items through from sheet2 where the manifest is stored using index match on columns L, M, N, O What I would like to happen is...
  20. B

    Pick out some details in a JSON file and print these in a text file

    Hi I have since 1999 downloaded statistics in XML format from a home page and now they have changed to JSON. I can't write code myself and wondering if anyone can help me with VBA code that can pick out details from this file and print the details in a text file. I keep my fingers crossed that...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top