nov

Hi, A simple one Im sure for the wizards on this forum. Would someone provide an idea to create a macro to select todays month. Details are below: Column A has a list of multipe records by month (see Exhibit 1) I would like to create a macro that goes to today's month (i.e top of 'Jan 2018')...

I have in column B non-duplicate information and I need to bold over 600 lines in the manner below. WGHI(Studio)(Los Angeles, Cali) Radio (Nov 1, 2017) - Top 10 Radio Station KAWG (CNBC)(NY, New York) Television (Nov 2, 2017) - Top 10 TV and so on and so on for 600 rows what I need is...

Can someone help me help me how to create a macro that would transpose the following amount in column to rows that match the dates, here is an example: Raw data from sheet 1: <colgroup><col><col></colgroup><tbody> Date Amount Oct 14, 2017 1 Oct 21, 2017 2 Oct 28, 2017 3 Nov 4, 2017 4...

Hi Excel geniuses, I have a report that lists multiple vehicles that are advertised on the internet. The list comprises of seperate entries for each time a vehicle has had the price changed. What i need from this list is the date of the last price change. Sorry for the sketchy example below :)...

Hi community, please bear with me this is my first post. I do have basic VBA knowledge but Im struggeling to achieve the following. I do have curve of forward pts from bloomberg or reuters as you can see from below html code. What I try to generate automatically is the yellow area. Basically...

Fairly new to excel. Wanted to know if it is possible to have a formula that looks at a particular column for specific value (i.e. City Name) and for every instance of that it would display a value in another cell on that same row. For example: Each row has the following fields: Date, Name...

I'm having difficulties writing a formula that would help me SUM the average job per day at my factory. Here an example of how my raw data looks like <tbody> Order total # of job start date finish date average job per day A 100 1 nov 17 1 nov 17 100 B 200 2 nov 17 3 nov 17 100 C 400 2...

So far I have this to create sheets: Sub SheetCopier() Dim x As Integer x = InputBox("Enter number of times to copy default sheet") For numtimes = 1 To x 'Loop by using x as the index number to make x number copies. ActiveWorkbook.Sheets("Default").Copy _...

I have the formula to sum a cell across worksheets, but I cannot seem to get it to automatically update when I add another worksheet. For now, I have sheets labeled for each day I work, such as Nov 1, Nov 2, etc. I have the formula now as =SUM(‘Nov 1:Nov 7’!L1). When I add a worksheet for...

Let's say T12 = 'Novice Dec =IF(ISNUMBER(SEARCH("nov",T12)),"5",IF(ISNUMBER(SEARCH("dec",T12)),"6","")) With the above equation, it will return "5". I want it only to return "5" if "nov" is its own word. IE in this case, it want it to return "6". Thanks for the help. Oscar

I have in a table 3 fields a Start Date / End Date / # of Equipment (Columns A,B,C) I want to be able to look at the month and see the sum of the required # of equipment. The issue is the number of equipment is being used everyday from start to end date. So quick example: Nov 1 / Nov 5 / 5 Nov...