Replies

Not sure if this is the same thing, but we have tried thin clients. Calling them a disaster would be a understatement. Thanks for replying.

Well, it’s still Monday in my time zone. Sorry. It does not sound like I have a great deal to worry about. The exceptions would be those who are worried about losing their Outlook archive(s) or who have custom software installed on a PC, like my Excel add-ins. Is that fair to say?

We don’t have any problems with the regular Outlook files, thank goodness. It’s the archives where a user can have one or two at this hospital, one or two at another, and one more at a third. I don’t understand why Outlook doesn’t ask you where to store your archive when it sets up for the first time on a given PC. It prompts you where for your Exchange server name and your network user name. It would seem an easy prompt to add.

We do have roaming profiles, yet there’s still have a lot of room for customizations, such as IE favorites, desktop shortcuts, cookies, history, etc., that are specific to that PC. Also, our Outlook setup is a little, well, odd I guess. If the user doesn’t set up his/her archive file correctly, it sits in the Documents and Settings folder on the PC instead of on the network. So a user could have archive files scattered everywhere. And, when Dell or whoever gets the new lease comes, those archives are gone. I’m not well versed in networking issues, so I hope this make sense. Give me an Excel problem any day. Thanks.

Hans, your code works perfectly. I had done more cleanup on the original list than I had realized, so what I sent and what you worked on was not the original list. My fault, duh. So, as soon as I get it to the point where the code can work I’ll be fine. I wish I could learn to write code like that. Thanks for all the help.

Yes. I have headers in row 1, and the data starts on row 2. If I take a series of steps using some of the Spreadsheet Assistant add-ins, I think I can eventually get it like I want it. But, boy, are there a lot of steps.

Let me float this balloon. It would really help if I could tell Excel to start at a cell with “Secondary Menus” in it (call it B2), then go to the next cell with “Security Keys” (call it B11), then select B3:C10 and move them over. The cell addresses won’t be the same since I’ll have to insert blank columns, but perhaps you get the idea. I know how to tell it to find, but not how to select the cells in between.

Thanks again for taking the time to check it.

Jim

Sorry, that’s an error on my part setting up the sample data. All the Primary menus are in the format, “Primary Menu: Whatever”. It would be easier if I could just send you a piece of the actual sheet, but the data’s confidential. My bad, as the young folks say.

Thanks, Hans. I’ve had sixteen years’ experience with this system, and I know for sure it’s a canned report that can’t be modified. Even if it could be, our IT service’s number one programmer is out for awhile. I have some add-ins such as Spreadsheet Assistant. I’ll look through them again, maybe there’s something I missed. Have a great day.

Again, my sincere thanks.

Jim

Hans, thanks a lot. I knew it wasn’t that complicated. Calcified neurons, I guess. So, the code could like what is below. Are you saying I could leave off this statement:
‘ActiveCell.Offset(1, -4).Range(“A1”).Select’
as long as the word subcount is not in any other column?

Do While ActiveCell.Row <= 2500

Cells.Find(What:=”subcount”, After:=ActiveCell, LookIn:=xlValues, LookAt _
:=xlPart, SearchOrder:=xlByColumns, SearchDirection:=xlNext, MatchCase:= _
False, SearchFormat:=False).Activate
Selection.Cut
ActiveCell.Offset(-1, 4).Range(“A1”).Select
ActiveSheet.Paste
Selection.TextToColumns Destination:=ActiveCell, DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=True, Tab:=False, _
Semicolon:=False, Comma:=False, Space:=True, Other:=False, FieldInfo _
:=Array(Array(1, 9), Array(2, 1)), TrailingMinusNumbers:=True
ActiveCell.Offset(1, -4).Range(“A1”).Select

Loop

Thanks,
Jim

Sorry it’s taken awhile to get back to you.

Steve, I have a meeting with my supervisor in a few minutes to try and hammer out exactly what his boss wants to see. I was thinking maybe a few seven-day mini-graphs on prescriptions, IV bags, and non-IV orders, but that’s just a guess. From my worm’s-eye view of this, it seems that they want something like the stock market – where’d we end up at the end of the day yesterday and what the last week looked like.

Catharine, I will check those web sites and sample file ASAP for my meeting. Thank you for sending them. At first I thought they wanted speedometer graphs, but now they seem to be leaning toward simpler line graphs. Will let you kind folks know when I hear more. Thanks again.

Hans: Yep. OzGrid has an e-book as well. If I were as as those guys, I don’t know if I could just give the knowledge away.

Steve, I don’t think they know. They see a lot of ProClarity and other “cool stuff”, so right now I’m just fishin’.

Jim

Thanks everyone for your replies.

Catharine, I have attached a file with sample data the management is interested in seeing.

Steve, I don’t know if Jon’s speedometer chart will work in this case yet, but it is a good idea.

Hans, I had looked at that page. It is impressive, but you cannot zoom in on the pictures of the dashboards, and the point seems to be selling the author’s books. I have not had time to dig deeply into his web site, so that assumption could be wrong. Regardless, I am not implying any criticism. Knowledge is power as well as currency.

All you USA folks, have a GREAT Labor Day weekend.

Well, as are sometimes said in Texas, “Dang, I wish I was that smart,” and, “I’m obliged to you.” Obviously it worked perfectly.

Thanks a lot. My work day is nearly over, so I’ll start on this fresh in the morning. Thanks again.