Mergh06
01-03-2012, 03:54 PM
Hello guys,
I have a little problem:
I got 10< sheets, with Stock qoutes... (I have attached a simple version with 4 sheets which means 4 stocks)
My problem is that when I look at Danish and American Stocks the Date will deviate due to holidays. So I need all deviating days deleted for both the Danish stocks, and American stocks.
In other words, For example I need the 4. July deleted ind Danish stocks (cause this is a american holiday) and 5. june in American stocks (cause this is a Danish holiday)... But there is alot other days which not match and i need a code to fix this... In the end the Dates should be lined up and match each other (The same date in the same rows through all sheets)
I hope someone can help,
Have a good new year,
Best Regards
Mergh
I have a little problem:
I got 10< sheets, with Stock qoutes... (I have attached a simple version with 4 sheets which means 4 stocks)
My problem is that when I look at Danish and American Stocks the Date will deviate due to holidays. So I need all deviating days deleted for both the Danish stocks, and American stocks.
In other words, For example I need the 4. July deleted ind Danish stocks (cause this is a american holiday) and 5. june in American stocks (cause this is a Danish holiday)... But there is alot other days which not match and i need a code to fix this... In the end the Dates should be lined up and match each other (The same date in the same rows through all sheets)
I hope someone can help,
Have a good new year,
Best Regards
Mergh