Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I avoid copying data into blank cells
I have data in cells in rows C,D,AF&BL Im copy and pasting to another
worksheet. What im trying to do is if there is not data in cells in row AF&BL I dont want it to copy the column onto the new worksheet. Cells in row C&D will always have data in it. I.E 1) column no 3 has data in row C&D but NO data in AF & BL . I do not want any data in that column(inc columns c&d) copied over. 2) column no4 has data in row C&D and also data in either AF&BL this one I DO want copied over. When I mean copied over I mean the data in cells C,D,AF&BL. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I avoid copying data into blank cells
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I avoid copying data into blank cells
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can i fill data in blank cells after copying a pivot report? | Excel Discussion (Misc queries) | |||
How do I avoid copying data from hidden rows/columns? | Excel Discussion (Misc queries) | |||
how can avoid considering of blank cells in IF function | Excel Worksheet Functions | |||
Excel truncated my cells when copying, how to avoid?? | Excel Discussion (Misc queries) | |||
Automatic copying data excluding blank cells | Excel Worksheet Functions |