Search:

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

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. Populating multiple Time Pickers with a combo box

    Hi all,

    I've been attempting to create a userform for maintaining and updating a rota.

    I've created a userform where I've put shift patterns in, and there's a combo box that has a number of...
  2. Replies
    21
    Views
    596

    Hi RG No problem :) Sub GetData() '...

    Hi RG

    No problem :)

    Sub GetData()
    ' GetData Macro
    Dim wkbSCC As Workbook
    Dim wkbLBG As Workbook
    Dim wkbLBR As Workbook
    Dim wkbCSC As Workbook
  3. Replies
    4
    Views
    274

    Thanks a lot guys! I ended up with a book by John...

    Thanks a lot guys! I ended up with a book by John Walkenbach which promises to give me examples of codes and how they work - I can also download a lot of the workbooks to see the codes in a sheet.
    ...
  4. That's interesting this thread popped up. I spend...

    That's interesting this thread popped up. I spend a lot of time saving spreadsheets that are emailed to me and I've been working on an email script to auto save the attachments....

    I assume this...
  5. Replies
    4
    Views
    231

    Merged Cells causing issues

    Hi everyone!

    I tried really hard to fix this one myself I promise....

    Basically I am trying to merge two reports ( they are set, I cannot change them unfortunately... I've tried but it won't...
  6. Hi Maudibe. Thanks for your post! I tried this...

    Hi Maudibe. Thanks for your post!

    I tried this script earlier today and think I messed it up when I tried to put it on the end of my other macro... I will try again tomorrow :)

    R
  7. Replies
    21
    Views
    596

    Hi all, thanks for the help! Below you can see my...

    Hi all, thanks for the help! Below you can see my code in it's current format...

    Dim wkbSCC As Workbook
    Dim wkbLBG As Workbook
    Set wkbSCC = ActiveWorkbook
    Set wkbLBG =...
  8. Replies
    21
    Views
    596

    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...
  9. Replies
    21
    Views
    596

    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...
  10. Replies
    4
    Views
    274

    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...
  11. Replies
    21
    Views
    596

    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
    ...
  12. 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...
  13. Replies
    21
    Views
    596

    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...
  14. 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...
  15. 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...
  16. Replies
    5
    Views
    276

    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
  17. Replies
    12
    Views
    482

    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
  18. 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...
  19. Replies
    12
    Views
    482

    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...
  20. 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...
  21. 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
  22. 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...
  23. Replies
    9
    Views
    424

    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...
  24. Replies
    9
    Views
    424

    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...
  25. Replies
    9
    Views
    424

    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...
Results 1 to 25 of 27
Page 1 of 2 1 2