View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kanga Kanga is offline
external usenet poster
 
Posts: 6
Default empty cell = above cell

Hi,
I have pivot tables that I need to convert into plain columns. So I copy and
paste the values into a new worksheet. Is there a way that I can (with a
macro) fill in the blank cells with the value located in the cell right
above? Keeping in mind that the cell length will vary...
Thanks in advance!
Géraldine