Search:

Type: Posts; User: LJM; Keyword(s):

Page 1 of 14 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    2
    Views
    142

    Copy & Paste Special Mutliply (Excel 2010)

    Hello,

    I'm trying to write a bit of code that would simply multiply a range by -1 WITHOUT having to actually put the "-1" in the Excel worksheet in cell AA1. How can I just define the "-1" as a...
  2. Replies
    1
    Views
    365

    Lock down Excel's custom quick access toolbar

    Hello...

    Is there a way to lock Excel's custom quick access toolbar so a user is not allowed to change it? I know it defeats the purpose of the tool, but it sure makes it difficult to help people...
  3. Replies
    18
    Views
    1,042

    What-If Analysis Data Table

    Hello!

    I'm in need of an Excel tool that will show me different Pay Grade %'s at different levels of income. If attached an Excel file to show my example. I'm assuming I'd use the What-If...
  4. Code to run a batch file located on a different server

    Hi,

    I have the following code I found on the internet that would work great if the batch file I needed to run was located on my local computer. The windows batch file I need to run is located on...
  5. Replies
    3
    Views
    1,094

    That didn't work... here is all the code, in case...

    That didn't work... here is all the code, in case I should have showed more than what I originally did...

    Sub SendEmail()

    Dim noSession As Object, noDatabase As Object, noDocument As...
  6. Replies
    3
    Views
    1,094

    Constant Expression Required Error Message

    Hello,

    Below is code that works nicely (I didn't include the whole macro):Const stPath As String = "K:\Groups\ADP\2012\Schedules"
    Dim stFileName As String
    Dim FileName As String
    FileName...
  7. Need VBA code to attach ACTIVE PDF to Lotus Notes e-mail

    Hello,

    I have been using the VBA code below to attach the ACTIVE Excel file to the Lotus Notes email. I have recently created another macro that does a "file save as" function to save the ACTIVE...
  8. Replies
    11
    Views
    2,129

    This is what worked: ...

    This is what worked:

    =SUMIFS(H:H,D:D,D2,G:G,CONCATENATE("<=",G2))

    I've reattached the example file - I've saved it in Excel 2007.

    Thanks again Retired Geek & Steve!! I really appreciate all...
  9. Replies
    11
    Views
    2,129

    Bingo!!! Thanks so much Retired Geek... you...

    Bingo!!! Thanks so much Retired Geek... you rock. This is exactly what I was looking for, and could have used years ago. This will be a new formula that I'll be sharing with our accounting...
  10. Replies
    11
    Views
    2,129

    Hi Steve, The concatenated column (column P)...

    Hi Steve,

    The concatenated column (column P) is correct. The sumif doesn't work if the periods are not sorted in chronological order. I've attached a new example.

    Is there a formula that will...
  11. Replies
    11
    Views
    2,129

    Hi Retired Geek, Thank you for your response. ...

    Hi Retired Geek,

    Thank you for your response. I know it sounds silly that I wouldn't sort the database. It's a huge database that I extract from our AS400 by using msquery. I have other columns...
  12. Replies
    11
    Views
    2,129

    Hi again! I just realized that it doesn't work...

    Hi again!

    I just realized that it doesn't work if there is a period missing from the database. The database is a trial balance, so some will not have all 13 periods, as not all periods will have...
  13. Replies
    11
    Views
    2,129

    Hi Steve, That was awesome! Wow, I've used...

    Hi Steve,

    That was awesome! Wow, I've used the SUMIF formula forever... I had know idea it could do that. Why I didn't ask this question before is beyond me. Anyway, I'm wondering if you could...
  14. Replies
    11
    Views
    2,129

    Formula to Determine Accumulated Total

    Hello,

    I'm in need of a formula that would determine the accumulated total for each period. The kicker is that the database will be very large, and will NOT be sorted in an ideal format that...
  15. Replies
    2
    Views
    1,013

    If Then Looping Macro

    Hi!

    I have written the following code, which works, but then stops with an error at the end (so it really doesn't work :^_^:). Anyway, I think I shoud be using something other than the "For...
  16. Replies
    5
    Views
    2,789

    Macro to Change Pivot Table's CurrentPage

    Hello,

    I have the following macro which changes the CurrentPage based on what is in cell A1 for TWO different pivot tables:

    Sub Testing()...
  17. Of course! Rounding... now I feel really dumb. ...

    Of course! Rounding... now I feel really dumb. I round everything else in my worksheets, but I falied to do so in this table! Thanks so much for opening my eyes tfspry! I must have been sleeping!...
  18. Vlookup on a percentages, as opposed to a word/text

    Hello... I have a vlookup formula (see attached) that is not showing the correct result. I'm looking up a percentage. I've used vlookup's for years, and have never had this problem. Apparently I...
  19. Replies
    1
    Views
    498

    Hi, I'm hoping that there is a bigger square box...

    Hi,
    I'm hoping that there is a bigger square box in the character map than the one I'm using in the attached example. I'm wanting the box to be a bit bigger. I'm not interested in inserting an...
  20. Replies
    3
    Views
    1,006

    The formulas are still part of the table... when...

    The formulas are still part of the table... when I click on a cell with a formula, the "Table Tools" tab DOES appear. In addition, if I pick the name of the query in the upper left hand corner of...
  21. Replies
    3
    Views
    1,006

    Hi, I have a microsoft query in Excel......

    Hi,

    I have a microsoft query in Excel... beside the ms query data that is downloaded I have several columns with formulas. Normally, these formulas fill up & down as the database that is...
  22. Replies
    2
    Views
    468

    I finally got it to work... I renamed the picture...

    I finally got it to work... I renamed the picture to "object 6", then I had to change the code from:

    ActiveSheet.Shapes("Object 6").Select
    Selection.Copy


    to:

    ActiveSheet.Shapes("Object...
  23. Replies
    2
    Views
    468

    Hi, I have about 7 pictures that I've inserted...

    Hi,
    I have about 7 pictures that I've inserted into an Excel spreadsheet. When I recorded my macro to copy and paste one of these pictures it shows the following code:


    ...
  24. Replies
    2
    Views
    514

    Problem solved!!! Thanks so much Hans!! It's as...

    Problem solved!!! Thanks so much Hans!! It's as simple as pressing Ctrl + 6 to turn off the display objects function.
    Thanks again!
    Lana
  25. Replies
    2
    Views
    514

    Hi, Since our company upgraded to Excel 2007...

    Hi,

    Since our company upgraded to Excel 2007 in the last few months I've had 3 occassions where people are trying to insert a row into an old worksheet and get the following message:
    "Cannot...
Results 1 to 25 of 343
Page 1 of 14 1 2 3 4