View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Martyn Martyn is offline
external usenet poster
 
Posts: 4
Default extracting information from populated cells

I have incoming emails which use an excel spreadsheet. I
need to set up a macro to extract all the populated cells
information and export to another excel file. I then use
information for printing labels so if there are loads of
blank entries then i have loads of wasted labels. The
problem is that cells (A:U/1:7) is taken by company logo.
Is there a way to extract just information from populated
cells from (A:U/7:??) Im new to vb so some code would be a
godsend!
Many thanks