jun

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

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

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

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?

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

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

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

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

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

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

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

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

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"

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

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

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

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

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

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

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