1. 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...
  2. D

    Get Values in Text Box based on Check box Selection

    Hi All, Need a help on resolving the below scenario. I have a column A with Months and Column B with unique products ID's. Each months are having checkbox and i need based on the check box selection, the text box and excel sheet should be updated with the all the products from that specific...
  3. Z

    Populate cells with array

    I have a macro that populates a range of cells with the months horizontally, but am getting an error when I try to make it vertical. Horizontal: ActiveCell.Resize(, 12) = Array("Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec") Vertical: ActiveCell.Resize(12, )...
  4. N

    Help with a Workbook issue

    Good morning I have a workbook which has 9 individual Dept sheets to record travel costs. I am looking for help in calculating the total monthly cost on each sheet and transfering that figure into the correct month on the summary sheet. <colgroup><col width="64" style="width:48pt" span="7">...
  5. M

    find the first cell in a row that is >=0

    I am trying to find the cell in a row that is >= 0% <tbody> Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec -0.3% -0.2% -0.1% 0.1 0.2 0.3 0.4 0.2 0.5 0.1 0.15 0.1 </tbody> In the table above i need to return Apr as the first month where the percentage is >= 0
  6. A

    Filling worksheet reference

    Hi i'm trying to fill a formula where the reference will sequence the worksheet tabs i.e if worksheet tab 1 is Apr, tab 2 is May etc then by having a formula referring to worksheet Apr and dragging the formula down it will fill the sequential worksheet tabs, is this possible i can't seem to make...
  7. S

    Change month automatically in pivot table

    I have many sales pivot tables showing columns of Current year, last year and plans. Last year and plan data is from Jan to Dec and actuals pasting each month. Now when I refresh to get YTD Apr results for example I need to select Apr manually in each pivot to change the YTD result Is there...
  8. 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...
  9. P

    VBA remove decimals

    Hi all, I would like to use a VBA code so that to clear the numbers’ decimals which contains space before comma e.g. 26 ,7 should be 26 Therefore that, the code should run through col. “C4” : “O” and rows down. Please see below an extract of original data and the expected result. Thank you...
  10. A

    Graph Advice

    Fairly experienced user of Excel but not really used anything more than a basic column/line graph for using two columns of data. I now have three columns of data and i feel like, with experience, it may be possible to work out a way to show the data in a useful manner - Though i haven't got a...
  11. S

    SUMIFs or any other excel function with multiple criteria

    Hello there! Can you guys please help me with my problem. i know this is very easy but to be like novice in excel, I don't know how to formulate below. Please help. Replies is very much appreciated. Result : Sum the quantity based on Type, month and destination. Thank you in advance...
  12. B

    YTD on multiple columns

    <colgroup><col span="24"><col><col><col><col></colgroup><tbody> I need to some help to sum the coloums from month to calulcate the Year to date, the problem is I have two type of columnes I need to sum </tbody> <colgroup><col...
  13. R

    Create complex folder and subfolders

    Hello, What code can I use to create a folder - say 2018 (ask me what year I want) in that folder, automatically create subfolders with months of the year, and in each subfolder with the months of the year, create one file with the sheet names of the days. The name of the days can be 1, 2, 3...
  14. M

    INDIRECT function

    Hi guys Love Mr Excel and usually I can figure out what I need but am going round in circles here, so help would be much appreciated. In my workbook I have a sheet called "Summary" where I am picking up information for each month. The names of the months are in this sheet in cells B1 to M1...
  15. R

    SUM Points from Beginning of year to Today

    Hello, I have a table that looks like this (It goes all the way to December); <TBODY> Employee # Jan Feb Mar Apr May Jun Total 123 4 -5 6 2 -5 -5 7 456 -5 -5 6 4 -5 -5 0 </TBODY> If the current month is Apr (based off of TODAY() or some other cell) then I need to total Jan through Apr...
  16. T

    Counting consecutive values that appear a set number of times. CountIf?

    Hi Guys, Hope you can help! If you guys could help me with this I would be hugely grateful as this would save me sooo much time every month. Basically, I want to count the number of times 1 appears in 3 or more consecutive cells. Each cell only contains a 1 or 0. <tbody> Name Apr 1st Apr...
  17. M

    Prepaid Excel Tracker

    I want to prepare a prepaid expense tracker in excel. But get stuck at certain places. I have an Invoice for goods/ services for $120000/- for the period 15 April 2017 to 14 April 2018. My financial year is from 1st April 17 to 31 March 2018 I have received this invoice on 25 Jun 2017 and...
  18. M

    VLOOKUP in Conditional Formatting Inconsistency

    Whilst there are a number of similar examples on here, none quite hit the nail for my problem. Each month I am required to compare a course catalogue, identifying any new courses that have been added and any that have been deleted. The worksheet is exported from a SharePoint site into Excel...
  19. R

    INDEX MATCH or VLOOKUP Multiple Criteria

    I'm thinking this might have to be an array of some sort, but here goes nothing. I have a tab that pulls 2 different codes, TA and TZ. Each tab uses EDIPI (individual unique identifier). I want to match in 4 separate columns the following; TA Code, TA Code Date, TZ Code, TZ Code Date I created...
  20. G

    Editing multiple cell Formulas to point to new sheet

    Hi Excel Gurus. I have 36 cells to update and each cell has formulas that points to a sheet, which will need to point to a new sheet. Here is one of the cell formulas: =COUNTIFS('Apr 15 - 21'!$D:$D,Summary!$K$12,'Apr 15 - 21'!$C:$C,Summary!$K$13,'Apr 15 - 21'!$E:$E,Summary!C2)+COUNTIFS('Apr...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back