feb

  1. R

    Required auto insert of Mismatch Data

    Hi Every one, I required a macro or Formula to Auto insert the Row after matching of two Spreadsheets Table 1/Spread Sheet 1/Work book 1 <tbody> Name ID Jan Feb Mar Apr May Jun Jul Aug Ravi 42 10 96 14 ravi 14 10 11 fbgsdf 52 246 455 5525 536 </tbody> Table 2/Spread...
  2. D

    Subtract an amount from a cell, then move and subtract from the next available amount

    Dear All, I have tried to subtract the Overdue Invoice Amount, It should go like below table. <tbody> A B C D E F G H I J K L M N O P Q R S T U V W X Y Z AA AB 2 AMT $ TTL DUE JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC PAID OD BAL. TTL JAN...
  3. R

    Calendar based on Month selected

    Hello all, A1 on sheet Log, will be a Month and Year only (Mar 2019) A2 Should be first day of the month selected in A1, Col A will have all the next dates of the month until the last 31st But what I would like is if I select Feb 2019 in A1 all the col A fill up until the 28th Feb (Cell A29)...
  4. R

    How to VLOOKUP specific month and year to find a value?

    Hi, I needed help and appreciate if someone could help me. Suppose the "search key" is 2 Feb 2019, and: Column:A Column:B 1 Feb 2019 $1,000 2 Feb 2019 $2,000 3 Feb 2019 $3,000 How can I use VLOOKUP, or any other formula if needed to get "$2,000"? Thanks...
  5. P

    Best way to calculate rolling 6 months average

    Hi, I have a graphing maxtrix tab that does all my calculations for my dashboard. The tab has the month names as the horizontal header Jan, Feb, March etc.. For each column /Month I have assigned a month number reference as well (not an actual month number) but a number position. ( I use a...
  6. S

    SUMIFS Units and skip such values

    <tbody> Units Amount Month 100 2300 Jan 100 0.10 Jan 200 1000 Feb -200 -1000 Feb 300 2000 Jan 300 -0.08 Jan </tbody> I want to apply formula in the column A Units and wanted to skip units if Values in column B is between -0.5 to 0.5, please help based on the...
  7. H

    SUMIFS Using 3 Distinct Criteria

    Good Morning, I was hoping someone might be able to help me out with the following question: I have built a spreadsheet that generates data on a monthly basis for 100 distinct "blocks" (January through December, vertically oriented, 100 times; the example below features only 2 months for 1 of...
  8. P

    Generating next worksheet tab name

    Have a work book with 12 worksheets - 1 per month called : Jan 19, Feb 19,Mar 19 etc I am trying to get a formula to read the next sheet in the series. I have it working fine when i manually input the next sheet number but would like say, Jan 19 to be able to calculate the next sheet name as...
  9. L

    Dynamic calendar and locking each month

    Hi peeps. I've come for your help and assistance again. I followed this video on youtube regarding creating a dynamic calendar so you can flip from month to month, without having to use multiple tabs. Which i thought would be great. The only issue i'm having is if a i enter data in any...
  10. P

    Summing a range and multiplying it by another

    Morning all, I have a feeling that SUMPRODUCT is the function I need for this but unsure how best to go about it Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb 1 1 1 1 0.8 0.8 0.8 0.8 0.8 0.8 0.8 0.8 3200 1800 2388 1200 1900 2460 3150 1578 3650 6504 6800 4506 I...
  11. L

    Offset Formula - Rolling total

    Hi All, I am working with a database that needs the rolling total of the last 3 months. For example, let say we are in June. One column will Sum the total of Mar, April, May. Another column for Feb, March, April. And the last one being Jan, Feb, March. I have figured out how to calculate the...
  12. U

    How to transpose

    I have data that is material description July Aug Sept. The forecast is below each month. I will like the format to be Mat Des Jan Forecast Mat Des Feb Forecast Essentially, I will like to transpose the months and Forecast. I hve 80 unique material numbers. What is the quickest way of...
  13. H

    Macro to create dates

    I'm way out of my depth and and not even sure if a macro like this is reasonable (I'm sure it's possible, it just may be more effort than it's worth). I have a series of days in column "A" (starting in row 3), 1, 4, 7, 3, 5, 22, 4, 8, 30, etc. The numbers are the day of the month. In Column...
  14. E

    Is what I'd like to do even possible?

    Hi, I've taken plenty of advise from this forum, so much so that I've only needed to register now, so thank you all. I get data from external sources in the form of a table that has every month of a year. I'm looking for a way to automate the transfer of a specific month's sum to another...
  15. M

    Multifaceted Sorting

    I've added my code below, although I'm nowhere close to my desired task. I'm trying to sort ws1 in a way that Column A (which contains either YES, NO, MDR, or DPL) will be in order of all of the YES & MDR together, followed by all of the NO, with DPL sifted throughout as required. From here...
  16. S

    Figures based on month selection

    Hi Experts - Please give any formula I want to get the figures in row 3 for each month based on selection of month in cell A1 as per the given example below, in Mar and Apr figures are showing zero Suppose if I select Mar in A1 only Apr should show zero rest of the months should take sum from...
  17. S

    Lookup with 3 conditions

    Hi Experts. I have data in sheet1 <tbody> AREA SKU JAN Feb Mar .. A 1001 10 50 10 B 1001 20 40 20 C 1002 30 30 30 A 1004 40 20 40 B 1003 50 10 50 </tbody> Sheet 2 Summary <tbody> AREA MONTH SKU VALUE A Jan 1001 10 </tbody> I need formula in cell D1 for SKU 1001...
  18. D

    How many days in each month

    Context: We have a check in date and a check out date. In order to reconcile every month, we need to see how many days for each booking get accounted to every month. So if a booking starts on jan 15 and end on Feb 4, we need to be able to report the 17 days booked in Jan and the 3 nights if...
  19. R

    Group Cells

    Hello, I am be asking to much but is there a way to group cells based on a date? I have a row with dates (I8:ID8) from Feb 11-Dec 27. Columns B8:H8 are tasks/completion/start dates and columns I:ID are conditionally formatting to fill based on inputs to B:H. My want is this: For today, I want...
  20. E

    Copy paste multiple columns to last row

    Hello everyone, Pretty much new here and in VBA. I am working on a internship project that just consumes too much of my time (please dont think I am trying to escape the task which I don't I am just looking for a better and efficient way of doing this monthly routine). On a monthly basis I get...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top