Copying Data to empty cells, stop, copy new

December 23, 2010 at 03:02:03
Specs: Windows 7
HI
I have a very large file with over 50 thsnd entries, in one column I want to copy the cell down the column to fill all blank cells, then copy the new data and copy that down to all the blank cells, etc.. so in A1 I want to copy the data automatically down to E1, then the data in F1 i want to copy down to L1 etc..etc... does anyone know the best way to do this?
A1 = 0589631
B1
C1
D1
E1
F1=04658795
G1
H1
I1
J1
K1
L1=465879546

See More: Copying Data to empty cells, stop, copy new

Report •

#1
December 23, 2010 at 14:02:56
re: "so in A1 I want to copy the data automatically down to E1, then the data in F1 i want to copy down to L1"

A1, E1, F1 and L1 are all in Row 1. You can't copy down in a Row.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question