Thread: filling list
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
HAK HAK is offline
external usenet poster
 
Posts: 2
Default filling list

Hi,
I have huge list with columns and rows partially filled
I want to fill the empty cells with the same value of the last filled cell,
column wise
For example:
A B
55 2
7
2
2 7
8
I want that table to look like this:
A B
55 2
55 7
55 2
2 7
2 8

My list is very huge and it will take me for ever to drag cells

Please help
Your quick response will be highly appreciated