response

Hi Excel Wizards, The function of this code is to copy data from one sheet to another using a drop down and message box, also adding a timestamp. Unfortunately the destination is targeting row 2, not the last blank row, and overwriting any data in row 2 of the destination sheet when the copy is...

Afternoon I hope some kind some may be able to help me. I have a worksheet where I would like to be able to calculate an anecdotal 'Result' against some date based fields. I.e. 'Response SLA' and 'Actual Response' - I would like to be able to compare these 2 dates and if the Actual SLA...

I have the following macro that works as expected. It finds only the value of the variable 'response' in column S and copies the appropriate range from the found rows to column C of Sheet2 starting in row 9. Cell C8 of Sheet2 has a header in it. Sub CopyData() Application.ScreenUpdating =...

Hi all, I'm trying to do a multiple if formula to median response times without counting any blank cells and cells with errors as not all them teams fill in the detail straight away. Here is a sample table <colgroup><col><col><col><col><col></colgroup><tbody> Team Date Respose Date Response...

First and foremost, you guys rock! Last week I learned how to copy and paste data based on drop downs. Thanks Fluff. Over the weekend, I added timestamps and message boxes. Now, I'm wondering, can we first check for and remove any duplicate/previous entries, excluding the source, then copy and...

Hi Guys, don't know what the poster has done here: https://www.mrexcel.com/forum/excel-questions/1048832-excel-vba-website-tr-td-loop.html but it looks as though the whole page is inside a set of code tags (or two) My response is 'trapped' in there too. It's a pain to scroll through the...

I have 2 spreadsheets, Roster.xls and Response.xlms. The Response file has a list of last name that need an email address. Roster has the full name and has the email address. I have the code that allows me to find the location of the email address in Roster and insert it into Response. As it...

Hi, I am trying to turn a text list into a table. The list is approx 60 'routes' as similar to below. I would like use a macro to turn this into a 60 row table. What is the best was of achieving this? Many thanks, Rich From a text list:Route *TEST_AD* User 1 name: Business Unit...

I work for a fire department and I am trying to create graph which shows response times to a city. The data that I have is the date, response time in seconds and response time in minutes. I would like the date at the bottom and five minute increments on the left with a continuous line showing...

Im trying to write a sumifs for the first time and i have the cells basically formatted to a date, now whenever excel is unable to find the criteria its reporting back a response of 00/01/1900, however this is just a stupid response so I am hoping to get excel to say either NA or report back...

So, I'm struggling with yet another one of these statements. I've tried both sets of code below, and I keep getting the message box when each box is completed, except for the txt_Street2 box. The idea is that if any of the 5 are not null, but either Street1, City, ST or Zip are null, I should...

Can someone tell me why the first code snippet won't progress through? When I click No on the message box from the first if statement, the code isn't progressing through to the next if statement. Private Sub cmd_Submit_Click() Dim cGender, cEntryType, cPymtFreq, cPymtStatus, cStatus...

Good day, I'm trying to match the value of 2 cells from one sheet to 2 column in another sheet. I can get to work with only one data but not both. The main point is to be able to look up previously entered information and avoid duplicate. here is the code i'm using to find duplicate. Set...

I'm using this code to evaluate the value of a textbox on a UF. If the value is invalid, a msgbox is triggered. Once the EU clicks the OK button, I want the focus back on the offending textbox. Instead, the focus is moving to the next textbox, which also has similar validation occurring, so...

Hi good folks. Greetings from Scotland. I have a question regarding network days, I've searched the forum but cant find an answer that is looks right. In the table below I'm trying to calculate the response between the 2 times below, based on a working day of 08:00 to 18:00, and should include...

Can someone tell me why I'm getting a "variable not defined" error on the lines in red font? I've used this code in another application, and didn't get this error. Dim IsOk As Boolean IsOk = True Select Case True Case Me.cobo_Facilitator.Value = "" MsgBox "Please enter who...

I have a workbook and a pivot table. On the pivot table I have ROWS: Ethnicity and Behavior Response Behavior response includes items like Restraint and Suclusion On VALUES I have a count of Student ID. So, naturally it is counting the number of student IDs in each Ethnicity in each Behavior...

Hello, Long time lurker, first time poster here. I'm trying to create a data management system and having trouble with this one last forumla – which is the difference between me being able to sleep at night and staying up ripping my hair out. The below screenshot is a crude replication of...

Ok... So I have seven columns... I want to find the duplicate rows (c column) and then find the rows that don't have a value of QC in column F, then return the number in column G of the duplicate rows that don't have a value of QC in column F but are duplicate values in column C. ANY HELP IS...

Hey all, I was just looking for some advice/suggestions on handling a VBA-sFTP relationship. Presently I have an upload of a CSV file via sFTP to a third party. The third party response file can take up to 1 hour to be returned. Therefore I was wondering if anyone could suggest any more...