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!
Bookmarks