startdate

I'd like to create a 'pseudo' gantt chart of sorts My Project data is on Columns A:U, TimelineDates start in Column V, Column A is the Project number and is always a number, never blank or NULL, There are 2 header lines, so the Project data starts in row A3...

Hello I have created a userform that allows users to filter a worksheet. But I can not get the filter to work for the month and for the blanks I have this so far: Filter month (combobox2 = month name) Dim startDate As Long Dim endDate As Long startDate...

Hi All, Can anyone tell me why I am receiving the Pastespecial of range class failed error when trying to paste a copied range of rows from one workbook to another? My code is below: Sub GetPricingData() Application.ScreenUpdating = False Dim StartDate, EndDate As Date Set MySheet =...

Hi, I have the following code to search WB2 for data in a date range and place the data from each row into WB1. The issue I am having is if the 'Cancel' button on the 'InputBox' is pressed it just errors and drops me back into the code. I've tried alsorts but can't seem to get round this. If...

Hi All I have read a few forums but I am now stumped and hope some one can help me I have managed to create the pivot table using VBA and I can filter the rows and columns in the table but I cant filter the date range required Not sure how to add Sample data but I have the following fields with...

Hi guys, I have been reading this forum but never joined until today. I have an issue. We have an Excel spreadsheet that has multiple macros running in it and was created by another controls engineer at out plant. He has since moved on and we are now trying to run his Data Query that is in the...

I've written a basic macro with extracts records based on two dates: Sub extractDataBasedOnDate() Dim lastrow As Long, erow As Long, i As Long Dim mydate As Date Dim StartDate As Date Dim EndDate As Date StartDate = Worksheets("Expense Report").Cells(3, 1).Value EndDate =...

Hi Guys, I'm relatively new to VBA (I bet you haven't heard that before) and am working on a Master spreadsheet to store some basic research funding application info and report on it. Each row in the main data sheet has a reference number (Column A) for the funding round that it was submitted...

I am new to Excel vba and am trying to filter records based on certain column selection. 1st I would like to filter out all #Div/0 errors and 2nd I would like to filter for only records ">=" a user input box. I'm using the following code: Dim StartDate As Long Dim temp As String temp =...

Hello All, I am new to Excel, and working on a project timeline. I am trying to insert a number of days in column "b" for the amount of time each job will take. In column "c" I have the start date, and in column "d" i have the end date. I would like it to work so that when I enter the days...