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.

Worksheet to Worksheet skip blanks
 

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
--
Greatly appreciated
Eva


"Treadstone" wrote:

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.

Worksheet to Worksheet skip blanks
 

Select B1,D1&F1 and press Cntrl+GSpecial Check the Visible cells only
Option Button and give Ok. Now do copy and paste.

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"Treadstone" wrote:

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.

Worksheet to Worksheet skip blanks
 

Copy paste sort



--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Treadstone" wrote:

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.