1. S

    VB Maro for Excel

    Hi I am Preethi, Please help me in VB Script I have large excel file which I have to mail the particular line items to customers. (for example) <colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody> Code...
  2. S

    Automatically typing the whole list by the list name

    Hi there, I have stucked in the above said. I have named the lists. Like 12 different training given in April month, I named the training list by "April". Now I want to show it like if I select "April" in a drop down list, the names of all training should come in next or desired cells by list...
  3. P

    Index Match, sum if or vlookup?

    <colgroup><col width="64" style="width: 48pt;" span="7"> <tbody> Looking for the following resuts: Year to date Blue Florida April 20...
  4. I

    Please advise on my code

    Hi, I wish to transfer values from one worksheet to another worksheet given the values on three specific cells. I have some information for you. Worksheet G INCOME Current month in cell G3 Current year in cell J3 I then enter a date value in cell G5 Worksheet G SUMMARY Months range cell...
  5. M

    Index/Match question?

    With the following example; APRIL 500 MAY 550 JUNE 700 JULY 800 The above months are text rather than a date entry. In cell E1 I would enter a text month name. I need a formula that sums the data above for all rows starting April, up to the row matching the entry in...
  6. T

    Excel Formula - Find the next April from todays date

    Hi guys, I was wondering if anybody could help me with a formula to find the next April from Today's date? I've tried searching but I can't find a thing! Thanks in advance
  7. T

    Conditional Formatting using an If and statment

    Hi, Can someone please advise me how to use conditional formatting when you want to use to conditions in the same formula. Effectively a 'And' statement. So I want Team A below where it shows May 60% to be 'Dark Green' in conditional Formatting. The formula is in the 2nd table is the May value...
  8. P

    Clarification on use of MONTH and EOMONTH

    Greetings everyone! I have a question which I am sure can be resolved by this forum: Using the formulae shown, I get the results shown to the left thereof: 4 =MONTH(TODAY()) January =TEXT(MONTH(TODAY()),"mmmm") JANUARY =Upper(TEXT(MONTH(TODAY()),"mmmm")) It is unclear to me why the...
  9. S

    Data Link Issue

    HI all I have setup vba code to get comments from another workbook. It works fine until I close down all workbooks and reopen. Then then link has changed from =GetComments('[EPN - SPN - ROTA 1st April 2019 to 1st April 2020.xlsx]Rota 2019-20'!J35) to =GetComments('\\Ukpnforfs01\1$\Power...
  10. E

    Sumif with Index Match w/multiple criteria

    Hi all, I've got the following formula combining an index match with a sumif, but it's returning the wrong result. The goal is to sum all the values that equal what is in C8 that match column A on the Niagara Summary page, and then sum the values based on the index match criteria below. The...
  11. N

    generate weekly report

    can someone help to generate weekly summary per this file? raw data entries: <colgroup><col><col span="4"><col></colgroup><tbody> Date Status1 Status2 Status3 Status4 Week 02 April 2019 Approved Approved Approved Approved 14 03 April 2019 Reject 14 08 April 2019 Approved Reject...
  12. S

    Don't update formula after certain date

    I fear there is not going to be an answer on this, but I have a formula where it counts values between certain dates, however, as this is for a weekly stat sheet, I want the calculation NOT to update after a certain date.. ie if the stats are for week commencing 1A April, after the 8 April, I do...
  13. J

    How many times each month appears between dates

    Hello; I need a function (or 12) that tells me for each month how many times it appears between two dates. So let's say I have the dates 1.1.2019 and 31.7.2020. The output should be: January 2 February 2 March 2 April 2 May 2 June: 2 July: 2 August: 1 September: 1 October: 1 November : 1...
  14. R

    Excel transpose how to do.

    how can I transpose the info in EXCEL from....to <colgroup><col><col><col><col><col><col span="2"><col><col><col><col><col><col><col></colgroup><tbody> FROM excel in tab 1 code product Jan feb Mar April May June July August Sept Oct Nov Dec 31010054 3 49471 45847 53911 50423 53134...
  15. J

    Repeat a number X amount of times

    Okay so I have two tables: Count Jan Feb Mar April May June July 0 0 1 0 0 0 0 Revenue Jan Feb Mar April May June July 0 0 25 25 25 25 0 How do I make it so it repeats the 25 X amount of times starting from the count? Currently X=4 but this may change.
  16. D

    Dynamic Chart Range for YTD

    Hi all, I am currently going through the process of making charts dynamic by using named ranges and the OFFSET function. Most of our charts show 13 months and I have achieved that with a named range called Months_13 which is defined as below. =OFFSET('Input Screen With...
  17. J

    SUMIFS with Dates issue

    I am trying to do two formulas: The first is where it sums anything between K92:K1000 if the dates in F92:F1000 are less than April 30, 2018 here is what I put: =SUMIFS($K$92:$K$1000,$F$92:$F$1000,"<=30/04/2018") The second formula I want between two dates for example between May 1, 2018 and...
  18. M


    How would I use a Sumproduct to calculate V7, W7, X7 &Z7? (For April) I was able to use the Sumproduct for Jan, Feb, March, but am having trouble including April... <tbody> V W X Y Z Jan Feb Mar Q1 Apr 7...
  19. L

    Convert text to number in VBA

    Hello, I have 4 month: January, February, March and April in range A2:D2 January actually means 1; February - 2; march - 3 and April 4 I need a code, that converts month name to number and return number Lets say row 3: February, february, April, April = 12 (2+2+4+4) row 4: January, April...
  20. A

    Formula for counting data per month

    Hi I am trying to get a formula to calculate the amount of Y's and N's for one month i.e. April 18 per project and my dates vary from the beginning and ending of the month. My data is below: <colgroup><col><col><col><col><col><col><col><col><col span="2"><col><col><col><col><col><col...

Some videos you may like

This Week's Hot Topics