Search:

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

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. Replies
    2
    Views
    137

    Yeah I've got a sheet that is named Sheet1 at the...

    Yeah I've got a sheet that is named Sheet1 at the moment. I guess that's what I get for thinking that it would be quicker to type than copy and paste!

    The issue seems to have been resolved. Thanks...
  2. Replies
    4
    Views
    169

    I know a couple of ways to do this - Can you post...

    I know a couple of ways to do this - Can you post a sample spreadsheet so I can see exactly what you're trying to achieve?

    I think the easiest way to manage this would be setting up conditional...
  3. Replies
    2
    Views
    137

    Run Time error 424 Object Required

    Hey all,

    Was trying to make a script for cleverly importing some data but I'm getting run time error 424 from it and I can't figure out why!


    Sub GetData()
    '
    ' GetData Macro
    '
  4. Hi, Yes I'm english, though believe me I would...

    Hi,
    Yes I'm english, though believe me I would love to live in America!

    This actually got sidelined by a more important project but I will be getting back to it.

    I think that we would have to...
  5. Hi Maudibe, Populating them with the shifts...

    Hi Maudibe,

    Populating them with the shifts for each contract would probably be a much better solution...
    As for adding the Agents as labels, with the dynamic range set that would be easy to...
  6. Hi both, Thanks... Okay here we go I'm...

    Hi both,

    Thanks... Okay here we go

    I'm using excel 2010 at work and 2013 at home.

    Attached you can find the rota. I took out the names and replaced them with letters and numbers...

    In the...
  7. 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...
  8. Replies
    21
    Views
    733

    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
  9. Replies
    4
    Views
    321

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

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

    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 =...
  14. Replies
    21
    Views
    733

    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...
  15. Replies
    21
    Views
    733

    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...
  16. Replies
    4
    Views
    321

    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...
  17. Replies
    21
    Views
    733

    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
    ...
  18. 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...
  19. Replies
    21
    Views
    733

    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...
  20. 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...
  21. 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...
  22. Replies
    5
    Views
    320

    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
  23. Replies
    12
    Views
    544

    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
  24. 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...
  25. Replies
    12
    Views
    544

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