Solved: Using two commands in Excel 2007
Good afternoon guys. Well I am back and I have a good one for you.
This concerns two spread sheets. The first ss has all the data I need to
put in ss two. This is what I would lke to accomplish. In ss #1 in Column
A there are 600 symbols. In Column B and C there is data for the symbols
in column A. Now for the second ss. I would like to start with a new ss.
I want the symbols in the first ss and the numbers in columns B and C to be brought over into ss two. I can do that using the VLookup command.
Here is the problem. I only want the symbols and the positive numbers from Columns B and C brought over to the second ss.
Can you help me with this. Thanks for your time with this.
Max
Reply to message on using vlookup and another command
As to your first question. There are two workbooks. One and two.
I want workbook two to use some command to look in workbook one.
and bring over to workbook two any of the 660 symbols that meet the follow. First in workbook two in column A I want the symbol. In column
B3:B660 I want any of the numbers that are more than 0.01 and the numbers in column C3:C660 that are more than 0.01.
There are numbers in columns B and C that are less than negative that I
do not want.
I do not want to do a copy and paste.
Max