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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top