I want to transfer the value in the current column to antoher workbook with the same column like 20210331 with a blank cell.
So just a copy/paste script with if statements who look up the date and transfer the current value to another workbook with the same column name but an empty cell.
The workbook is already made. The script doesn't have to create a new workbook.