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.
My version is Excel 2003.
Try this
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
I tried but no result being displayed. By the way, I re-attached another file with pivot table this time round. The 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.
The pivot table is taking its data from the table A1:C13. if this contains no date information as regards to the 15th how will it know to include this as a data set?
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
Yeah that the problem and if that the case is there other way to do it?
I forgot to adjust my formula when I moved the data.
Try this
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Thanks Xld you posted the file already? how come I din see it in the post.
Seems to be a problem on my laptop. See if this works better
BTW I hope you are not suffering in Queensland.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Bob, the formula is an array formula, but when I highlight it, by clicking on it in the formula bar, Excel removes the curly brackets. Why does it do this?
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
Because highlighting it is putting it into edit mod4. The brackets are not part of the formula, but rather an indication that it is an array formula. So Excel is 'smart' (ish), it removes them for you so that you can properly edit the formula. But of course, it means that you have to put them back.
To my mind, Excel would be far smarter if it recognized array formulae automatically, so we didn't have to bother with Ctrl-Shift-Enter.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Thank you for your help and concern. I'm all right no worries.
Posting Permissions
Reply With Quote
