Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eva Eva is offline
external usenet poster
 
Posts: 197
Default 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.

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 506
Default 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.

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,836
Default 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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
skip to worksheet raraschek Excel Worksheet Functions 1 March 28th 07 02:42 PM
skip blanks Robin Krupp Excel Worksheet Functions 6 April 4th 06 01:46 PM
skip printing worksheet rw Excel Discussion (Misc queries) 4 January 23rd 06 08:46 PM
Skip Over Blanks Kenny Excel Discussion (Misc queries) 0 August 3rd 05 11:26 PM
Paste Special Skip Blanks not skipping blanks, but overwriting... gsrosin Excel Discussion (Misc queries) 0 February 22nd 05 04:33 AM


All times are GMT +1. The time now is 06:25 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"