client

Hi Experts! I need to get the maximum DAY dates of the following clients Client Max day dates A 15 B C Here is the source data: CLIENT CATEGORY DATE RECEIVED A MEDICAL 7-NOV-19 A DENTAL 15-NOV-19 A VISION...

Hi Experts! I need to get the deadline of the following client: Client Deadlines A B C D E The source data looks like this: Deadline 10th-15th 16th-20th 21st-25th Blank ClientA ClientB ClientC Blank ClientD blank ClientE What...

I'm a photographer needing help with determining how many images to edit per day in order to meet a deadline. The columns are as follows: D) Status - The status column indicates where the client currently sits in the workflow, such as "Scheduled", "Edit", "Reveal", etc. F) Due Date - The Due...

I have the vba worked out to create the appointment with no issues. Sub Makeapt() Dim warning warning = MsgBox("You are about to create Outlook appointments for " & ActiveCell.Value & " " & Cells(ActiveCell.Row, 10) & ". Is that right?", vbOKCancel) If warning = vbCancel Then Exit Sub Set...

Hi All, Kindly provide an example to connect oracle database without oracle client installed in system. TIA

Hi, I have a userform with many controls, and below are some of them txtBarCode (TextBox) [where I insert the needed Item's Barcode] cmbNum (ComboBox) [(List from 1 to 8) to Identify the clients number] txt_Name1, txt_Name2 ...txt_Name8 (TextBox) [To insert the client names, (if cmbNum = 3...

Hi, I have a workbook with numerous worksheets ranging from 1 - 30. Sheet 1 contains stock levels for each item within column K Staff enter info on the specific client sheets (sheet 2 - 30) which then deducts the stock ordered from sheet 1. (ie so if a client on sheet 3 orders 10 units of an...

'/////////////////////////////Variable Declaration////////////////////////////////////////////////// Dim masterData As Worksheet, console As Worksheet, inputCell As Range, firstNames As Range, lastName As Range, countWhichName As Range 'EZ refs for sheets/ranges Dim client As String...

Hi, I have a table of data that I turned into a pivot table. Here is an example of more or less the data I'm working with: <tbody> Date Type of movement Product A In Product A Out Unit Cost Unit Cost Client Selling Price Product A in Stock 10/11/19 A 20 3 100 10/3/19 B 10 2 Client A...

Hi, I have a table of data that I turned into a pivot table. Here is an example of more or less the data I'm working with: <tbody> Date Type of movement Product A In Product A Out Unit Cost Unit Cost Client Selling Price Product A in Stock 10/11/19 A 20 3 100 10/3/19 B 10 2 Client...

Hello everyone, I'm struggling with a problem on a pivot table. I have some data that looks like this <tbody> Date Month Management fee Client Billing amount 01/01/19 January 200 Client 1 500 01/01/19 January 250 Client 2 250 01/02/19 January 200 Client 1 560 01/02/19 January 250...

I have a table which includes Column 1: Client Name Column 2: Project date (Must be last day of month) The unique ID is a combination of column A and Column B. So, there may be multiple instances of the same client with different project dates. I want to create a query that looks at the...

I have a list with similar content to this: <colgroup><col style="mso-width-source:userset;mso-width-alt:2616;width:55pt" width="74"> <col style="mso-width-source:userset;mso-width-alt:3669;width:77pt" width="103"> <col style="mso-width-source:userset;mso-width-alt:1820;width:38pt"...

Hello, I have the code below to get the lookup amount of the selected client from sheet5, but I don't know what I did wrong since it's not showing the amount on the "txtTotal, can you please help me to get the amount of the selected client? Note: the Amounts on column "D" contains formulas...

All, Is there anyway to make sure that a client cannot see any track changes/previous versions of an excel? I don't think track changes were on when the file was created but we want to make sure the edits/changes cannot be viewed by the client. Thanks, J

Hello, I have the following code on my userform "frmPOS" to check if any entered client name if exist or not, if so, get the ID and mobile to txtID and txtMobile If not, pop up msg that this is not exist and if I need to add a new client, if so, show the form "frmNewClient" and add new client...

Hello, I have a sheet "Clients" that contains all clients details as the table below and I have all these data as dynamic named range "Client_Details" "A2:D4" I have a userform with many text boxes and combo boxes, but what I need right now is: Once I choose a Client name in the combobox1...

I have a spreadsheet that is used to generate quotes for clients. The worksheet (npss_quote_sheet) is used to generate 1 quote for one client at a time. There is a table (npss_quote) that lists the services in the quote for the one client. Once all services have been entered, the quote is...

Please can someone advise me the best way to go around this scenario. To help ease calculations for a mileage report I want to put together. I am thinking I will have 2 lists that generate a result (you maybe able to advise a better way?) – a list of clients (going from) and a list of clients...

Basically, you can see clients on the left and then different stages of the project next to it. These dates are manually entered. The "(IR)" is basically our internal review and has to get priority if it's in the same week as the same stage without "(IR)" Because it has to get priority I did a...