Recent content by judgeh59

Common sense isn't all that common.... not my quote, but it sure is true Be Alert, America needs more lerts

6 o'clock High Be Alert, America needs more lerts

Pretend it's in your rearview mirror Be Alert, America needs more lerts

[bigsmile] and the flatirons hanging from the earlobes... Be Alert, America needs more lerts

Hudson and Landry.....I loved those guys.....the Weird Kingdom was great....thanks for the memories.... Be Alert, America needs more lerts

I knew a lady named Penny Nichols Be Alert, America needs more lerts

you might have better luck posting this in the VBA Visual basic for applications (Microsoft) forum.... Ernest Be Alert, America needs more lerts

It's a bit confusing on how you have your data set up...if it is set like this Col A Col b Jan North Jan North Feb North Mar South ... then a pivot table with Column labels being Date(col A) and row Labels being Region(Col b) and values being Count of Date(Col A) that...

I'm probably off base but is there a NAT Table somewhere that is mucking up the system? Ernest Be Alert, America needs more lerts

if Lionelhill is correct about how you have you data set up you can use VBA to loop through the rows and collect them in an array and then do whatever you want to with said array...if you go that route then it would make sense to repost this in the forum that Skip suggests... Ernest Be Alert...

if you truly want a VBA Solution then there a VBA group just for that.... VBA Visual Basic for Applications (Microsoft)... a repost into that group would be a good idea.... I'm also looking into a solution... Ernest Be Alert, America needs more lerts

you're welcome Sir Ernest Be Alert, America needs more lerts

this may not be easy but it seems to work on the data set you created and some corner cases I added... =CONCATENATE(LEFT(E3,1),TEXT(MID(E3,2,FIND("^",E3,1)-2),"00"),"^",TEXT(MID(E3,FIND("^",E3)+1,FIND("'",E3)-FIND("^",E3)-1),"00"),"'",RIGHT(E3,1)) this assumes your data is in column E and the...

Nope....excellent question though...I have talked with the IT folks here and they are going to upgrade the PC with one that has office 2007...everything I find about this says it's a bug in Excel...some people even have cases open with Microsoft and are still waiting for an answer...I should get...

Source file is created using the following: OS: XP PRO Sp3 - all updates completed Office 2003 - all updates completed Toad for DA is being launched by the windows scheduler and creating a file on the network. The file is being opened by (Managers Laptop): OS: Win7 - all updates completed...