Fill in the blanks

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
Im new to VB and need to accomplish the following.
My spread sheet (a .txt file that I am importing) has 6000+ lines. If any
of the data from one line to the next is duplicated the cell is blank
Example:

cat feline black female
white male
tabby

So across the used range. if the cell is blank I would like to copy in the
same entry as the cell above it
to give:

cat feline black female
cat feline white male
cat feline tabby male

Thanks for all replies
 
THanks Jim
Sometimes one cant see the forest for the trees. Ive used visible cells for
a while now and had not seen the blanks options. Mission accomplished!
Thanks again
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create query that sums up categorical data 2
Fill in the blanks 1
Fill in Blanks 6
fill in blank cell 1
Multi Formula With Exclusions For Jail Inmate Count 2
Validating cells left blank 4
Conditional formatting and Dropdowns 1
Filling out forms and make one cell entry appear the same in anoth 2

Back
Top