Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
skip to worksheet | Excel Worksheet Functions | |||
skip blanks | Excel Worksheet Functions | |||
skip printing worksheet | Excel Discussion (Misc queries) | |||
Skip Over Blanks | Excel Discussion (Misc queries) | |||
Paste Special Skip Blanks not skipping blanks, but overwriting... | Excel Discussion (Misc queries) |