Ignazio P.

If there is even just one cell with values in the row (i.e. a formula that returns zero because is referenced to blank cells in the same row) the row will be skipped. If there is a table format (which i use ìbecause of the many useful features, the append row will use the first non table formatted row. I hope this explains

I need data to be extrated and copied only in the first few columns cell when a row is appended. I noticed that whenever there is even just a formula, the row would be skipped. Is there a way to avoid this? I need some calculations to happen with the copied data

Thank you!