Thread: Copy cell value into blank cells below (full worksheet)
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SimmoG SimmoG is offline
external usenet poster
  
Posts: 2
Default Copy cell value into blank cells below (full worksheet)
If I copy a pivot table to another worksheet I have loads of blanks in
columns e.g
75 Total BLANK BLANK
90 1-IDUGB 23/04/2008
BLANK BLANK BLANK
BLANK 1-IFIG9 17/12/2007
BLANK 1-IM4OK 29/01/2008

There is a trick to copy the above cell value to the Blank cell below using
Edit then Go To Blanks.. but i cannot remember the key strokes to complete it.

Reply With QuoteReply With Quote