ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   macro to input data on a specific date (https://www.excelbanter.com/excel-programming/349849-macro-input-data-specific-date.html)

RaY

macro to input data on a specific date
 
Here's the scenario.

I input data into a cell now, but the data needs to be updated at a later
date, not when it was input.

I want to use a macro to have the information updated on a specific date,
using sort of a "contains keyword...like the date in question...using the
date in the keyword to reference the date to input the data."

Let's say I have an account that I need to have deducted($), but it is going
to be electronically done on a later date, I just want to enter the
information now, so that I won't forget to do it later. Having it
automatically input on the later date. The workbook is used a regular daily
basis, so the date won't be skipped.

Hope I explained this correctly. Tried to word it a few different ways.


All times are GMT +1. The time now is 05:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com