Forum Discussion

neil4444's avatar
neil4444
Copper Contributor
Sep 07, 2021
Solved

Possible to copy data from one cell to another when today = certain date/time?

Hi everybody, first time discussing here.   I'm working with Office 365, Win10. I'm not great at formulas. My team has a few different bundles of equipment that move from location-to-location every...
  • HansVogelaar's avatar
    HansVogelaar
    Sep 07, 2021

    neil4444 

    The code should go into the ThisWorkbook module, not into the worksheet modules.

    And it does need modification to work in two sheets and with merged cells.

    See the attached version - the cells should be moved when you open it and allow macros.

Resources