Results 1 to 9 of 9

How to find data & offset

Threaded View

jeffko How to find data & offset 04-06-2007, 11:09 PM
BigBas Without seeing your data, it... 04-06-2007, 11:32 PM
Paul I tried that, BigBas, at... 04-06-2007, 11:41 PM
Paul PS --- change your thread... 04-06-2007, 11:51 PM
jeffko thanks for the help so far... 04-07-2007, 12:10 AM
  1. #1
    Registered User
    Join Date
    04-06-2007
    Location
    Ohio
    Posts
    3

    Unhappy How to find data & offset

    OK, my problem is probably very simple, but i just can't seem to figure it out. I import 13 .csv files into one excel workbook, each into a separate sheet. In each .csv file there is the word "FINALS", which will always be in column A, but never the same row. I need to locate the word "FINALS" and then return the data in the following two rows below it (across columns A-L). The 14th sheet (named results) will gather the data i have collected from each of the 13 sheets.

    HOW?

    Thanks for any help.
    jeff.
    Last edited by jeffko; 04-07-2007 at 12:03 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1