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.
I need to copy data to another workbook based on the date (monthly reporting)
So i need to for example look up 20210228 and copy data from IP TV Fault Rate = 71 and copy it to another workbook.
And next month look up 20210331 and copy data from IP TV Fault rate = -6836 to another workbook.
The values in this sheet is just a simulation for testing.
Hi guys
Im looking for some tips to transfer data from one workbook to another.
The script has to include if statements to if the date is 23-03-2021 in the header, the script should be able to locate the value matching the date.
Any ideas? Haven't done any copy/paste scripts before or maybe where to start.
Thx
