Hi all,
I have approx. 2000 excel files, from which I need to consolidate certain cells - which are in different cell locations for each document.

What I would like to do (if possible) is search for a specific text string, then copy the cell to the right of it into a "master" spreadsheet.

In addition there is one field which is one line below specific text in some of the documents and two lines below in other documents. (In the case where it is two lines below, the line in-between is blank if that helps?)

The cycling through all the documents seems to be the easy bit - but i'm struggling with doing a search/select one cell to right (or down or whatever) then copy.

Any help much appreciated