Search:

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

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. Replies
    2
    Views
    107

    Re: Code for making empy cells zero - issues.

    Thanks Steve, true enough if I select a range and use "clear contents" first it works. Looks like the is a space in all the empty cells Arrgghhh
  2. Replies
    2
    Views
    107

    Code for making empy cells zero - issues.

    Morning all.
    I found the below code to fill a selected range that has empty cells amongst the data to fill the blank cells with whatever input into the resulting pop up box, in this case zero.
    It...
  3. Replies
    13
    Views
    270

    Re: Listed Employee data

    That is much appreciated as it helps massively.
    This row in your code for populating the date column For d = minDate To maxDate Step 7 is this basically reading the min and max date and populating...
  4. Replies
    13
    Views
    270

    Re: Listed Employee data

    That is absolutely amazing, thank you so much.
    I will now work through the code to try and understand the processes in action and make it work for the rest of the columns of data.
    Thanks again.
  5. Replies
    13
    Views
    270

    Re: Listed Employee data

    As exported from the application they are;
    B Ref
    C Employee Name
    D Date
    E Total Gross
    F E'er NIC
    G E'ee NIC
    H Tax Paid
    I Net Pay
    Thanks
  6. Replies
    13
    Views
    270

    Re: Listed Employee data

    There is quite a number the original spreadsheet is just shy of a thousand lines, next year will be maybe 50% bigger hence trying to work a solution out rather than manually copy and pasting each...
  7. Replies
    13
    Views
    270

    Re: Listed Employee data

    <tbody>
    Pay Date

    Empl 1

    Empl 2

    Empl 3

    Empl 4
  8. Replies
    13
    Views
    270

    Re: Listed Employee data

    https://1drv.ms/u/s!AivYfagw9jkq3gNC-ZWPfJQ5LClbMany thanks.

    As can be seen by the snippit below that not all employee data has the same number of entries or set of dates. But the dates are...
  9. Replies
    13
    Views
    270

    Listed Employee data

    Good afternoon, by racking my tiny brains on this one as to whether it is actually possible with such little knowledge I have, although a fast(ish) learner. I tried pivot tables but could only get on...
  10. Replies
    8
    Views
    195

    Re: Please point me in the right direction.

    I'll give it a try when I get a second, thanks.
  11. Replies
    8
    Views
    195

    Re: Please point me in the right direction.

    I went with the start date and end date cells and used the sumifs function. Would have been nice to filter the data itself and the summary update automatically as sometimes the data will need...
  12. Replies
    8
    Views
    195

    Re: Please point me in the right direction.

    Simply put, when I restrict the data table by certain dates, I would like the summary table to reflect the total, only what is on display on the data table.
  13. Replies
    8
    Views
    195

    Re: Please point me in the right direction.

    DB working now https://www.dropbox.com/s/psllgu9z165yxbh/Test%20Data.xlsx?dl=0
  14. Replies
    8
    Views
    195

    Re: Please point me in the right direction.

    Something went wrong with the Dropbox install but I have the Onedrive link..... https://1drv.ms/x/s!AivYfagw9jkqjG04DprCiiRx3C3q
    Thanks.
  15. Replies
    8
    Views
    195

    Please point me in the right direction.

    Hi everyone.

    I have a simple table that has expenses in.... Date, Description, amount and ExpenseType.
    On a separate tab I have a summary table to give a total of each expense type using the...
  16. Replies
    2
    Views
    137

    Re: New table row question

    Figured it out, I inserted the below code just before the first End If and it worked :)
    Dim ws As Worksheet
    Set ws = Sheet2
    Dim tbl As ListObject
    Set tbl = ws.ListObjects("Table2")...
  17. Replies
    2
    Views
    137

    Re: New table row question

    This is the code used for adding the ID number.
    I was thinking that on this code running, we can assume that a new row has been created a use that as the trigger and add a line of code that does...
  18. Replies
    2
    Views
    137

    New table row question

    Good afternoon all.

    I have a spreadsheet with 5 tabs of various names all with a table in.
    They have various details in the tables all with a common key (TempID). I have some code that I found...
  19. Replies
    13
    Views
    922

    Re: If this and that!

    Thank you both for your replies.
    Very helpful, I was nearly there I had my Y/N conditioning met but could not get the formula to do me sums!

    Thanks again
  20. Replies
    13
    Views
    922

    Re: If this and that!

    That works too with the same change.
    Thank you
  21. Replies
    13
    Views
    922

    Re: If this and that!

    Nearly there
    =IF(D2="Y",IF(Table6[[#This Row],[Gross ]]>865,753*0.01,IF(AND(Table6[[#This Row],[Gross ]]>113,Table6[[#This Row],[Gross ]]<865),(Table6[[#This Row],[Gross ]]-113)*0.01)),0)...
  22. Replies
    13
    Views
    922

    Re: If this and that!

    Nearly there too.
    =IF(AND(D4="y",E4>865),7.53,IF(AND(E4>113,D4="y"),(E4-113)*0.01,0))
  23. Replies
    13
    Views
    922

    Re: If this and that!

    753 is the banded Gross earnings that contributions are paid on when gross is over 865
    The contributions for earnings under 866 is paid on the band of earnings 113 to 865, so we have if the gross...
  24. Replies
    13
    Views
    922

    Re: If this and that!

    Its in a Table but lets say E2
  25. Replies
    13
    Views
    922

    If this and that!

    Hi All, been racking my brains on this one, looked at loads of examples. I think I just do not understand the structure of combining the if and or statements as I have written it down and it makes...
Results 1 to 25 of 29
Page 1 of 2 1 2