Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.02 seconds.

  1. Re: Indirect Formula to A Named Range Different Workbook

    Yes, both workbooks are open
  2. Indirect Formula to A Named Range Different Workbook

    Good morning All,

    I am struggling a bit with the indirect formula where I am trying to reference a named range in a different work sheet.

    The formula is retrning #ref and the formula is:
    ...
  3. Replies
    1
    Views
    136

    Re: Power Query Question

    Herewith attached example

    https://www.dropbox.com/sh/apkkb7ynto33u4l/AAB4dbqbsqCsHbqlWx9JySk5a?dl=0

    Thanks

    Herbz
  4. Replies
    1
    Views
    136

    Power Query Question

    Good afternoon folks,

    Any idea how I can convert data which looks like the below into 2 columns with grade and price using power query?

    Grade Amount Grade Amount Grade Amount
    Pxhg ...
  5. Replies
    1
    Views
    250

    Excel Report Templates

    Good afternoon All,

    Was just wondering if there are any good sites with excel report templates that I could "borrow". Looking to create some eye catching but simple reports, but cutting on the...
  6. Replies
    0
    Views
    162

    MSQuery on a MAC

    Good morning All,

    I am trying to open a spreadsheet which is on a shared driver (workbook was setup using a windows machine). The workbook has a macro to refresh itself every time on opening....
  7. Replies
    2
    Views
    3,199

    Re: Close Workbook after idle for 30 seconds

    Thank you, much much appreciated
  8. Replies
    2
    Views
    3,199

    Close Workbook after idle for 30 seconds

    Good morning All,

    Would anyone be able to assist with a vba code that will automatically close a workbook and save changes once it has been idle for a certain amount of time, say 30 seconds?
    ...
  9. Replies
    0
    Views
    92

    Refresh MS Query

    Hi All,

    I am using the following simple VBA to refresh an MS Query when opening an Excel spreadsheet (Because one of my users has a MAc so I cant use Power Query):

    Option Explicit

    Private...
  10. Replies
    4
    Views
    741

    Re: Power Query Update - Mac

    Not to worry RoryA,

    I have figured it out, many thanks.

    VBA code that I was using to update the links on opening when I was using PQ was:

    Private Sub Workbook_Open()

    ' Macro to update my...
  11. Replies
    4
    Views
    741

    Re: Power Query Update - Mac

    Thanks for the suggestion

    I have never used MS Query, I use Microsoft Office 365 how do I use it from Excel 2016?

    Thanks
  12. Replies
    4
    Views
    741

    Power Query Update - Mac

    Goodmorning All

    I have a small dilemma and was looking for ideas on a work around.

    There is an Excel report that I have built on our shared drive. This report is based on a table created from a...
  13. Replies
    3
    Views
    203

    Re: Code To Refresh Table

    Thank you

    Much appreciated
  14. Replies
    3
    Views
    203

    Code To Refresh Table

    Good afternoon All,

    I was wondering if someone could assist me with a VBA code which I can embed on to a sheet so that whenever that sheet is opened a power query table that is part of that...
  15. Replies
    4
    Views
    213

    Re: Formula To Create Categories

    Thank you
  16. Replies
    4
    Views
    213

    Formula To Create Categories

    Hi All.

    I have a list of product codes , which I would like to turn into product categories in the next column (sample product codes attached).

    The rules are as follows:

    If the code contains...
  17. Replies
    3
    Views
    772

    Re: Extract List Based on multiple criteria

    Thanks Joe,

    But I am looking for a formula

    Thanks
  18. Replies
    3
    Views
    772

    Extract List Based on multiple criteria

    Good afternoon All,

    I am looking for help with a formula to extract a list from a database based on 2 criteria. My data is on the tab "Database", and list needs to be on a "summary" sheet.

    I...
  19. Replies
    3
    Views
    265

    Re: Account Reconciliations Using Excel

    Thank you Dryver14

    Much appreciated, these videos are a huge help. Now I will look very clever. :)

    Thanks

    Herbiec
  20. Replies
    3
    Views
    265

    Account Reconciliations Using Excel

    Hi All,

    I am trying to put together a course for some colleagues who do a lot of account reconciliations. The types of reconciliations could be customer account reconciliations, bank account...
  21. Replies
    5
    Views
    303

    Re: Forecasting using Excel

    Thank you
  22. Replies
    5
    Views
    303

    Re: Forecasting using Excel

    Thanks Kamolga,

    Just so we are on the same page. The process of adding the January's together and dividing by 3 and doing the same for the other months, was to come up with an average for each...
  23. Replies
    5
    Views
    303

    Forecasting using Excel

    Good afternoon All,

    I am working for a super market chain and am looking for some Excel/Stats resources to help me understand the different types of forecasting I can perform in Excel, &...
  24. Replies
    0
    Views
    129

    Rank using Small

    Good afternoon All,

    I have the following array formula which works perfectly and returns a listing of unique values from a list based on a condition. Could someone help me tweak this using the...
  25. Replies
    9
    Views
    287

    Re: Formula - Position No In Unique List

    Thanks Andrew, you are a life saver, that worked perfectly

    H
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4