I'm assuming that what I'm requesting requires me to mess around with VB.. (although it's always frustrating for me).
My Column A contains numbers but some cells contain nothing (or technically, they contain --> "").
Is there a code that can constantly be "looking" at Column A and copy & pasting (values) its contents into Column B BUT WITHOUT ANY OF THE BLANKS?
Example..
Column A will look like this:
1
2
3
[BLANK]
4
[BLANK]
5
And thus, the first five rows of Column B will be filled in with numbers.
Bookmarks