outbound

Im looking to extend this formula, so that if Cell A1 contains either the work Inbound or Outbound then it will return a different value I want inbound to return INB and outbound to return OUB. Currently i can get the inbound to work, but i want to add the 2nd condition. The formula im using...

Hello to you all! So, I'm working on this new UserForm to add some new entrys of info I need to keep track of the data. Basically it has some textboxes and a couple of comboboxes and I'm struggling to change the cell color of the last field (combobox) in the database. It only has two variables...

Hi folks ... the code below was working but suddenly stopped with Error 13 Type Mismatch where 'If ws.Range("U1") = "Active" And ws.Range("U2") = "Outbound" Then' was highlighted as the problem. If I remove 'And ws.Range("U2") = "Outbound" ' it will show all sheets where U1 = Active. So was...

Hi, I am after a lookup formula to bring across the freight cost to give me a total cost of deliverys? Please see below table. <colgroup><col width="64" style="width...

I have a data table that looks something like this (fake data obviously) that's been pulled from a text file and brought into Excel using the Power Query AddIn for Excel 2013. <tbody> Direction Email Outbound adam.zapple@xyz.com Inbound pepper.mintz@abcd.com Outbound...

Hi All, I need some help from all of you geniuses. I'd like to utilize a macro to delete rows in a spreadsheet based on a repeating set of formats. In the table below, the macro would need to start deleting at the first empty row (2) and finish with deleting the last row "Date/Time...

HI, I need a formula that will take multiple cells and exclude a time that is within 2 minutes of another time. Is this possible? for example: Outbound call: 2:49 pm Outbound call: 2:51 pm these are actually the same call. I want to exclude one of them because it is within...

Hi all, Happy bank holiday from the UK. I'm trying to create an Excel model which tracks my outbound capacity from a warehouse and identifies where the capacity is forecast to be exceeded, and adjusts the outbound volume to the weeks where there is spare capacity. <tbody> At the moment I...