copy and paste multiple rows on autofiltered data not working
Posted on 2016-10-07
I have a worksheet with 5 fields, address 1, 2, 3, 4 and ZIP
I have created a custom field (A) with the LEN function, i.e =LEN(B2)
the reason for this was to identify where LEN = 0 means the address 1 fields is blank, and shouldn't be. I then filtered the data for where len = 0 , and tried to copy and paste the filtered data across into the missing address 1 fields. But it only lets me do this one row at a time, when I try and do this in bulk, i.e. 50 rows at a time, I get this error:
"This selection is not valid - There are several possible reasons:..."
is there anyway around this as going through 10000 rows manually is clearly not practical.