pbdsp79
02-08-2008, 08:52 AM
Hi All
Having an excel file with three column name curreny, region and holiday (date).
In currency different currencies are there like AED, INR, USD, GBP ETC.
In region there is one region, LDN (LONDON)
In holday, dates are there.
What i require is whenever i open that excel sheet, it should show me that today there is holiday for following currencies for the same day.
for eg. if i open that excel sheet on 8/02/08 it should show me that on 08/02/08 this much currencie have holiday for 08/02/08 with dates for the same day.
if i open that excel sheet on 9/02/08 it should show me that on 09/02/08 this much currencie have holiday for 09/02/08 with dates for the same day.
I am attaching a excel file for reference.
I have tried hard but not received any result.
Regards
Prashant
Having an excel file with three column name curreny, region and holiday (date).
In currency different currencies are there like AED, INR, USD, GBP ETC.
In region there is one region, LDN (LONDON)
In holday, dates are there.
What i require is whenever i open that excel sheet, it should show me that today there is holiday for following currencies for the same day.
for eg. if i open that excel sheet on 8/02/08 it should show me that on 08/02/08 this much currencie have holiday for 08/02/08 with dates for the same day.
if i open that excel sheet on 9/02/08 it should show me that on 09/02/08 this much currencie have holiday for 09/02/08 with dates for the same day.
I am attaching a excel file for reference.
I have tried hard but not received any result.
Regards
Prashant