autofill date

  1. R

    Autofill date if a change happens on the row

    Hello, I am new to excel and I used a code I found on this forum to autofill the date of day depending if any change happened on the row (I was not able to find again the thread). I used this VBA code : Private Sub Worksheet_Change(ByVal Target As Range) If Target.Cells.Count > 1 Then...
  2. D

    Insert Date in Next Column When Entering Data

    I'm a newbie trying something that might be simple. When I type data in column B, I'd like column C to automatically fill in today's date. That's it. It has to be easy, but I haven't figured it out. Thanks in advance for the help!
  3. S

    Creating Charts - Avoiding autofill of dates, adjusting width, and stopping overlap

    I was at work the other day, coincidentally creating a combo column/line chart on the migration from Office 2010 to 2013, and had some issues creating a chart that looked decent. This was on Win 7 x64 Enterprise with Office 2013 Pro Plus x86. Example data below <colgroup><col width="64"...
  4. J

    Macro to Autofill Dates between Start Date and End Date

    I am looking for help re: macro code for the following: - I have numerous rows of data, each with a start date (column G) and end date (column H) - I am trying to write a macro that will populate all dates between, including start date, across each row, beginning at column L and populating to...
  5. E

    VBA Macro to fill in blank date cells with same preceding date?

    Hello all, I received an excel report that uses an unfortunate layout. Here's a sample: <tbody> 1/27/2014 Item 1 $10 Item 2 $20 Item 3 $50 Item 4 $40 1/27/2014 Total: $190 1/28/2014 Item 1 $50 Item 2 $40 Item 3 $70 Item 4 $100 1/28/2014 Total...
  6. B

    VBA to autofill date in every other column

    I need a vba code that will take a date entered in C1.. for example 1/1/11 and autofill the the next date (1/2/11) in E1...and so forth for G1,I1,K1,M1,O1 ive searched and searched and only seem to have found 10 more ways not to accomplish my goal.
  7. K

    Formulating a DUE DATE

    I am using excel 2007 I know this is simple for you Pros but... All I need to do is enter a date value in column A and have Column B autofill and increase that date by a give period (i.e. 2 weeks) Something like this Check out Date: 2/2/2011 (Column A) Due Date: 2/16/2011...

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
Back
Top