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. M

    Picking and copying data from another sheet

    Please can someone help with a formula or VBA script. I have one workbook (payslip sort) that contains several sheets (one sheet per person that contains a breakdown of their pay) - I have another workbook (payslip macro) that contains a list of names in column A and next to their names in...
  4. 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, )...
  5. 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">...
  6. R

    Populate a column with the dates of 1st, 3rd and 5th Mondays between two dates...

    How to create a list of dates of every 1st, 3rd, 5th Monday each month between two dates? I have in cell A2 (01 Jul 19) the first date and in B2 (30 Jun 20) the second date. How do I populate column C with the dates of every 1st, 3rd, 5th Monday each month between 01 Jul 19 and 30 Jun 20...
  7. 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...
  8. Wimpie

    unique left/right or mid formulas needed

    Good day Please see the blow, al in A2 and A3 <tbody> 18 Jul Rtc Credit Eco Smart 0672564266 8,000.00 Cr 10,886.96 Cr 18 Jul FNB App Payment To Shipping - Nancy Usa Sarah Cronin Designs 7,425.80 3,461.16 Cr 3.75 </tbody> I need 2 fomulas 1 - i need to extract the 1st mount in one column...
  9. K

    Insert # Rows based on numeric cell value and copy entire row to all inserted rows help

    <tbody> Location # Month Year NYC 5 July 2019 Florida 3 August 2019 Mass 1 October 2019 </tbody> I have a workbook with the above information: I would want it to look at column B, (#) and then insert 5 rows where the #= 1, so 1,1,1,1, instead of the 5: <colgroup><col...
  10. D

    Mid formula, but stop if there is a space?

    Hi everyone, I'm sure this is simple but I can't find the solution online. Is there a way I can use a MID formula like this that follows this, unless there is a space, in which case it stops earlier? I have text, for example: <tbody> Tue, Jul 31 09:38:21 BST 2018 and Tue, Mar 6 14:26:37...
  11. J

    Sumifs with or, question

    So I have a sumifs formula I need to make and here is what I have. =SUM(SUMIFS(D:D,H:H,"Jul 2018",E:E,{"*AMZN MKTP*","*AMAZON MKTPLACE*"})) It doesn't seem to be working but what I am trying to say is, Sum column D if Column H has Jul 2018 and Column E has AMZN MKTP or AMAZON MKTPLACE. What...
  12. G

    Canot change format of a cell

    Scratching my head on this; I copied a date from the web 'Jul 3 2018' and when I try to format(excel 2007 PC) it in VBA to dd/mm/yyyy but it doesn't change. I even tried paste special: Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _ xlNone...
  13. J

    Need help with formula.

    For the table below, I need formula that will calculate the number of straight Time Hours btw the clock in and clock out times, but I also need it to add an hour for everything break hour that is worked through. I tried a combination of conjunctive IF's with AND/OR with no success. Any help is...
  14. S

    Multiple Yes/No formulas

    <tbody> A B C D E F 1 Initially Approval Issued Projected Begin Date Projected End Date Final Approval Today's Date 2 23 Jul 18 3 Yes No 22 Jun 18 10 Nov 18 Yes 4 Yes Yes 25 Aug 18 10 Nov 18 Yes 5 No Yes 18 Jul 18 10 Nov 18 No 6 No No 2...
  15. Liberty Prime

    Changing the format of the date (From text to number)

    Hi, sort of recurrent topic, but I would need some help regarding this case. Because I work with a third party tool that pulls out different reports to be later processed in excel, I'm a bit stuck since they have run a recent update in which they have changed the date format. Before it was...
  16. 6

    Pivot Table & Dates

    Hi......help. I am trying to pivot some data. The source data contains dates, such as 01/07/2016 (1st July 2016). However, when I select the date to incorporate into my pivot table the date 01/07/2016 does not appear. Instead, I have columns headed month, quarter & year. Years Quarters Date...
  17. P

    Date Conversion From PDT/PST (to) IST

    Hi All, I'm looking for a Date(in text format) to convert from PDT/PST to IST using Excel/VBA. Kindly help. Thank you. Example: "Tue Jun 30 11:30:00 PDT 2015" Result: "Wed Jul 01 12:00:00 IST 2015"
  18. tycasey17

    Feeding Information Based on Dates

    So I have a table with all my yearly information on one tab and to feed another tab <tbody> MONTH START DATE END DATE 10 OCT 1-OCT-17 2-OCT-17 11 NOV 1-NOV-17 2-NOV-17 12 DEC 1-DEC-17 2-DEC-17 1 JAN 1-JAN-18 2-JAN-18 2 FEB 1-FEB-18 2-FEB-18 3 MAR 1-MAR-18 2-MAR-18 4 APR 1-APR-18...
  19. M

    Counting occurrence of date in date range being string format

    I have a date ranges as per below. one range per cell. in the next column i have month and year from any of the below ranges. i.e Oct 2019 I need to count occurrence of of Oct 2019 in the third column in the row corresponding with the actual range, which is Oct - Dec 2019...
  20. C

    Return row based on most current date when multiple instances exist in the column.

    Hello all, First, my apologies if this question already exists. I have looked, but haven't found my particular problem discussed. Current raw data: JOE RED 10 MAY 2001 JOE BLUE 10 JUN 2001 JOE GREEN 10 JUL 2001 FRANK RED 10 JUN 2001 FRANK GREEN...

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