1. T

    Find closed date and next one open

    Fellas, I have 2000 service order by VIN's in column A (sheet1) with different closed dates (example, VIN# 111 service order completed on 1 Jun2019. In the sheet2 I need to find if VIN 111 when is next service order open after 1 Jun or next one (see example below: sheet1: <tbody> a b VIN...
  2. J

    VBA: Intersect/Match Row and Column to Select Cell

    <tbody> Eggs Sausage Toast Bacon Jun 1 Jun 2 Jun 3 x Jun 4 </tbody> Hello, I'm looking for a code to find matching column and row and select that cell. For example, for Sausage and Jun 3, select the 'x' cell. I'm thinking of the cell.find coding but I think that's...
  3. B

    Retrieving Variable dates from Filenames

    Hello all, Long time lurker, first time user.... So I am trying to retrieve dates from a lot of filenames. The dates and file names can be variable and I am at a loss... Ive been messing around with right() mid() Left() split(), but no luck... Here are a few examples for file names. text -...
  4. mikecox39

    Can I create a "Button" on a sheet that only becomes visible in the month of Jun?

    Every year, in June, I create a new workbook from the current workbook. I have a macro the does all that and I put a button on the current workbook to run it, but I want to hide it until Jun, so no one will hit it mistake. Can that be done?
  5. R

    A lookup with a SUM function?

    Hi all. A col has Dates in them this sheet is called "Log" Col A Col B Col C Wed, 19 Jun 19 5:30 6:40 Fri, 21 Jun 19 1:49 1:23 Fri, 21 Jun 19 1:11 Fri, 21 Jun 19 1:33 3:12 I have another sheet that has dates for JUNE sheet name...
  6. B

    Date from timestamp string

    I have a device for reading blood pressure. For each reading it reports (along with blood pressure numbers) a timestamp in the format: Jun 16 2019 06:01:44 I want to extract just the date part (Jun 16 2019) which I will then convert to an excel date number (e.g. 43626). How can I do this? Can...
  7. 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...
  8. I

    sparkline refresh

    Hi guys i have the data below <tbody> name jan feb march april may jun jack 10 15 17 17 </tbody> I have created a sparkline based on this, I dont have the data for may and june as of yet. Can i set this sparkline up so it automatically updates when may and jun data comes? at the...
  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. 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...
  11. V

    Recurring 12 month formula in excel

    Hello All I work on a huge database that get updated each month with fresh data. The date on this data is captured in MMYYYY format. Now at times i am asked to build a report on a rolling 12 month basis ex. Jul 2017 to June 2018, Jun 2017 - May 2018, May 2017 - Apr 2018 so and so forth...
  12. S

    Indirect Formula not working - Returning specific cell data with file located in touchpoint (aka sharepoint)

    Hi all, I'm trying to pull data in a document that is stored in touchpoint (sharepoint) called "Monthly Cost Report Master Jun 2018.xlsx". This document is created quarterly so obviously Monthly Cost Report Master sep 2018.xlsx does not yet exist. I use the following formula, and it works...
  13. 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"
  14. A

    Using VBA to Copy Paste onto another Workbook

    Hi I am trying to copy paste filtered data using VBA onto another workbook under 4 separate sheets but it doesnt seem to work Sub Macro1() ' ' Macro1 Macro ' ' ActiveCell.Offset(2703, 1).Range("A1").Select ActiveSheet.ListObjects("Table132415").Range.AutoFilter Field:=3, Criteria1 _...
  15. redspanna

    Personal Best times - highlight range in row

    Hi all I have a small (hopefully getting bigger) database of running stats populating columns A:T I would like my PB (Personal Best) times for each type of training I do highlighted using a specific code that populates cells through column C For example I would like my PB highlighted where...
  16. J

    Adding then next letter to a column letter list

    Hi, I am trying to create a forecasting spreadsheet which looks at previous years data to build a forecast for the month/year. I am trying to make the lookup cells dynamic according to the date. For example, May runs from columns DT:EX and Jun runs from EY:GB. So in May, I want the lookups to...
  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. S

    Month's accumulated Numbers

    I want formula to bring cumulative days number based on the month, need formula please. Suppose month is Mar I want from Jan to Mar 90 and remaining months Zero If month is Jun the figure from Jan to Jun should be 181 and remaining months Zero, so on so forth. Jan 90 Feb 90 Mar 90 Apr 0 May 0...
  19. H

    Fill Value from a table

    All, What best formula can be used to transfer this table below A1:B5 to table C1:O2? <tbody> </tbody> <tbody> A B 1 Month Cost 2 Jan 100 3 Apr 250 4 Jun 200 5 Aug 0 </tbody> This result what I am looking for as per table below. When B4 equal zero, B3 value...
  20. P

    Counting with multiple criteria

    Hi, Column AT has dates in date format (1-Jun-2018, 2-Jun-2018, etc until end 30-Jun-2018) Column AU has dates (date format) but display is weekday format (ie Mon, Tues, Wed..) Column AV has numbers on certain days for example 1 Jun 2018 could have 3, and 17 Jun 2018 could have another 3 etc...

Some videos you may like

This Week's Hot Topics