Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.05 seconds.

  1. Check is a single row in Listobject is selected

    I am looking for a way to check if the user has selected a single cell or single row within a Listobject. If this is the case, then I would like to return the value from Column 1 of the Listobject...
  2. Re: Excel - Check if date is greater in 2 columns

    so the second column could be blank or not... the first column always has a date... if both columns are blank then the check should be skipped for that row... essentially i am checking if the...
  3. Re: Excel - Check if date is greater in 2 columns

    ok this works but if the date is left blank it also gives an error... is there a way to skip blank cells ?
  4. Excel - Check if date is greater in 2 columns

    I have two columns with dates. Is it possible to check (with a single formula) that for each row, the date entered in column 2 is always greater than the date entered in column 1?

    many thanks
  5. Sequential Numbering Positive/Negative Amounts

    Hey all,

    I have column A containing positive and negative numbers and I am looking for a formula in column B for sequential numbering as follows

    col A col B
    20 PS001
    32 ...
  6. Re: VBA Currency Conversion Function (Historical Date)

    Hi Koen,

    This is very useful and works as expected.. Hope exchangeratesapi.io don't change their web structure as this presumably will break the function :)
  7. VBA Currency Conversion Function (Historical Date)

    I have been looking around the internet with no success for a VBA function which will simply take 3 arguments: Currency From, Currency To, Date and output the relevant FX Rate. Has anyone worked with...
  8. Replies
    2
    Views
    115

    Re: Trigger Macro when cell changes

    ok, I have figured this out as well, thanks norie
  9. Replies
    2
    Views
    115

    Trigger Macro when cell changes

    I am trying to fire a macro only when the cell value inside a specified range changes (i.e. not selected but actually changed in value).

    I am using this code but it fires every time a cell is...
  10. Replies
    1
    Views
    104

    Copy/Paste in Sheet - Values Only

    I would like my users to be able to copy and paste freely on a ListObject table, but only values (i.e. not messing with formatting/data validation). Is this possible with a worksheet change event ?
    ...
  11. Restrict Sheet Use to Certain Columns of Table

    I am using this code which works fine to restrict selection of one cell in a sheet.

    Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    Target.Range("A1").Select
    ...
  12. Replies
    2
    Views
    102

    Re: Fill Column with Pattern

    thanks Rick, this seems to be working :)
  13. Replies
    2
    Views
    102

    Fill Column with Pattern

    I need to fill a column of my table with VBA as follows:

    IS100
    IS110
    IS120
    IS130

    I can select the range as follows but not sure how to proceed after:

    Range("table_admin[Sequence]")
  14. Replies
    2
    Views
    213

    Macro runs too slow - Any alternatives

    I have tried to optimise my macro as much as possible but still it takes over 30-60 seconds to execute for 2,000 entries. This is very poor performance and I was wondering if I can use any...
  15. Replies
    7
    Views
    327

    Re: Sum Identical Sheets - Faster Formula?

    yes I have, no errors with indirect.. as the sheet name is stored as text
  16. Replies
    7
    Views
    327

    Re: Sum Identical Sheets - Faster Formula?

    I was thinking of the same, but the advantage of indirect is that if you delete the sheet BankFeed2, you don't get Ref errors afterwards in the formula... :)
  17. Replies
    7
    Views
    327

    Re: Sum Identical Sheets - Faster Formula?

    Hmm.. I don't think I can go for the first option you are suggesting, but your suggested formula looks very neat. Do you think that would still be quicker than what I have? Or is it just cosmetically...
  18. Replies
    7
    Views
    327

    Sum Identical Sheets - Faster Formula?

    I am using this formula to sum between dates for a particular code number. The four sheets are identical in structure (with different table dimensions). I was wondering if there is a better option of...
  19. Re: Array Convert Pasted Range to Dates without looping

    also the code errors out on negative amounts..
  20. Re: Array Convert Pasted Range to Dates without looping

    this works, but also converts the amount column to dates.. is it possible to restrict this to column(2) of the array please?
  21. Array Convert Pasted Range to Dates without looping

    I am using this code which works fine:



    Set copyrng = lo_b1.AutoFilter.Range.SpecialCells(xlCellTypeVisible)
    copyrng.Copy Destination:=strng
    arr = strng.CurrentRegion.Offset(1, 0)
    aRws =...
  22. Replies
    4
    Views
    185

    Re: Array formula with multiple Countifs

    thanks this works as expected :)
  23. Replies
    10
    Views
    486

    Re: SUMIFS Multiple Criteria - Same Column

    ok it works as I hadn't changed to SUMPRODUCT
  24. Replies
    4
    Views
    185

    Re: Array formula with multiple Countifs

    It it helps now, this is the structure of my spreadsheet

    col A col B col C
    P on item1
    P off item2
    B on item3
    J on item4
    P on item5
    B ...
  25. Replies
    10
    Views
    486

    Re: SUMIFS Multiple Criteria - Same Column

    Marcelo, I have tested this and it only picks up first option, name1
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4