Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.03 seconds.

  1. Re: Intermittent code issue when setting variable to cell value

    Thank you Steve. That fixed the issue.
  2. Intermittent code issue when setting variable to cell value

    I have a code module that calculates monthly commission values. Some of the salesmen have shared accounts where 2 salesmen service a common account. In the database this is indicated by the SLS...
  3. Replies
    5
    Views
    901

    Re: Sumifs on two columns

    You are right! I didn't provide a solution for Power Pivot. Let me see if I can come up with something for that.
  4. Replies
    5
    Views
    901

    Re: Sumifs on two columns

    Helge,

    Here is a solution for you.
    Define Range names for your data in Columns A and B, I used "Basket" and "Amount".
    Then in Column C enter the following formula: "=SUMIF(Basket,A2,Volume)"...
  5. Re: VBA Code for Worksheet Password is protecting other open workbooks - how do I change the code?

    Yes, what Fluff said!

    If your routine is working with multiple Workbooks or you/the user might have other Workbooks open when the VBA module is executed the fact your code chooses "ActiveWorkbook"...
  6. Replies
    3
    Views
    183

    Re: Shorter version of SUMPRODUCT function

    If you use Excel's built in Function tool the formula result would be: =SUMPRODUCT(A1:A5,B1:B5,C1:C5,D1:D5,E1:E5)

    I don't know of a way to simplify the formula any further than that.
  7. Re: amount divided by years and get per month valve.

    try this formula:
    =B48/((TODAY()-B49)/30.41667)
    30.41667 is the result of 365/12 which is the average days in a month.
    The result of this formula is 48,873.39

    If you need a more exact result...
  8. Re: amount divided by years and get per month valve.

    noubaba, welcome to the Forum!

    You say in your post "1 year, 8month and 10 days is mentioned in other cell". Is there any specific structure in how these data points for year, month and days is...
  9. Thread: VLookup

    by frank_AL
    Replies
    2
    Views
    203

    Re: VLookup

    If I am understanding you correctly Column C would already be populated and you want to find that value in the table and populate Min and Max in Columns A & B.
    Enter this formula in cell A5: ...
  10. Replies
    1
    Views
    127

    Re: Using weekly sales data effectivly

    I recommend you read up on using Pivot Tables. They are a very powerful tool for data analysis just as you are suggesting you need.
  11. Replies
    2
    Views
    189

    Re: Delete after dot

    If you want to replace the value in the same cell it would require a VBA macro.

    If you can accept the modified value in another cell, place the formula below in cell B1 (or any other Column) and...
  12. Re: Copy text from one textbox to another textbox on another sheet

    I am assuming these Textboxes are named Ranges; e.g., Textbox1/2/3

    With that in mind you could populate Textbox3 with the Formula "=Textbox1"
    If it needs to be in VBA you could use the following...
  13. Re: How do I get Current Year And Current Quarter

    Assuming a data in cell A1 this formula worked for me.
    =CONCATENATE(YEAR(A1)&"."& ROUNDUP(MONTH(A1)/3,0))
  14. re: Extract cell references from a formula using VBA?

    So I have made additional modifications to the initial code module and then to your code module to take full advantage of what I developed. Give it a try.



    Option Explicit
    Public evalcell As...
  15. re: Extract cell references from a formula using VBA?

    Here is a sub that calls changeformula and passes a range; 'studentrng' declared as a Public variable. It receives back the value of the boolean variable 'teststatus'.



    Option Explicit
    Public...
  16. Re: Problem executing VBA code using a button and also getting an output as '0'

    ashwin,

    A couple of things to consider. Your code is looking for "Interim" in Range("A2:A3") but you do not have "Interim" in those cells so "0" would be a correct response.
    With CountIfs, ALL...
  17. Replies
    6
    Views
    478

    Re: Access Date Formatting / Extraction

    You can use the VBA Split Function. I put your entry in cell A3 and then ran this code module.
    The Split Function puts results in an Array (datearray) and then you can pull out the piece parts you...
  18. Re: Populate table based on data in another sheet

    Okay, I have modified the code to look for Col K being blank and Col E contains any value
    I set the code to start on Row 13 on the Overview worksheet
    The code originally was written to identify the...
  19. Re: Populate table based on data in another sheet

    Hopefully you have the Developer feature enabled. If so, you will have a choice for "Developer" in you top menu (where File, Home, etc.) reside.
    Click on Developer
    Click on Visual Basic
    You...
  20. Replies
    3
    Views
    688

    Re: Type Mismatch Error in VBA for Range

    Don't know. I copied your code into a new spreadsheet, put data in a few rows in Column A and left some blank. Code ran as expected with no errors for me.
  21. Re: Populate table based on data in another sheet

    Give this code a try



    Option Explicit


    Sub CopyToOverview()
  22. Replies
    4
    Views
    385

    Re: Average of multiple columns

    cjop0,

    Are you wanting to include all Columns that have data in them?
    A B C D
    2 4 6 8

    Is it possible there would be any blank Columns with the data set?
    A B C D
    2 ...
  23. Replies
    3
    Views
    236

    Re: Looking for a Vba count solution

    Robert,

    Give this code a try.



    Option Explicit


    Sub LastLoss()
  24. re: Extract cell references from a formula using VBA?

    I don't mind trying to help you!

    I think we are thinking along the same lines with a bit of a twist. Where you are copying the formula from your Comparison Worksheet I'm thinking take the...
  25. re: Extract cell references from a formula using VBA?

    Here's an idea assuming you are using Excel 2011 or newer. There is a "Formula" function that returns the formula from a cell rather than the computed value. I tested it by putting the formula...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4