| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
hide certain rows from data import
I need to hide cetain rows of data (not necessarily from viewing or printing)
but from importing into an online store. I have a number of products awaiting images and I want only to import products that I have an image for. I could delete products without an image an add them later but I have 2000 products so this would be inefficent, is there a smart way to just hide them? Paul K. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
hide certain rows from data import
Can you use another column with an indicator (show/hide) and then use
data|Filter|autofilter to show/hide what you want? Paul K. wrote: I need to hide cetain rows of data (not necessarily from viewing or printing) but from importing into an online store. I have a number of products awaiting images and I want only to import products that I have an image for. I could delete products without an image an add them later but I have 2000 products so this would be inefficent, is there a smart way to just hide them? Paul K. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Import data and keep duplicate rows of data | Excel Discussion (Misc queries) | |||
| Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
| import data from txt to specific col & rows in sheet | Excel Discussion (Misc queries) | |||
| import data with macro | Excel Discussion (Misc queries) | |||
| import data using macro | Excel Discussion (Misc queries) | |||
Linear Mode
