| 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. |
| 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 | |||
Threaded Mode
