#vba #dates

  1. H

    How to add new row each day automatically below current data.

    I wrote this VBA code to fill in missing data up to current date. The problem is that is fills it in above my current data, not below which messes up everything. How can I fix this? This is table. VBA Code
  2. M

    VBA automatic due date adjustment with conditions

    Hello any help given is much appreciated I am quite new to Macros and VBA I am trying to modify a scheduling spreadsheet for Time Based Maintenance, the sheet has a list of TBMs and the frequency they need to be done (Weekly, monthly, yearly etc) and the next due date they need to be planned for...
  3. M

    Dates Separated into Columns (e.g. 2016, 2017) into a single Column called 'Year'

    Hello all - I am really struggling with some ETL and I was wondering if anyone has a good way either with VBA or a built-in excel tool to transform a data set I've been working on. My problem is this: I have a source data set that has months separated into multiple columns with a different...

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