Extracting data from multiple files

[ctote]

Hello all,

I am a network admin for an engineering company. I was just asked a question about excel that goes beyond my expertise.

When we fill out our time sheets in excel, we have multiple rows in which we can specify the client we are working for. For example, if we work for client 123 for 3.5 hours and then work for client 789 for 4 hours, we can put both in the same time sheet. We supply the client number in one column of the row, and then the hours worked. A few columns down there is a fresh row for inputting data for another client. This form of input is required because our engineers are charged out to clients according to how many hours they spend on the project.

One of the clients requests that we send them all timesheets that are referred to their projects. Is there a way (or program) to look in a directory of excel documents, scan the documents for a specific string of text, and then extract that entire row to something?

OR

I'm not sure if this would be allowed by our accounting department, but is there a way to look through a list of excel documents and grab the files that contain a specific string of text?

Thank you so much for your help with this!
-Caleb

[rylo]

Caleb

There are plenty of examples on this site to show how to open multiple files in a directory. I did a quick search and this one came up pretty quickly
Open Files Example.

Once you get the files open, then search for the required string. If it exists, then copy the row of data to the output file. Again, there are many examples, so try a search and see how you go. The VBA FIND command inside a DO LOOP will repeat the search until you have them all.

rylo