ticket

  1. C

    Multiple lookup criteria

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

    Index/Match in 2 data tables

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

    Can I amend a macro to meet specific data needs

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

    How do I insert a line but when trying to insert comes up with error

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

    Auto Delete Data

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

    Need to open two workbooks with known path but changing name, get data and then close and delete workbooks

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

    Mail to be sent from Excel with info from specified columns

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

    Adding 2 New Prices to Ticket Tracker Template

    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!
  9. L

    Counting days between two dates but stopping the count on a third date

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

    Delete a specific text in Raw Data

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

    Retrieve data by comparing the two excel Sheets

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

    Alternative to filtering / advanced grouping

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

    "Round Robin" ticket assignment queue

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

    pulling data from tables based on criteria

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

    Formula for total price less bulk discount

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

    Userform Password protected sheet sending error

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

    KPI/SLA calculation

    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)...
  18. H

    Lotto number results counter

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

    VBA Consolidation

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

    Excel list with range of values

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

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