wrightyrx7
03-20-2012, 01:18 PM
Hi all,
I have a spreadsheet and in column "A" i have dates that increase by 1 day going down.
For each column on the row i have prices.
I want a macro that will find todays date, return the lowest value on the row and the column header for the Column.
E.g the macro would run and for todays date (20/03/2012) would return a message box: 20/03/2012, Product 2, £5
http://s16.postimage.org/kvzu7b50l/Untitled.jpg
Thanks in advance
Chris
I have a spreadsheet and in column "A" i have dates that increase by 1 day going down.
For each column on the row i have prices.
I want a macro that will find todays date, return the lowest value on the row and the column header for the Column.
E.g the macro would run and for todays date (20/03/2012) would return a message box: 20/03/2012, Product 2, £5
http://s16.postimage.org/kvzu7b50l/Untitled.jpg
Thanks in advance
Chris