Consulting

Page 3 of 3 FirstFirst 1 2 3
Results 41 to 58 of 58

Thread: Sleeper: Automating some functions

  1. #41
    Ok here are the four forms that I see being needed.

    Default Expense is the Form that will be used when processing Expense payments. Info from here is automatically added to Total ongoing. There is a Vlookup formula that will be used to find the email for the company. The spreadsheet will then email itself to that email address.

    Default Indemnity will be used for processing Indemnity payments. Info from here is automatically added to Total ongoing. There is a Vlookup formula that will be used to find the email for the company. The spreadsheet will then email itself to that email address.

    The Email Sheet will hold the Firm/Company info (including Email).

    The Total Ongoing will be where the info is gathered for the whole year/per company.

    I sure hope this makes theings a bit clearer.

  2. #42
    VBAX Contributor Daxton A.'s Avatar
    Joined
    Jun 2004
    Location
    Biloxi, Mississippi
    Posts
    143
    Location

    You both have an email

    I sent it to your email b/c it was to big to send in here.

    Daxton

  3. #43
    VBAX Contributor Daxton A.'s Avatar
    Joined
    Jun 2004
    Location
    Biloxi, Mississippi
    Posts
    143
    Location

    I put the prev msg

    in this one instead of putting it in the validating one. I was just reading this one & left for a few seconds & forgot I had switched them b/c I wanted to see if I could be any help. Im sorry.

  4. #44
    hey Dax, Not sure if you know this or not. There are no attachments.

  5. #45
    Site Admin
    The Princess
    VBAX Guru Anne Troy's Avatar
    Joined
    May 2004
    Location
    Arlington Heights, IL
    Posts
    2,530
    Location
    Dax: I should delete your two posts above?
    If so, I'll also delete THIS post of mine and rcbricker's.
    ~Anne Troy

  6. #46
    Attachments must have been good cause haven't heard anything from you all.

  7. #47
    Site Admin
    The Princess VBAX Guru Anne Troy's Avatar
    Joined
    May 2004
    Location
    Arlington Heights, IL
    Posts
    2,530
    Location
    RC: Dax is working on an Access database to perform this task.

    I sent your form via email. How is it?
    ~Anne Troy

  8. #48
    didn't get it.

  9. #49
    Site Admin
    The Princess VBAX Guru Anne Troy's Avatar
    Joined
    May 2004
    Location
    Arlington Heights, IL
    Posts
    2,530
    Location
    Re-sent to @randall...
    ~Anne Troy

  10. #50
    got it. server was fuzzy earlier. Very nice job Dream

  11. #51
    Site Admin
    The Princess VBAX Guru Anne Troy's Avatar
    Joined
    May 2004
    Location
    Arlington Heights, IL
    Posts
    2,530
    Location
    Where are we on this one, Richard? Still need our help?
    ~Anne Troy

  12. #52
    sorry was sick. Yes still need help have not heard anything back yet.

  13. #53
    Site Admin
    The Princess VBAX Guru Anne Troy's Avatar
    Joined
    May 2004
    Location
    Arlington Heights, IL
    Posts
    2,530
    Location
    Have not heard anything back from who, rc?
    ~Anne Troy

  14. #54
    I got your Form spreadsheet and got a couple PMs from Firefly. But i have not gotten anything on the spreadsheets that i submitted.

  15. #55
    Site Admin
    The Princess VBAX Guru Anne Troy's Avatar
    Joined
    May 2004
    Location
    Arlington Heights, IL
    Posts
    2,530
    Location
    Okay.
    The Default Indemnity: You're going to take all of these and put them into one worksheet, right?
    The Email Tests: Isn't needed, you just need to add a worksheet with company info, including email address(es) as one of the columns.
    The Default Expense: This is the same as indemnity. You were just going to add a column for TYPE. Now you can choose the type indemnity, expense, and there were two others, right?
    The Total Ongoing: Is kinda of void since we've discussed the way you'll do it now.

    Did you forget our phone conversation?
    ~Anne Troy

  16. #56
    nope but firefly wasn't part of it. I remember our conversation. I thought there were still some VBA that was being done. If not I will test the spreadsheet.

  17. #57
    Site Admin
    The Princess VBAX Guru Anne Troy's Avatar
    Joined
    May 2004
    Location
    Arlington Heights, IL
    Posts
    2,530
    Location
    LOL. He's firefytr (as in fireman), and we can't do VBA until we know your exact spreadsheet layout.
    ~Anne Troy

  18. #58
    Site Admin
    Urban Myth
    VBAX Guru
    Joined
    May 2004
    Location
    Oregon, United States
    Posts
    4,940
    Location
    Quote Originally Posted by rcbricker
    ...If not I will test the spreadsheet.
    And the results...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •