Search:

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

Search: Search took 0.00 seconds.

  1. Replies
    14
    Views
    247

    Thanks Rory - I'll try with the updated code, if...

    Thanks Rory - I'll try with the updated code, if that works i will have saved about 150 lines of code from that suggestion!

    And @RetiredGeek - Using the format you suggested means that it will be...
  2. Replies
    14
    Views
    247

    Hi sdckapr thanks for your post! I tried the code...

    Hi sdckapr thanks for your post! I tried the code you posted and it brings up the error
    "Run-time error '438':
    Object doesn't support this property or method"

    Not too great on the whole...
  3. Replies
    3
    Views
    111

    Learning VBA - Resource Guide

    Hi all,

    As a few of you know I'm attempting to learn VBA right now, and I wondered if anyone had any advice as to what resources are available.

    I've been told by my employer that if I need to...
  4. Replies
    14
    Views
    247

    Ohh that would definitely make it look a lot...

    Ohh that would definitely make it look a lot neater plus get me used to setting stuff as variables!

    I'll have have a test with one file and let you know how it goes :)

    Thanks a lot

    R
    ...
  5. Posting a row of Data Into Range until full

    Okay another post here...

    Basically I would like to save some time on my worksheet, at the moment I'm manually copying and pasting a row into two ranges.

    I've attached the spreadsheet so you...
  6. Replies
    14
    Views
    247

    Trimming VBA Code

    Hi all!

    Just a quicky really, as I'm (slowly) getting to grips with VBA I'm realising that a lot of the code I've recorded/edited could probably be trimmed down a lot..

    Here's a snippet of a...
  7. Public Sub Submit() 'CODE ASSUMES THAT IT IS RAN...

    Public Sub Submit()
    'CODE ASSUMES THAT IT IS RAN FROM THE SOURCE SHEET
    '------------------------------
    'DECLARE AND SET VARIABLES
    Dim s(22)
    Dim StartRow As Integer
    Dim LastRow As...
  8. Hey Maudibe - Just had a couple of ideas... Is...

    Hey Maudibe - Just had a couple of ideas...

    Is there a way for me to put in a sense check at the beginning of the script which checks for blank fields and exits the sub ( with a message box...
  9. Replies
    5
    Views
    218

    I do something similar with Wingdings 2 font...

    I do something similar with Wingdings 2 font
    shift O for a cross and shift P for a tick

    R
  10. Replies
    12
    Views
    385

    In the current format you could do something like...

    In the current format you could do something like in the spreadsheet I attached.
    Let me know if this helps

    R
  11. I tested it today and it works perfectly - All...

    I tested it today and it works perfectly - All I've done is add a line that closes the Data workbook after a duplicate is found :)

    Thanks again Maudibe you're a star - You and RetiredGeek are...
  12. Replies
    12
    Views
    385

    As stated above the example spreadsheet would...

    As stated above the example spreadsheet would help figure out what you were after here :)

    =1-(COUNTIF('Unexcused',"U")/'TotalCount'
    where 'Unexcused' = the column in which the unexcused absences...
  13. Funnily enough I had my first duplication today...

    Funnily enough I had my first duplication today and came to ask why that would be! You are definitely efficient, thanks a lot - incidently I'm actually beginning to understand what each line means in...
  14. Hi Maudibe! Thanks a lot for your help - I...

    Hi Maudibe!

    Thanks a lot for your help - I will try the macro out later today and let you know the results.

    R
  15. Data Submit Macro - Preventing Duplication?

    Hi guys!

    I've created a simple form submit sheet which will submit the data into a seperate workbook, save that workbook and close it.

    You can see the code below:

    ActiveWindow.SmallScroll...
  16. Replies
    9
    Views
    321

    I did download your workbook however the one...

    I did download your workbook however the one night I don't bring my laptop home is tonight!!

    I will definitely try that tomorrow though, thanks :)

    The records only really hit 10,000 if we've...
  17. Replies
    9
    Views
    321

    Hello RetiredGeek! I've tried putting that macro...

    Hello RetiredGeek! I've tried putting that macro into my spreadsheet to no avail yet..
    I'm really entirely new to this level of excel, guess the macro needs slightly editing and i'm not competent...
  18. Replies
    9
    Views
    321

    Okay as promised here is a sample of the sort of...

    Okay as promised here is a sample of the sort of sheet i am using

    Almost all the data in the columns is relevant to the people working the overdue jobs, ive only put a few jobs on bearing in mind...
  19. Replies
    9
    Views
    321

    Hey guys, thanks for your responses! I...

    Hey guys, thanks for your responses!

    I actually have my work laptop with me so I can load a template up, I originally used pivot tables for the count but because there is such a vast amount of...
  20. Replies
    9
    Views
    321

    Macro for pulling data rows

    Hi everyone! This is probably the first post of many to come so here goes:

    Little about myself, I've just got a new job as a data analyst and I don't know how I managed it! I'm okay with the...
Results 1 to 20 of 20