ticket

Hello there. I need help with a lookup matter. My efforts to use INDEX and MATCH have not worked. A system generated report is received is in columns and looks like this: Ticket ID Type Measure Oct 2019 Overall Result 7004114394 Amount...

So Index/Match is a great tool but I'm having a hard time wrapping my brain around this... I want to return a field called "Date" to "Table1" from "Table2" using a common field of "Ticket" but i keep breaking things.. Kind of like a Vlookup but without the first column restriction... Thanks in...

Hi I have the macro shown below that adds a row when the word "ticket control number" appears in column S. What im trying to do is amend it so that at every change of number in column "X" it adds a row instead. Any Ideas? Thanks Sub ControlRow() Dim lastRw As Long, nxtRw As Long 'Determine...

Hi Im trying to insert a blank row below a row that has the word "Ticket Control No." in column S. When I tried doing this manually I get the error message "microsoft excel cant insert new cells because it would push non empty cells off the end of the worksheet" On my worksheeet there is...

Hi, I have a very large amount of data that I would like to tidy up using a macro. I've sorted the data by the relevant columns and now I have rubbish data at the end, which I would like deleted. Column A has a Ticket Number. Once column A stops having a ticket number, any data contained under...

Okay, this one has a lot of moving parts. I have a macro enabled WB (Daily Ticket Report.xlsm) that has two blank worksheets. I export two reports from our ticket system and then manually select all/paste the data in one of those blank WS. The reports export to my Downloads folder...

Hi Team I would like to send a mail from excel with the info from - specified columns - Specific email body Please see screenshot - SDA email - that should be To - TL Email - That should be in CC - Reason and INC/WO should be in subject with line "Returned Ticket...... - Email body - "Your...

I am a newbie with Excel and could use help. I am trying to use a template for Ticket Tracking for our Non profit Theatre. Here is the template I am working on. https://1drv.ms/x/s!AvrJXpPq_XWokllNt6BaJTbrlgJI I would like to add 2 new prices under D3. Could anyone guide me on this? Thanks!

Column A is a date a ticket is opened Column B is today’s date Column C counts the days between A & B Column D is the date the ticket is closed I want column C to count the days between A & B, which it currently does using =DAYS([@[Today”a Date]],[@[Date Opened]]) but I want the days in...

I have a set of raw data I export everyday. When I export the data, all the raw data is on 1 column. I have a row that says "2 tickets" and need to delete the "ticket" and "tickets" text before I can add to my access database. I only want the numbers to be intact. I do not care of the...

Hi Excel Experts, I have 2 excel sheets (Sheet 1 and Sheet 2) which has ticket number and status of each ticket. Sheet 1 is having Old status and Sheet 2 is having new status. I just want to know all the tickets, which are the status changed from sheet 1. Please find the attached image for your...

Hi Mr Excel, I need an alternative to filtering. Something like grouping that will give me a handy button on the lefthandside... I understand groups. I select three adjacent rows and do shift-alt-rightarrow and a button appears on the lefthandside allowing me to open or close. But what if the...

Hi, Wondering if anyone has any VBA laying around that can help me build a ticket assignment queue. I'm trying to create a "round robin" ticket assignment queue that will keep track of tickets assigned to individuals. There needs to have the ability to skip names if their cell is shaded red...

Hello, I have a workbook which contains a several different tabs all with a different persons stats. i was entering this manually but now i have managed to do an sql dump from the server with all the data i need. i have created a tab called data dump where im going to copy and paste this from...

Hi: I have been struggling for a solution and I need some help. Expected values are in column H to J In H2, I am looking for a formula for total cash due: = look up value in A2, return ticket price x tickets sold, less cash discount (per discount band) x ticket sold Excel...

Hello, I am new to this forum along with being new to Userforms and codes. I have set up an Excel Userform, with 3 tabs at bottom of workbook. Mgmnt Ticket, Ticket Data Entry, and LookUpLists 1) Mgmnt Ticket - Password Protected but can not get the code to get through the password. If I...

Hi all, I've got following issue: i need to determine KPI %. The KPI is about exceptance time, i've got two date/time column (ticket received (column L) and ticket accepted (column AC)) that i have to match, the threshhold is 4 hours (within 4 hours is positive, above for hours is negative)...

Good afternoon Masters, I have some codes that comes from other users regarding lotto numbers generators. I want to update it by getting the combination of the previous lotto results which I have entered above the file, then a message box will show how many time we run the vba codes before we...

Hi there, just wondering if someone can assist, basically I have a spreadsheet containing approx 150,000 lines of event information along with each time a note was added to that particular event ID, Here is an example of a small part of that table <colgroup><col...

I'm working on a spreadsheet where a user enters ticket numbers for a raffle for a given customer. My data is currently in this format: <tbody> Customer Ticket Issue Begin Ticket Issue End # of Tickets Total Sale customer 1 '001 '002 2 $40 (2 tickets @ $20 a piece) customer 2...