- Joined
- Nov 28, 2006
- Messages
- 1
- Reaction score
- 0
Hi,
I have a sheet that needs a filter function.
My sheet varies in sice since new data come each day and old data is deleted.
My data is in three columns A-C, but this will grow in the future. In A I have the name of my stocks, in B when I bought them and in C I have my planed sell date.
My goal is:
-to be able to search on name of securety
-to be able to search in intervalls of planed sell dates (I whant to be anle to see what securities that I plan to sell in a three years horizon, three to five years horizon and more than five years horizon.) To do this I want to use buttons that I assign macros to.
To be able to do this I have added the 01.01.09 and 01.01.11 in my C colum. This since I want to be able to search: securities less than 01.01.09, securities between 01.01.09 and 01.01.11 and securities that I planded to sell in more than 01.01.11. To always have my dates fresh I have used the function ="01.01."&(YEAR(NOW())+3) and ="01.01."&(YEAR(NOW())+5). I have used 1 of Jan. for the two dates since when I search less than 01.01.09 I want to get the securities that is less than three years started in the begining of the year.
I have used the AutoFilter function under Data-Filter. The filter works when I do all this manually ex. filter-custom-is less than-01.01.09.
But when I try to get excel to do this by recording a macro it will not perform the task. I do not know if it is not possible to do this with the macro recorder? The funny (...not) thing is that I have done a "resume" button ( filter-(all) ) and it works.....
Thanx for the help
/Stefan
I have a sheet that needs a filter function.
My sheet varies in sice since new data come each day and old data is deleted.
My data is in three columns A-C, but this will grow in the future. In A I have the name of my stocks, in B when I bought them and in C I have my planed sell date.
My goal is:
-to be able to search on name of securety
-to be able to search in intervalls of planed sell dates (I whant to be anle to see what securities that I plan to sell in a three years horizon, three to five years horizon and more than five years horizon.) To do this I want to use buttons that I assign macros to.
To be able to do this I have added the 01.01.09 and 01.01.11 in my C colum. This since I want to be able to search: securities less than 01.01.09, securities between 01.01.09 and 01.01.11 and securities that I planded to sell in more than 01.01.11. To always have my dates fresh I have used the function ="01.01."&(YEAR(NOW())+3) and ="01.01."&(YEAR(NOW())+5). I have used 1 of Jan. for the two dates since when I search less than 01.01.09 I want to get the securities that is less than three years started in the begining of the year.
I have used the AutoFilter function under Data-Filter. The filter works when I do all this manually ex. filter-custom-is less than-01.01.09.
But when I try to get excel to do this by recording a macro it will not perform the task. I do not know if it is not possible to do this with the macro recorder? The funny (...not) thing is that I have done a "resume" button ( filter-(all) ) and it works.....
Thanx for the help
/Stefan