Refer to attached file.
In Cell B5, there is a formula that pulls in updated market data (as the price of Gold changes in the market place, the value of the cell updates in real-time).
In Cells K17 to K59, I plan on listing a number of different price levels (i.e. Prices that I think might be important to watch out for).
In Cells L17 to L59, I plan on writing a short comment that describes the corresponding price in Column K.
Here's what I want the cells to look like:
.........K..........L
17) 1776.50 Upside Potential
18) 1770.25 Current Price
19) 1750.00 Support Level
Now, as the current price updates (i.e. assume the price changes to 1790.00), I want the list in those two columns to rearrange and sort itself automatically. Hence, it should automatically change to:
.........K..........L
17) 1790.00 Current Price
18) 1776.50 Upside Potential
19) 1750.00 Support Level
Is there a formula or VBA/Macro that will do that? Remember, the current price will be pulled from Cell B5 (i.e. The formula in Cell K17 in the above example would be "=B5").
I'd appreciate any help you guys could give me with this.
Bookmarks