I've tried this a million different ways and it doesn't seem to work.
Copy a range of cells that contains empty cells, right-click paste special, select values and skip blanks. The exact same range is pasted in, blank cells and all!!!
How is this supposed to work? Is this a bug or is this user error?
Copy a range of cells that contains empty cells, right-click paste special, select values and skip blanks. The exact same range is pasted in, blank cells and all!!!
How is this supposed to work? Is this a bug or is this user error?