List of data needs to be filled in using a copy routine

[slamanager]

Hi,

Very basic but for people who cannot code its **** hard.

list of data up to 20,000 rows may be more or less with three columns of data only column c if entirly filled in. Randomly in column a and b you will get a name showing there is never just a first name or surname these always match.

example
a1 first name
b1 surname
c1 data(scores)

but this is where it gets interesting ----

how do i fill all the gaps where there are no names against scores so i have a complete a column and a complete b column last time i did this my fingers fell off. There must be a easy macro loop

Many thanks

 

[Mel Smith]

Hi,

Have you tried "block"selecting your data and then do Ctrl+F, choose replace and in the top box leave it blank and in the 'replace with' box type some suitable text e.g. left blank, and then hit the Replace All button.

Crude, perhaps, but effective!

Mel

 

[slamanager]

The reason I was looking for a code routine is that the data spans 20,000 rows and to go through say 1000 student names and copy then into all the blank cells is so time consuming.