Results 1 to 9 of 9

Extracing Data

Threaded View

  1. #1
    Registered User
    Join Date
    01-18-2007
    Posts
    21

    Exclamation Extracing Data

    Hi every one. I'm a new user to this forum and I searched the forum but could not find an answer to my problem.

    I have an excel sheet which contains financial information of different stocks. i've attached a sample file. Sheet1 is the data and Sheet2 is the format file. Any help would be GREATLY appreciated.

    What I would like is this:

    I need a program that will search colum B for 2 parameters. "Net Income" and "Dividends Paid"

    If "Net Income" exists, then copy whole row to Sheet2.
    If not, insert blank row in sheet2.

    If "Dividends Paid" exists, then copy whole row to sheeet2.
    If not, insert blank row in sheet 2

    I would like the above function done one after the other, for example:
    Net Income
    Dividends Paid
    Net Income
    Dividends Paid

    I would like this process to continue for a set range. For example(B2000)

    In Sheet3, I've manually done what I need to give you guys an idea of what I'm trying to accomplish. Thank you again!!!

    Please Help!
    Attached Files Attached Files

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