I have a database that lists 4 different daily figures for a whole year. The first column is? dates,? and the next 4 columns i will refer to as "X"(To help me explaine myself). I have 2 goals.
1) I want the user to easily pinpoint a basis point by inputing the date and "X", and the corresponding cell to be the output
2) I want the user to be able to easily find the difference between two "X"'s on a particular day.
I want? two command buttons, titled
1) "Find Basis Point"
2) "Find Basis Point Differential"
The "Find Basis Point" button needs to have two drop down boxes. One? for the dates, and the other for "X". Once the user makes his selections, a? command button titled "Find? BPS" locates the corresponding data? and presents it as output.
The "Find Basis Point Differential" button needs to have three drop down boxes. One for the date, the other two for two different "X"'s. Once the user makes his selection, a command button titled " Find BPS Differential" calculates the difference between the two corresponding "X"'s and presents it as output.
This project should probably take less time to program than it was to read this post. I'll pay 20$ and need this done ASAP.