receive

Four people travelled to a place. their total expenses was Rs.2850. Divided equally would be Rs.712.50 A is charged 712.50 but paid Rs.1940 B is charged 712.50 but paid NIL C is charged 712.50 but paid 820 D is charged 712.50 but paid 90. Now A has to receive 1227.50 and C has to receive...

I can send an email via vba without outlook, but I can not receive emails, can you help me ?

Hi, I've only posted once before, so sorry if this isn't very clear. I've got a list of email addresses with additional information associated to them in random length rows as shown below (dummy email addresses used). I want to be able to capture each email into it's own row, with the...

Apologize in advanced if this is the wrong place to post about this. I saw report bugs in the description and I’m worried this might be a bug (but more likely just me not understanding something). I’m a registered user but my inbox is full despite being empty. Am I missing something? I verified...

Hi All I am wondering if you could help. I am running a number of queries on data that I receive on an annual basis however every year I receive the data, h columns re not one over, for example instead of using row S it will now use row T. Is there any way that I can update the queries with...

Hi everyone! When I try to open my spreadsheet, I receive this message: Then, I receive this error message: I'm in panic and in really trouble! Anyone can help me, please? I can't attached the spreadsheet and I can't share a link =( Thanks for someone who could me help!

Hi I have the following: Dim mySUN As Workbook Set mySUN = Workbooks("c:\SUN\Get_Sun - 2018.xlsm") I receive an error -->subscription out of range I would like to correct this. Thanks!

Greetings Mrexcel, I am new in this forum and i asked a question about above title but I can't receive the answer being sent to me Mrexcel and the reason am getting is that my inbox is full ,i surely don't know what to as all my inboxes are empty. Please help me receive that answer to my...

I have a file on our One Drive, is there a way I can receive an automatic email when that spreadsheet is modified? Thank you,

I am trying to get commission values to generate based upon three criteria's: <colgroup><col><col><col span="2"></colgroup><tbody> Employee LPH QA Score DH A 4.6 0.967 37.9 B 3.5 0.951 25.6 C 1.7 0.981 29.2 D 3.4 0.912 37.2 E 7 0.964 15 F 2.1 0.863 20 G 5.5...

Hi, I am in a bit of a pickle. I am currently completing some exercises to learn excel. The current function in question is the IF function along with its logical operator friends IF(OR and IF(AND. The document is in Dutch, but I have translated the instructions if I need to share the document...

I have a if and statement that I am receiving a value error on. If I just use 1 if statement it works properly. When I add a second if statement, I receive a #Value error =IF(AND(C3="B",I3="YES"),"Min. Amt / 286","") + IF(AND(C3="W",I3="YES"),"Min. Amt / 286","")

Trying to get a unique number (Tracking Number) to show when 2 items are matched (EDIPI and Pending Status). Currently I am using =INDEX(TFRS_FTAP[TRACKINGNUMBER],MATCH([@EDIPI],TFRS_FTAP[EDIPI],0),MATCH("pending*",TFRS_FTAP[STATUS],0)) However, I only receive a #REF error when it computes...

As our organization slowly moves toward the PowerPivot world, I'm starting to get other people's spreadsheets with data models and being asked to help with DAX and relationship issues. When I receive a spreadsheet I want a tool that tells me everything about the data model: queries...

I am trying to format the cells in which I enter data. I receive invoice numbers from our department head, the invoice numbers vary in length. I need all entries to be 11 digits in length. If the invoice number I receive is only six digits in length, I need the first five to be zeros...

Good afternoon all, First time here and requiring some help. I was using this code successfully since the beginning of my coding. Today I added a substantial amount of code to the UserForm and now I receive error message on my initial ComboBox load. Private Sub Worksheet_Activate()...

We have a specific user that is exporting to Excel and the output is in comma delimited format. All other users receive their exported spreadsheet with their data in separate columns (Text to columns is done systematically). Any thoughts as to why this user would receive their exported data in...

I've been racking my brain trying to figure out how to go about creating a spreadsheet to perform something for me and can't figure out the right angle to approach it from. So. Here is what I'm trying to do. Numbers are arbitrary to explain. I have 100 employees listed in seniority order. I...

Hi all, I'm having an issue with conditional formatting, hope you can help. I'm doing some work on the gender pay gap, and need to use Red, Amber & Green to indicate good, ok, and bad. For example if the % of males and females to receive a bonus is below; I need to show the values in green, as...

Hi, I no longer receive email notifications, is this just my problem? Would appreciate help Thanks A