I am new to the VBA world and will really appreciate if you can help me with a VBA code that allows the following -
1. Checks for non-blank cells in the worksheet column B
2. Adds a static date for non-blank cells in column A in the corresponding row.
The current VBA codes on the forum allow the insertion of date for non-blank cell but only when data is keyed into the target cell and NOT when data is pasted or imported into the worksheet. I need a macro that not only inserts a static date in column A when data is entered into a cell in column B but also runs across a cell range in column B and inserts static date in column A for instances of data import and pastes.
Any help will be highly appreciated.
Bookmarks