HolidayBuyer's Guide

Office & Productivity Software forum

General discussion

Excel - numbers - files

by attilacs74 / March 20, 2008 6:22 AM PDT

Hi Everybody,

I work with Excel sheets, where in one coloumn I have SKU (stock keeping unit) numbers. I have a folder with templates in it (a few hundreds), named by the SKU (these are Word docs) From the Excel sheet I have to check, if we have the certain SKU file in that folder, but I don't want to do it one by one, it would be very slow.
Is there an easier way to do it? I don't need to open those files, just to check if we have those files named by the SKU number.

Thanks
Attila

Discussion is locked
You are posting a reply to: Excel - numbers - files
The posting of advertisements, profanity, or personal attacks is prohibited. Please refer to our CNET Forums policies for details. All submitted content is subject to our Terms of Use.
Track this discussion and email me when there are updates

If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.

You are reporting the following post: Excel - numbers - files
This post has been flagged and will be reviewed by our staff. Thank you for helping us maintain CNET's great community.
Sorry, there was a problem flagging this post. Please try again now or at a later time.
If you believe this post is offensive or violates the CNET Forums' Usage policies, you can report it below (this will not automatically remove the post). Once reported, our moderators will be notified and the post will be reviewed.
Collapse -
Checking files.
by Kees Bakker / March 20, 2008 7:41 PM PDT

In that folder in the command processor do dir > dir.txt.
Open dir.txt and copy the contents to a new column next to the SKU-column. Sort both columns the same way and compare, or use a vlookup-function to check. You might need a little bit of manipulation to get rid of ".doc".

Hope this helps.


Kees

Collapse -
Checking files
by attilacs74 / March 26, 2008 5:34 AM PDT
In reply to: Checking files.

Thanks, but I don't know what is command processor. I almost do the same, simply opening the excel, minimize, so I could see only the SKU numbers (of course in order), then open the SKU folder, minimize as well. They're next to each other so I can easily ID if they match.

Collapse -
Command Prompt
by MarkFlax Forum moderator / March 26, 2008 9:57 AM PDT
In reply to: Checking files

Usually called the Command Prompt, found in Start > All Programs, (for XP), > Accessories > Command Prompt. This is a DOS like window and what should be displayed is something like;

C:\Documents and Settings\Username>
where Username is the name of your account.

Use DOS commands to change directory from the above to where your list of SKU files are stored eg;

cd.. {type in two periods after the d} returns the prompt to C:\Documents and Settings>

cd.. returns to the C prompt, C:\>

cd your folder

Then type dir.txt

This wil create a txt file in that folder called dir.txt which will list the contents of the folder and this you can manipulate into the Excel spreadsheet as Kees suggested.

I hope that helps.

Mark

Collapse -
(NT) That certainly works also. Good job.
by Kees Bakker / March 26, 2008 5:47 PM PDT
In reply to: Checking files
Popular Forums
icon
Computer Newbies 10,686 discussions
icon
Computer Help 54,365 discussions
icon
Laptops 21,181 discussions
icon
Networking & Wireless 16,313 discussions
icon
Phones 17,137 discussions
icon
Security 31,287 discussions
icon
TVs & Home Theaters 22,101 discussions
icon
Windows 7 8,164 discussions
icon
Windows 10 2,657 discussions

HOLIDAY GIFT GUIDE 2017

Cameras that make great holiday gifts

Let them start the new year with a step up in photo and video quality from a phone.