Replies

Thanks for the link Hans… I’ve already used it and found a few other items I was looking for. One last question… will 2007 let me have more than ONE bar of commands, or do I have to keep clicking the arrow to see the 2nd bar commands.
Thanks!
Lana

Hi Randy,
I always just click on the “comma style” format and the zero changes to a dash.
Regards,
Lana

Hi Rudi,
I am an accountant and I download databases from our main software platform multiple times per day. We have about 16 people in accounting (half are degreed accountants) and we all use the filter function extensively, likewise, we use pivot tables to summarize these databases. When we “discovered” the pivot tables (accidentally) about 8 years ago, we thought they were “magic”. I have no idea how in the world we existed without them prior to that. I use filters and pivot tables EVERY single day… and so does ALL of our accounting staff. Accounting generates and distributes information for our entire worldwide organization to our executives, sales staff, customer service staff, HR staff, etc., so they too, know how to use pivot tables as well. I would say that this is one of the most powerful tools in Excel, as it allows the not so advanced Excel user to use it. As an accountant, I use the pivot table as a problem solving tool, rather than just a reporting tool. It works great for finding a needle in a haystack.
Good luck with your project!
Lana

This worked perfect! Thanks for your help Jan, and thanks to Rudi for responding as well!
Lana

This makes sense…thanks so much Hans! Note that my formula was supposed to have H9*K9, so that’s why I had the IF, but good catch though, that would have been silly of me to have it that way, I can see why you mentioned it )
Thanks again Hans!
Lana

I like this option… I will give it a try!
Thanks Steve!
Lana

Now it gives me this error message… the other error message said the = token is not valid, and now this one says the & token is not valid. Does this make sense? I would think we’d be able to use the = sign in a formula??

SQL0104 – Token & was not valid. Valid tokens:),.

It accepts the formula now, however when I refresh the query it gives me this message:

SQL0104 – Token = was not valid. Valid tokens:),.

Here is the formula I typed in:

IIF(BPGDNB=’JAN08′,BPBAVA,0)

This is awesome John… thanks so much… one last thing… is there a way to change it from a notepad file to a Microsoft Word file?
Thanks!!!
Lana

Well, I’m wanting to use the speaker notes option for something else… I have about 25+ people coming to the budget meetings and I’m trying to go green (no paper… usually each person gets a binder that’s 3 inches thick of paper), so I’m consolidating everyone’s presentations into one big one, then I’m going to give them all a flash drive with the presentation on it. If they wish, they can bring their laptops to the meeting and follow along the presentation on their own laptop. I have hyperlinks on the master slide so they can easily get back to the Table of Contents for ease of navigating the large file, and now I want them to be able to jot down a note right in the presentation file so they can view the notes later.

Hi,
Thanks so much for the help… the macro partly does what I need it to do, except it keeps looping back to the same worksheet over and over again, then it stops on it’s own, acting likes it’s finished. I’m a little confused on how the following line works:
If InStr(ws.Name, “Budget”) > 0 Then
Does it mean if the worksheet name has the word “Budget” in it? Also, I’m unsure what the zero means.
Thanks!!
Lana

Yep… of course that worked! Thanks for the explanation Hans!
Lana

I used the Application.UserName and it worked perfect!
Thanks Hans!
Lana

Hi,
I’m wanting to use part of the code that Hans provided awhile back in this post, however I’m having trouble following it… below is the code I wrote, however I’d like to add Hans code to it. I’m going to have the macro attached to a command button, so when the person who has the file open presses the command button to “approve” it, then the macro will copy their electronic signature and paste it at the bottom of the report. In my macro I have it simply looking at whose name is in cell A19, however I’d like it to look at the username and based on the username, decide which signature to copy & paste. Any help is always much appreciated!
Thanks so much!!
Lana

Sub Approval()

Sheet3.Select

If Range(“A19”) = “scott” Then
Sheet6.Select
ActiveSheet.Shapes(“Picture 17”).Select
Selection.Copy
Sheet3.Select
Range(“A26”).Select
ActiveSheet.Paste

ElseIf Range(“A19”) = “jerry” Then
Sheet6.Select
ActiveSheet.Shapes(“Picture 16”).Select
Selection.Copy
Sheet3.Select
Range(“A26”).Select
ActiveSheet.Paste

ElseIf Range(“A19”) = “john” Then
Sheet6.Select
ActiveSheet.Shapes(“Picture 15”).Select
Selection.Copy
Sheet3.Select
Range(“A26”).Select
ActiveSheet.Paste

Else
Range(“A1”).Select

End If

End Sub

Okay, I feel stupid now… I was totally looking in the “View” area… I must have clicked on everything EXCEPT the status bar… oops!
Thanks Hans!!
Lana