P
Paul987
I am in the begining stages of creating a screen that will screen data
on sheet2 based on conditions entered on sheet1. The data on sheet2 is
formatted consistantly, as is the input layout on screen1. The problem
I think I'm going to face, is there are about 20 possible criteria, and
thousands of data on sheet2. Right now, I think I am limited to using
If statements to screen, due to my ability, and this will make for alot
of if statements. Most likely will kill my Excel (past experience). I
am dealing with stock characteristics, to give you an idea of what I'm
trying to accomplish.
Example setup:
Sheet 1 (Fields(A:A)and Requirements(B:B))
Name
Price >100
Volume
P/E <50
Sheet 2 will have the data, with different stocks down the rows, and
the fields across the top.
Any advice on how to go about this? Is it possible to screen on only
the fields that have inputs, versus running if statements on all
possible criteria fields? Any and all help is appreciated. I will
clarify anything if neccessary. Thanks
on sheet2 based on conditions entered on sheet1. The data on sheet2 is
formatted consistantly, as is the input layout on screen1. The problem
I think I'm going to face, is there are about 20 possible criteria, and
thousands of data on sheet2. Right now, I think I am limited to using
If statements to screen, due to my ability, and this will make for alot
of if statements. Most likely will kill my Excel (past experience). I
am dealing with stock characteristics, to give you an idea of what I'm
trying to accomplish.
Example setup:
Sheet 1 (Fields(A:A)and Requirements(B:B))
Name
Price >100
Volume
P/E <50
Sheet 2 will have the data, with different stocks down the rows, and
the fields across the top.
Any advice on how to go about this? Is it possible to screen on only
the fields that have inputs, versus running if statements on all
possible criteria fields? Any and all help is appreciated. I will
clarify anything if neccessary. Thanks