Thread: Worksheet to Worksheet skip blanks
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Treadstone Treadstone is offline
external usenet poster
  
Posts: 4
Default Worksheet to Worksheet skip blanks
I am trying to copy data from cells to another worksheet missing out blanks -
typically sheet 1 has data say in B1 D1 & F1 trying to get the data to sheet
2 occupying the cells A1 B1 & C1.
Reply With QuoteReply With Quote