I have a workbook with 6 worksheets. Each of the first 5 worksheets represent one year. Wksht1 = 2001, wksht2 = 2002, etc.
On these worksheets, there are 13 columns. Column 1 lists products and columns 2-13 represent January through December. Prices of each product are updated monthly in these columns.
I then have a 6th worksheet called "Current", which I would like to list the most recent/current price. In other words, if its November 1st of 2002 and new prices are entered, I would like wksht "Current" to display those prices.
I aam having a hard time coming up with a way to do this! Any ideas? If anything was unclear please let me know. Thanks in advance.
This message was edited by mlopes1 on 2002-10-17 10:11
On these worksheets, there are 13 columns. Column 1 lists products and columns 2-13 represent January through December. Prices of each product are updated monthly in these columns.
I then have a 6th worksheet called "Current", which I would like to list the most recent/current price. In other words, if its November 1st of 2002 and new prices are entered, I would like wksht "Current" to display those prices.
I aam having a hard time coming up with a way to do this! Any ideas? If anything was unclear please let me know. Thanks in advance.
This message was edited by mlopes1 on 2002-10-17 10:11