We use cookies to provide you with a better experience. If you continue to use this site, we'll assume you're happy with this. Alternatively, click here to find out how to manage these cookies

hide cookie message
Contact Forum Editor

Send an email to our Forum Editor:


PLEASE NOTE: Your name is used only to let the Forum Editor know who sent the message. Both your name and email address will not be used for any other purpose.

Tech Helproom


It's free to register, to post a question or to start / join a discussion


 

Excel help


ukhomerj2003

Likes # 0

I have 14 thousand Excel files i need to search through for addresses. Is there a programme that can examine the file content and report/flag a result?

Like this post
The Potter

Likes # 0

Please forgive me for being the first to respond and not have an answer for you ......

I don't wish to know your personal business but please can you give me a scenario where someone would have 14K Excel files (assuming you are talking about workbooks) to search through - maybe inherited some poor business practice? My mind boggles (probably due to ignorance despite having an advanced qualification in some aspects of the programme)!

TP

Like this post
wiz-king

Likes # 0

Do you mean 'addresses' or an address? You could use the computers 'find' to find a workbook containing one word of an address (eg London), it would be slow but it will pull aout every instance of that word.

Like this post
Terry Brown

Likes # 0

Have a look at this link for solutions. link text

Terry

Like this post
ukhomerj2003

Likes # 0

TP I have the files for business, and it is a legitimate reason why i have these as they are old account files. They are not illegally sourced, nor used for any bad practice. They have a lot of historical data i need to reference against. Thank you

Like this post
VoG II

Likes # 0

If they are all in the same folder and the data that you want to extract is in the same cells in each workbook, maybe you can adapt this

Like this post

Reply to this topic

This thread has been locked.



IDG UK Sites

Windows 9 release date, price, features: 30 September marked for unveiling

IDG UK Sites

Gateway to your kingdom: why everybody should check and update their broadband router

IDG UK Sites

Netflix whips up 3D VR viewing room for Oculus Rift during company hack day

IDG UK Sites

Best Mac? Complete Apple Mac buyers guide for 2014