subject

Suppose I have the following data <tbody> Alex 01/07/18 10000 Mike 09/07/18 20000 Alex 13/07/18 35000 Jason 13/11/18 26000 </tbody> Now, I'd like to find the maximum commission earned by a person for a month subject to the condition that for each transaction max commission earned...

I'm using this to replace the subject in an outlook message; Item.Subject = Replace(Item.Subject, " - IMPORTED", "") Can someone show me how to take it a step further and remove not only the above but any text after 'IMPORTED'?

I’m trying to create a ‘test’ function within excel where I can enter subject headings from an email and then they’ll either be approved or rejected based on various criteria. Here are the criteria; - Text length between 18-25 characters - Any words on a ‘bad’ list will flag...

Lets say i have a data set with five columns with subject name for every student and need to create a program for exams. Mark A B C F Paul K C L A Jane B F D A George M N C E I need to find the best way to combine all letters so that no student has two exams the same...

Guys I want to create a code , This code will query a subject for example "facebook" and will count how much emails received with this subject from inbox and will put these emails in specific worksheet that i create with the name "facebook" for example

Hi, I have a spreadsheet and on one of the sheets named 'data' I have names (column C), areas (column E) and categories from row F1:P1. For easy reference I will call the areas 'class' and categories 'subjects'. It looks something like below...

<tbody>#CACACA[/URL] "] A B C #CACACA[/URL] , align: center"]1 #C0C0C0[/URL] , align: center"]ID #C0C0C0[/URL] "]Subject #C0C0C0[/URL] , align: center"]score #CACACA[/URL] , align: center"]2 1000 Math 80 #CACACA[/URL] , align: center"]3 1001 English 45 #CACACA[/URL] , align: center"]4...

Hi everyone, I promise I have searched the boards, but I just can't figure out how to solve my problem :eeek: It looks like I could use SUMIF, but I just can't get my head around how to do it. Basically I want to sum cells, not the same range, different ones within a column. The difficulty...

Please help A1 has the list has specialisation ( From a data validation list ) B1 has the semester no. ( 1 to 6) Now from Cells c1 to j1 the values should change based on the value of cells a1 and b1 like if the specialisation is marketing Management and semester number is 1 cell c1 till cell...

I have an existing Index Match formula which has been working fine when searching for a single string of text. What I'm trying to do now is to get a wildcard introduced so that if the course is called 'Subject A', it would also select the result if it's 'Subject A - North', 'Subject A - South'...

Hi, I'm trying to create a template so that I can have VBA prompt me to change items in the subject. I've got a template email with the subject line that should be Project / GC/Client, and in the template I've written that as #0# / #1 #. So far, I'm at the below, but it's erroring. Anyone...

I'm using a command button to automatically email a document. I have the recipient (srecipient), subject line (subject) and the body (sbody) text setup - I want to add additional recipient as a "CC". Any help on this would be appreciated.

I'm looking to enhance my conditional formatting to highlight the cell in column C if the content is not an option from the drop-down fields specific to another cell. My spreadsheet has two columns with different drop-down fields. Column B is the subject and column C is the Type, below is an...

Hi everyone I have an excel file with several sheets and i want to send every sheet as an attachment to certain people in to and cc in outlook .recipients are different for every sheet and I want to add subject and body of email too.( I want email to be ready with To CC Subject and body and...

Hi Guys, Apologies in advance if my post is not formatted correctly as this is my first question - this is a simple question that seems to have a complicated solution. In my spreadsheet I have 1540 book titles for each book title I have multiple subjects, e.g animals, children etc. I want...

Hi, this was working last week, now appear to be causing an error. I have 2 tables, one is called inbox and one is sent items. inbox has from, subject, cc, received time, powerapps id as standard sent items has the same plus some formula. Original Subject = if(left('Sent...

I'm not really sure how to do this or even if there is a way it can be done (but I'm really hoping it can). I need to find the days when a specific subject is taught. The subject name will always contain the characters 11a/En which will be followed by 1, 2, 3, 4 etc. At the moment my table...

I have a drop down where the user can select a name form the list which runs an Access query to return an email address for the selected person. I need the email address to be shown as a clickable hyperlink to open a new email and to be entered via VBA code which works on the Worksheet_Change...

Hi everyone, Is there a forumla to automatically adjust the "time" in a column when any specific row is modified? For example: <tbody> Time Subject 7:00 am 7:30 am 8:00 am 8:15 am 9:00 am </tbody> If I were to modify "7:00 am" by 15 minutes to "7:15 am", I would want all the...

Hi all, I need some assistance to create a macro for saving excel files from Outlook. 1. I will receive n number of excel files from outlook with same subject name. Example - "Tracking" is the subject name. 2. I need to open and consolidate those files in a single excel and save in my local...