Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.04 seconds.

  1. Re: Calculate worked hours based upon criteria

    That is spot on thank you
  2. Calculate worked hours based upon criteria

    Hi All,


    I have a sheet where it records a time when one of our trucks goes into a dealer. It also records the time the trucks leaves the dealer. I would like to workout how long the vehicle...
  3. Re: 30/60/90 days reminders emailed from excel

    Hi Richard,

    I have a sheet that sends out reminders to customers who have not issued a PO to cover off there repair bills. I have set up 3 columns, one with original date, one with the first...
  4. Re: VBA Data Validation depending on Target Value

    Yes, the data sheet is where the fines are logged. The fines and authrorites are on a sheet called Extra. The Dropdown lists are Data Validation lists on the Data Sheet.

    Hope this helps
  5. Re: VBA Data Validation depending on Target Value

    Thank you for the reply. On the main data sheet, in column B, I have a drop list of all authorities, inc police forces. In column F, i have a drop list of all the fines for both Council and police....
  6. Replies
    3
    Views
    676

    Re: Adding another Column

    I have 3 queries all coming from 3 tables, which are all in separate worksheets. They combine into one query which in turn loads into a table. I would like to add 1 column from each of the separate...
  7. Replies
    3
    Views
    676

    Adding another Column

    Hi All,


    I have an existing Query which gets its data from an Excel Table. I would to include a column from the excel Table, which is not in the existing query. Can this be done?


    Thanks in...
  8. Replies
    5
    Views
    187

    Re: Data validation

    Would you be requiring Dependant Drop Lists?
  9. VBA Data Validation depending on Target Value

    Hi All.

    I have Data Sheet which logs Penalty Charge Notices. There is a column which has all Authorities, including Police. In another column i have a list of Fine Types, for both police and...
  10. Replies
    6
    Views
    205

    Re: Change Event Code

    Thank you very much. This has help my understanding as well
  11. Replies
    6
    Views
    205

    Re: Change Event Code

    Original Sheet Column E
    Hot Deal Sheet D
  12. Replies
    6
    Views
    205

    Re: Change Event Code

    Thank you for the code.

    In the copied cells there is a Reference, for example, DW1123, this is unique to that row.

    I have tried the below, but it does not work :(


    For Each Cell In Target
  13. Replies
    6
    Views
    205

    Change Event Code

    Hi All,

    I am very stumped at the moment. I am using the below code to copy cells if the Sales person selects an option:


    Private Sub Worksheet_Change(ByVal Target As Range)


    ...
  14. Re: Run Macro if Cell changes from Hot to Won

    After doing some hunting online, I have come up with this the below code:

    Private Sub Worksheet_Calculate()




    With Sheets("Dave Wilson").Cells(Target.Row, "X").Value

    ...
  15. Re: Run Macro if Cell changes from Hot to Won

    Thank you for the reply, but I think you might have misunderstood what I am after.

    I have uploaded a file: https://www.dropbox.com/s/u4g65n84291rhw0/Salesperson%20File.xlsm?dl=0

    What I have. ...
  16. Run Macro if Cell changes from Hot to Won

    Hi

    I am running a change event macro. I have a column on the sheet, where the user changes a value from "Hot" to "Won". What I would like to happen is when this happens, a macro will run.
    ...
  17. Replies
    0
    Views
    140

    Error in VBA Code

    Hi All,

    I am using the below code:

    Private Sub Worksheet_Change(ByVal Target As Range)
    Dim Finearray() As String
    Dim Lenght As Integer
    Dim Rng As Integer
    Dim count As Integer
    Dim ValStr...
  18. Replies
    4
    Views
    199

    Re: Reference Tables in VBA

    Thank you Mark858, it is a great link!
  19. Replies
    4
    Views
    199

    Re: Reference Tables in VBA

    Thank you Norie for you help, it is now working.
  20. Replies
    4
    Views
    199

    Reference Tables in VBA

    Hi All,

    I wonder if someone could point me in the right direction. I have an excel table, named Customers. In the table, there are two columns, Customer and PO, I would like reference that...
  21. Replies
    1
    Views
    127

    Dynamic Multi Level Column Graph

    Hi all,

    I am after a way to create a dynamic multi level graph, without using a Pivot Table. What i would like is the graph to change, when selecting the month, to show category, depot, fine...
  22. Replies
    3
    Views
    206

    Re: VBA Lookup using Tables

    Thank you Fluff
  23. Replies
    3
    Views
    206

    VBA Lookup using Tables

    Hi All,

    I am using the code below to lookup a value from a Table.

    Private Sub Worksheet_Change(ByVal Target As Range)
    Dim LU As String
    Dim Auth As Variant
    Dim LU2 As String
    Dim...
  24. Replies
    4
    Views
    497

    Re: Unable to extract Data

    I have solved the issue, I was using the wrong data format in the three feeding tables. Once adjusted, it works.
  25. Replies
    4
    Views
    497

    Re: Unable to extract Data

    Sorry, yes it does return Zeros. I have tried different permutations with the same result
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4