the code it deletes the formula in all rows that data was not transferred to in the dest sheet
Hi,
In one instance you are clearing the formulas in column 7 in the range A2:M80
In a second instance, if conditions met, you would have been overwriting even if they weren't cleared (A2:N80)
Looking at both code lines, you are clearing cells to row 80 (including formulas) but may not be utilizing all of the 80 rows with cleared cells in column G because of your conditional statement. That is why rows that data was not transferred to have no formula.
Both ranges involve clear or overwrite rows in column G. I would suggest to either move you formulas to column 15 or paste in an area beyond column 7. If you want to keep the sheet in the current format, I would delete the line that clears the range and add after the conditional statement a code line that erases the row prior to transferring the data to it. This way you are clearing only the rows that will be written to.
HTH,
Maud
Bookmarks