requested

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

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?

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

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

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

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.

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

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

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

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