requested

  1. T

    Pivot Table

    I have a column that I want to filter on in a pivot table. The column contains multiple values in some cells, how do I filter out only words that contain certain cell ranges: For example these are all values in the cells and I only want to see the rows that contain HART for example? Thank you...
  2. S

    Macro using Lrow

    Hi all, I have a data in sheet called 'Request' that I need selecting in A:C range until it ends and pasting below existing data in 'Requested' sheet. I'm trying to write this withLrow = Cells(Rows.Count, "A").End(xlUp).Row, but have no luck. Any ideas?
  3. U

    Macro - VBA - to display message based on condition

    Hi I have the attached table. When user press submit button, I want to display the following message Based on the column C, "Add or Remove": Thanks for your license request. You have requested to add the following modules: Text1, Text3, and Text 4 (Quantity 5), Text 5 (Quantity 5) You...
  4. Y

    EXCEL- Lookup Function to create a new Table from another table.

    Hello, In EXCEL using formulae in the example below, how may I populate Table1 with the data from Table 2. I tried Index Match but was unsuccesful. <colgroup><col><col><col><col span="6"><col><col span="2"><col><col><col><col><col span="2"></colgroup><tbody> TABLE 1 TABLE 2...
  5. R

    The nearest value to the one requested

    Hi, New here. What formula should I use in column C (Tx) so that for the name A and the value 0.5 I get the closest value in table 2 (obviously also for the name A and one of the cells in columns T1: T3 In column C (Tx) we put the results manually. Bold cells. Thank you. <colgroup><col...
  6. B

    Text formatting

    Dears, Is it possible to set the cells proprieties like: font type, font size and font color at the begining of the macro and restore to the defaut settings when another macro is requested to run? Or I've to set my preferences at the begining of each macro? Thank you.
  7. D

    Sort Data into Table

    Hi! I am relatively new to Excel and am trying to make an automated sign up sheet for fun. I've nearly completed it but keep getting stuck when trying to actually sort the data. I have it organised into a list based on priority(Date/Time it was requested) and have the times and dates recorded...
  8. B

    Asking for help...

    I have a worksheet that is used to request flight legs from my aviation department. At the top of the page, the user can enter the total number of legs (1-10) requested for the trip, and that will populate column A with the entered number of legs, and also through VBA, require that certain...
  9. E

    excel If date is after or before 5pm the prior working day

    Excel dates. I have a date of job and date/ time of job request. If the job was on a Monday, or weekend I need to determine if the job was requested before or after the previous Friday at 5pm. The rules are if a date of job (Job date) was requested (job requested date) after 5pm the prior...
  10. S

    Copy data from multiple sheets into master sheet if column A value is "REQUESTED"

    Please can someone help! I need a formula which will run across multiple tabs (10 in total - each with a different persons name on) to copy into the "COMBINED" tab if column A on an agents worksheet is "REQUESTED". So if in Abbies worksheet A2 is "REQUESTED" then I want it to copy that line to...

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