I
iv
Hello,
I'm using the following Vlookup formula:
=IF(ISNA(VLOOKUP(A4,'S:\Operations\Bloomberg\Investment Support\Dummies2Live\2010\May 10\[04052010.xls]Sheet1'!$A$4:$F$600,6,0)),"PRINT",0)
This is linked to another spreadsheet - in this case 04052010.xls. Next day I will need to check file 05052010.xls and so on. To make life easier for my colleagues I wanted to add a cell with date where they can input the date and this will change the date in the formula (i.e. from 04052010 to 05052010) How can I link this formula to let's say cell A1 where I want to insert date every day.
Thanks
Submitted via EggHeadCafe - Software Developer Portal of Choice
WPF GridView Sample To Insert, Update, and Delete Records
http://www.eggheadcafe.com/tutorial...a-c9a46fd3aeb2/wpf-gridview-sample-to-in.aspx
I'm using the following Vlookup formula:
=IF(ISNA(VLOOKUP(A4,'S:\Operations\Bloomberg\Investment Support\Dummies2Live\2010\May 10\[04052010.xls]Sheet1'!$A$4:$F$600,6,0)),"PRINT",0)
This is linked to another spreadsheet - in this case 04052010.xls. Next day I will need to check file 05052010.xls and so on. To make life easier for my colleagues I wanted to add a cell with date where they can input the date and this will change the date in the formula (i.e. from 04052010 to 05052010) How can I link this formula to let's say cell A1 where I want to insert date every day.
Thanks
Submitted via EggHeadCafe - Software Developer Portal of Choice
WPF GridView Sample To Insert, Update, and Delete Records
http://www.eggheadcafe.com/tutorial...a-c9a46fd3aeb2/wpf-gridview-sample-to-in.aspx