ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   hide certain rows from data import (https://www.excelbanter.com/excel-discussion-misc-queries/112407-hide-certain-rows-data-import.html)

Paul K.

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.

Dave Peterson

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


All times are GMT +1. The time now is 04:03 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com