Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.10 seconds.

  1. Replies
    2
    Views
    47

    Re: select and copy

    Hi,

    If your question remains too generic ... it will be difficult to come up with a proposal ...

    Could you describe your workbook more precisely ...
  2. Replies
    6
    Views
    183

    Re: Macro to SaveAs PDF but alter the name

    Hi,

    Does it mean you would like a few hints to improve the performance of your above macro ...? :wink:
  3. Re: code works fine, but is there a faster method?

    Hi,

    AutoFilter is by far the Best method ...!!!

    In order to speed up your process ... just insert

    1. At the top of your macro:
    Application.Calculation = xlCalculationManual

    2. At the end...
  4. Replies
    6
    Views
    183

    Re: Macro to SaveAs PDF but alter the name

    Congratulations ... !!! :)

    What is so specific about your ' January's reports ' ?
  5. Thread: Match & sum

    by James006
    Replies
    3
    Views
    68

    Re: Match & sum

    Hello,

    With the Sheet Name in cell A1...

    You can test following :


    =SUM(INDIRECT(A1&"!A5:D5"))

    Hope this will help
  6. Re: Extracting City and State from a cell without commas

    Hello,

    Confusion ... is the right word ...

    You might take a look at fuzzy logic ...

    https://www.microsoft.com/en-us/download/details.aspx?id=15011

    Hope this will help
  7. Re: Extracting City and State from a cell without commas

    Hello,

    You can only build a solution if there are specific reliable rules :

    1. Does each State consist of ONE Word ALWAYS preceded by a blank ?

    2. Is each City also represented by ONE Word...
  8. Replies
    4
    Views
    139

    Re: Sumifs using two date ranges

    You can thank Marcelo ... who has guessed you were looking for OVERLAP ... :cool:
  9. Replies
    16
    Views
    509

    Re: How to calculate compound interest?

    Once you have tested the formula .... feel free to post your feedback
  10. Replies
    4
    Views
    139

    Re: Sumifs using two date ranges

    Hi,

    Not sure to understand your constraints ...

    Have you tried : =C2-B2
  11. Replies
    7
    Views
    215

    Re: reversing the order of 2 columns

    Why is Sorting prohibited ...???
  12. Replies
    1
    Views
    67

    Re: formatting a date

    Hello,

    Hope following link will help :

    https://www.mrexcel.com/forum/excel-questions/168063-converting-zulu-local-time.html#post821627
  13. Replies
    3
    Views
    128

    Re: Retrieve live data from index fund

    You can also simply use Power Query :

    https://exceloffthegrid.com/power-query-import-data-from-the-web/

    Hope this will help
  14. Replies
    5
    Views
    160

    Re: VLOOKUP and extract #N/A rows

    You are welcome
  15. Replies
    5
    Views
    160

    Re: VLOOKUP and extract #N/A rows

    Hello,

    To extract records based on a given criteria (#N/A) you could take a look at Autofilter ...

    Hope this will help
  16. Replies
    1
    Views
    57

    Re: Macro to disabe a macro

    Hello,

    In your macro you can have a Boolean variable which will allow (or not...) your second macro to run ...

    Hope this will help
  17. Replies
    2
    Views
    102

    Re: VBA code for undo

    Hi,

    For an effective solution ... take at look at Jan Karel Pieterse

    https://www.jkp-ads.com/Articles/UndoWithVBA00.asp

    Hope this will help
  18. Replies
    3
    Views
    128

    Re: Retrieve live data from index fund

    Hi,

    You can create a Data Query against your target web site ...

    such as https://www.rbcgam.com/en/ca/products/mutual-funds/rbf556/detail

    Hope this will help
  19. Re: stop counting in a cell when another has a date entered

    Hello,

    In cell I4, you could test following:

    =TODAY()-IF(J4="",H4,J4)

    Hope this will help
  20. Replies
    1
    Views
    80

    Re: Sum of the file in the folder

    Hello,

    In order to get values from closed files ...

    see link : https://exceloffthegrid.com/getting-values-from-a-closed-excel-workbook/

    Hope this will help
  21. Replies
    6
    Views
    183

    Re: Macro to SaveAs PDF but alter the name

    Hi,

    You are extremely close ...

    While building your FileName, with concatenation, you have "something" defined as the name ...

    and the date and ".pdf"

    Regarding the date, as long as there...
  22. Replies
    1
    Views
    70

    Re: workbooks.add, open and close

    Hi,

    For your generic questions ... a generic answer : Yes
  23. Re: Looking to learn a formula to help me with...

    Hi,

    In order to cross reference two lists, you could use the match function ...

    see following explanation :
    ...
  24. Replies
    16
    Views
    509

    Re: How to calculate compound interest?

    With your latest explanation ... there is NO compound interest ...

    What there is ... it is a 10% increase of your weekly amount ...

    With your initial amount in cell A1 : 10
    With your...
  25. Thread: Vba?

    by James006
    Replies
    5
    Views
    148

    Re: Vba?

    Hello,

    If your question is related to Accounting Reconciliation ...

    You are probably looking for " which numbers sum up to a given Total " ...

    Is that right ?
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4