today's date

Hi everyone, Asking for assistance. Can anyone help me? I want to copy specific cells using VBA Macro based on TODAY() date. I have 10 worksheet and each worksheet have 2 column, 1 for Date and 1 for DataToPull. I want to pull the data based on what today date. Can anyone help me? Thanks!

I added a check box in Excel that returns "TRUE", "FALSE" in cell D38 Then added this formula =IF(D38="TRUE",TODAY()) to D34 where I want today's day to display if the checkbox is "True". Seems simple and would be very usefull but it doesn't work. Any suggestions for syntax?

I'm sure this has been answered as I've read similar post on this forum but none matched what I am doing exactly and I need to get this fixed quickly. I apologize if this is a repeat, but I have a simple formula on a cell that when the value of the cell is not longer empty, or an employee...

Hello. I am trying to add this to a longer VBA code I have. I need two separate codes. Both of them I need Excel to save the active workbook with the file name (one being Pickorder1 and one being Pickorder2) along with today’s date. So save it to the Desktop regardless of user as this will be...

Hi there, I am trying to create a document where new field entries will be added everyday with differing amounts of new entries each day as it depends how many calls we receive from customers that we need to log. What I ideally would like is for today's date to automatically appear on a new...

I have the following code generating a run time error on a protected sheet. Error message is: Method "Goto' of 'object' _Application failed This is used to simply lookup the current date. The issue begins at "Application.Goto Rng, True" Any assistance would be appreciated and thanks in...

Hello All, Background: I've been using this bit of existing code to filter out and delete all the rows I don't need. It's a tad clunky bit of code but works amazingly well and no complaints. Dim iRow As Long For iRow = 10000 To 2 Step -1 If Cells(iRow, "A") <> "Nation*"...

Dear all, I have a range filled with dates as such: <tbody> A 1 Date 2 01/07/2015 3 4 01/08/2015 5 01/09/2015 </tbody> I am planning to use Worksheetfunction.countifs to count the number of dates that are smaller than today's date as one criteria. In excel this would have been...

Hi there, I wonder if you could help : I have 2 tables : table A : showing the consumption of 1 product every day. So we have the actual consumption and the forecast consumption in the same column. Example B2 = 14.08.2015. C2 = 96 B3 = 15.08.2015. C3 = 105 B4 = 16.08.2015. C4 = 100 B5 =...

I have been bogged down with this for a couple hours now, so I apologize in advanced if this is poorly written - any help is greatly appreciated. Fiscal Year Calendar Ranging from AH:CO as follows Row 9 (Years from 2015 to 2019) Row 10 (Months from 1-12) Row 11 (Number of Widgets, found via...

Hello, I am working in google spreadsheets and need a few things to happen: 1.) Autofill 3 months worth of dates in relation to today's date in specific cells 2.) Automatically hide a column if the date in a specific cell is 30 days prior to today's date and 30 days after today's date 3.) On...

I am currently using excel 2007. I am trying to build a formula that will do a SUMIF based on the current date and adding all months prior to the current date. The data that is being shown is arranged by month in 3 sets of columns per month (goal, actual, percentages). The goals are inputted...