Hey all,
My question is how to display the columns in A to C to columns H to J using Excel VBA Macro. Find the attached file and the data is in sheet 1.
After reading the data, you will realise the yellow tabs which means that even if the price of the security on that date is not available, the cell should be empty or zero.
The listing of information stops at EndDate which is 17/11/2010. Assuming the price is daily basis but sometimes don't have price at certain days.
Pivot Table seems to make quick work of displaying the data:
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Thank you for your solution it simplifys thing a lot
Another question now is how to display the yellow colour tab row even if there is no data on that day itself? As I doing a macro that can display prices or no prices of variables on business days (Assuming is everyday as illustration)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks