Worksheet to Worksheet skip blanks

  • Thread starter Thread starter Treadstone
  • Start date Start date
T

Treadstone

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.
 
Select B1,D1&F1 and press Cntrl+G>>Special>> Check the Visible cells only
Option Button and give Ok. Now do copy and paste.

Remember to Click Yes, if this post helps!
 
Filter your data for non blanks then highlight data, click ctrl+G (or Edit +
GO to), click special,t hen visible cells only then OK
Click yes if helped
 
Back
Top