Recent content by tcolan

unfortunately I can't use autofilter...

I'm trying to create a list based on the value in a column of another table. I can't use pivot tables. So the data look like this: ID# Status 1A Open 2A Escalated 3B Closed 4R Escalated 5E Open etc. From this table I want to create a list that just contains the...

Thanks to all of you for your help. I figured out that for some reason the Now() function in my code above was calling the VLOOKUPNEXT() function that I had put into a module for some other functionality in the spreadsheet. I'm not really sure why that is or how that happened, but once I...

The old version works but the new version does not....

Thanks Skip. I went and replaced my code with your's which is much more efficiently written - so thanks! Unfortunately I'm getting the same result in which nothing happens. It appears that the code is not be called by excel. I don't get it because when I select 'view code' for the sheet...

oops - I mistyped, I meant to say column B - in other words I meant to say "The event that happens is selecting "Open", "Closed" or "Issue" from a drop down in column B ..." sorry about that.... although I wish that oversight was the answer.... uggg....

Sure thing. The code below works in an earlier version of the workbook. I have not done anything to the spreadsheet that would change any of the ranges or cells referred to. The event that happens is selecting "Open", "Closed" or "Issue" from a drop down in column C and then having another...

Yes, I copied the sheet from another workbook just to test it out to see if it would work. The code works fine in the 'copy from' workbook, but seems deactivated when pasted into the the destination workbook (it compiles with no errors but when the event happens in the spreadsheet it doesn't...

Yes - it compiles with no errors.

Oh and the code is stored within the specific workbook. When I select the tab and coose to view code, I see all of the code. What's even more interesting is that I've copied over a sheet from another workbook that is working fine and once I copy it into this specific workbook, the code stops...

Hi - It seems that all of the vba code in an excel workbook is not being called when the events occur in the spreadsheet. It's almost like the code has been deactivated (it was working fine before) I've played around with all of the security settings but still seem lost at figuring out why...

Thanks and I'll submit over to that forum as well. The code is stored within the specific workbook. When I select the tab and coose to view code, I see all of the code. What's even more interesting is that I've copied over a sheet from another workbook that is working fine and once I copy it...

Hi - It seems that all of the vba code in a workbook is not being called when the events occur in the spreadsheet. It's almost like the code has been deactivated (it was working fine before) I've played around with all of the security settings but still seem lost at figuring out why this is...

Thanks!!!

Hopefully this is an easy one but I'm stumped. I have a pivot table and instead of grouping the headings, I want every cell to show it's value. Note that I've hidden all of the sub-totals. So, instead of X AA 1 BB 1 CC 1 Y AA 1 CC 1 Grand Total 5 I...