Search:

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

Page 1 of 3 1 2 3

Search: Search took 0.00 seconds.

  1. Replies
    1
    Views
    620

    Power BI Certified Courses

    Hi, my company is prepared to put me through a Power BI course and have asked me to find a course that fits our needs:

    > Preferably a week / 2 week classroom based intense course
    > Certification...
  2. Replies
    4
    Views
    176

    Re: Sumifs using two date ranges

    Hi a system output gives me lines of transactions in the format of the first section "Employee Name", "Date From", "Date To" & "Utilisation", on another tab i am trying to sum the utilisation days...
  3. Replies
    4
    Views
    176

    Sumifs using two date ranges

    Hi,

    I am struggling to find a formula to sum utilisation days using two date ranges which is a dump from a system, ideally i would get users to enter info one day at a time but that's not possible...
  4. Replies
    12
    Views
    503

    Re: VBA loop with step / incrament

    Thanks for reply, i saw this and thought it would work as i can see i was missing the "Trim" reference but it didn't i still get the same error.

    However, when i change the > to < it works, but...
  5. Replies
    12
    Views
    503

    Re: VBA loop with step / incrament

    Hi @Akuini you helped me a while back regarding a loop issue as per above chat. I used your mod suggestion but settled on the below code, basically i have a userform so the user can enter what...
  6. Replies
    3
    Views
    282

    Re: Power query total table

    Thanks for all the suggestions folks, what i have gone with is:

    > create 10 query connections
    > append these into one table connection
    > duplicate the appended table, group the rows in query to...
  7. Replies
    3
    Views
    282

    Power query total table

    Hi, I have 10 tables which represents 10 regions all have individual files, the tables are the same in structure but obviously the values relate to each region.


    I have created connections...
  8. Replies
    8
    Views
    313

    Re: Cell reference trigger macro

    The cell is from a data validation list numbers 1 to 5, i even tried just typing in the number but still nothing, will try removing validation and try on another worksheet to check.

    Yea i need 5...
  9. Replies
    8
    Views
    313

    Re: Cell reference trigger macro

    Hi, thanks for the reply unfortunately the same issue, if i change to anything but 1 or 2 nothing happens!
  10. Replies
    8
    Views
    313

    Cell reference trigger macro

    Hello, I am trying to call macros based on the number in one cell but only the change for numbers 1 & 2 seem to work:

    Private Sub Worksheet_Change(ByVal Target As Excel.Range)
    If...
  11. Replies
    2
    Views
    399

    Re: VBA Group / Ungroup

    Hi, VBA doesn't record anything when you toggle grouping using the excel grouping buttons.

    I don't want to remove / insert grouping i want to toggle the already existing grouped sections between...
  12. Replies
    2
    Views
    399

    VBA Group / Ungroup

    Hello,

    I have the below code to toggle my grouped columns in excel to expand and contract (the code doesn't remove the grouping), how do I amend this code so that this only applies to specific...
  13. Thread: Sumproduct

    by Abvlecxe
    Replies
    6
    Views
    303

    Re: Sumproduct

    Hi, that is 99% there. It now gives 1 where the dates match which is good but where the dates don't match i also need it to add 1:

    E.g. column a = 01/01/2018
    column B = 08/01/2018
    ...
  14. Thread: Sumproduct

    by Abvlecxe
    Replies
    6
    Views
    303

    Re: Sumproduct

    Actually i've checked this line by line and it works to an extent, where i now see it falls over is that where you subtract the same date it returns 0 whereas i need the formula to count this as a...
  15. Thread: Sumproduct

    by Abvlecxe
    Replies
    6
    Views
    303

    Sumproduct

    Hello, I am trying to use Sumproduct to calculate the difference between two dates per row, using the following:


    Column A = From Date
    Column B = To Date


    I have tried both of the following...
  16. Replies
    12
    Views
    503

    Re: VBA loop with step / incrament

    Perfect, thank you
  17. Replies
    12
    Views
    503

    Re: VBA loop with step / incrament

    Thanks for taking the time to explain the code.

    I think I have managed to fix the issue mentioned above where the code allows the number 12 by adding "And myvalue >=19" at the end of your code.
    ...
  18. Replies
    12
    Views
    503

    Re: VBA loop with step / incrament

    Actually there is an error with this code, It allows entry of the number 12 but 19 should b the minimum number allowed, any ideas?
  19. Replies
    12
    Views
    503

    Re: VBA loop with step / incrament

    Oooh that looks it works, thanks very much.

    One question, why the part (my value -19) ?
  20. Replies
    12
    Views
    503

    VBA loop with step / incrament

    Hi I have the following code below which works but as you can see is very manual in terms of the loop until the input entry is correct. Basically I want the code to check that the number the user...
  21. Thread: Input Box

    by Abvlecxe
    Replies
    6
    Views
    255

    Re: Input Box

    Hi thanks for response.

    The input result i am actually using for another peace of code but i need to restrict the user selection to multiples of 10, do you know the code for this?

    I have since...
  22. Thread: Input Box

    by Abvlecxe
    Replies
    6
    Views
    255

    Input Box

    Hi looking for help with my input box macro below, I am looking to have the macro only allow certain numbers e.g. 10,20,30,40,50 etc but this doesn't work:

    Sub runQsheet()
    Dim myValue As...
  23. Replies
    7
    Views
    11,615

    Re: Change Data Source of OLEDBConnection

    Hi Onemeg,
    What was your final code used to change your data source?

    I am facing a similar issue and have spent days searching for an answer but i've not yet found one that works!
    Thanks
  24. Replies
    5
    Views
    4,687

    Re: VBA to change Workbook data connections

    Hi, sorry to open an old thread but I was wondering if you ever did find a solution to this problem as I am facing the same source file issue, thanks
  25. Replies
    2
    Views
    196

    Re: Data Connection

    I have come across this code which requires the user toselect a new source file, however when selected the query connections don’tactually update.

    Any ideas?

    Sub xlTest()

    Dim i As Long
    ...
Results 1 to 25 of 52
Page 1 of 3 1 2 3