ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Using excel to select only matching images... (https://www.excelbanter.com/excel-discussion-misc-queries/1184-using-excel-select-only-matching-images.html)

davidbev008

Using excel to select only matching images...
 
We have an online storefront.
Our products are all in an excel spreadsheet, arranged by part number.

I have about 30,000 images of products.
I only want to select about 15,000 images of these 30,000 images.

How do I select out of my image folder (containing 30,000 images) only the
15,000 images I need (that actually match the 15,000 products in our excel
product listing)?

All images and products are arranged via their " part number ".
My product listing is in (MS Excel 2000) by part number.
My images are in their folder and named by part number.

It's like selecting only the black jelly beans in a jar of 100,000...ha.

Any suggestions?

Thanks in advance,
David



once you have selected your images, what are you going to
do with them?

-----Original Message-----
We have an online storefront.
Our products are all in an excel spreadsheet, arranged by

part number.

I have about 30,000 images of products.
I only want to select about 15,000 images of these 30,000

images.

How do I select out of my image folder (containing 30,000

images) only the
15,000 images I need (that actually match the 15,000

products in our excel
product listing)?

All images and products are arranged via their " part

number ".
My product listing is in (MS Excel 2000) by part number.
My images are in their folder and named by part number.

It's like selecting only the black jelly beans in a jar

of 100,000...ha.

Any suggestions?

Thanks in advance,
David

.



All times are GMT +1. The time now is 01:21 AM.

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