Hello,
Can you please help me with the following Macro?
Copy (R17:S17) and paste all the way down R:S (>row 17) until data stops, then delete all cells in (R:S) that have "#value!" and the cell above it.
The cells to delete would look similar to attached pic...
Thanks!
Can you please help me with the following Macro?
Copy (R17:S17) and paste all the way down R:S (>row 17) until data stops, then delete all cells in (R:S) that have "#value!" and the cell above it.
The cells to delete would look similar to attached pic...
Thanks!