Search:

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

Search: Search took 0.00 seconds.

  1. Replies
    13
    Views
    412

    Re: SUM the Previous n Cell Values

    Thank you for your help. I was able to find a solution to my problem.
  2. Replies
    13
    Views
    412

    Re: SUM the Previous n Cell Values

    <tbody>

    D

    E

    F

    G
  3. Replies
    13
    Views
    412

    Re: SUM the Previous n Cell Values

    Thank you I will respond with an example soon. I am using Internet Explorer.
  4. Replies
    13
    Views
    412

    Re: SUM the Previous n Cell Values

    Hello,

    Ireplied to this thread because I am looking for a similar solution. I havenumbers in rows 6 and 7. Row 6 has set numbers that will not change. I need tosum the numbers in...
  5. Replies
    9
    Views
    121

    Re: Applying a Macro to a range of cells

    Thank you everyone for your input. The edit done by JoeMowas the exact fix I was looking for. It is true, this a macro I copied andtweaked to fit my needs. I am very new to VBA and am attempting to...
  6. Replies
    9
    Views
    121

    Applying a Macro to a range of cells

    Hello,

    I need to apply my split macro to range of cells. I currently have cell D4 selected but I need the range D4:D100 to be affected by the macro. How do I type that range out? I've tried typing...
  7. Re: Count Emails in Outlook and export to excel

    Why don't you recommend the alternative method?
  8. Re: Count Emails in Outlook and export to excel

    I'd like for the macro to pull from Outlook a few times a day if possible.
  9. Replies
    2
    Views
    110

    Re: Split function placement

    Also, is it possible to use text as a delimiter?

    Thank you.
  10. Replies
    2
    Views
    110

    Re: Split function placement

    Sub getDataFromOutlook()
    Dim OutlookApp As Outlook.Application
    Dim OutlookNamespace As Namespace
    Dim Folder As MAPIFolder
    Dim OutlookMail As Variant
    Dim i As Integer
    Set OutlookApp = New...
  11. Replies
    2
    Views
    110

    Split function placement

    Hello,

    I am currently using a VBA code which extracts emails from outlook. I am attempting to use the split function in order to separate the body of the email using a colon as a delimiter. I am...
  12. Re: I want to extract all details form outlook emails in excel using vba according to particular word in subject of email

    Essentially I would like for it to refresh whenever a new email is received in that folder, but I'm not sure if that's possible. If it could automatically run four times a day that would be great as...
  13. Re: Count Emails in Outlook and export to excel

    DanteAmor,

    Is there a to automate the code so it is constantly pulling from Outlook?

    Thank you.
  14. Re: I want to extract all details form outlook emails in excel using vba according to particular word in subject of email

    Hello,

    Is there a way to run this VBA automatically. For instance, I am using a VBA code to extract emails from a specific folder. I've added the macro to a button on the worksheet which I have to...
  15. Re: Unable to insert a row with two active tables

    Thank you Jason75. You're right. I wasn't able to find an alternative.
  16. Unable to insert a row with two active tables

    Hello,

    I am having an issue with inserting a row into my worksheet. I believe it's because I have two tables a few columns apart from each other. I say this because I was originally able to...
  17. Using "Left" function nested within a "Match" nested within an "Index" function

    Hello,

    I can't seem to figure out where to place the "Left" function in the below formula. Cell "EA7" contains a number followed by three letters. These letters will only always be one of the...
  18. Replies
    0
    Views
    666

    Scanning Data into Excel

    I am looking for a way to scan data into Excel in the background while other programs are open and active. We currently use a scanner connected by USB to scan data into a secure site for time...
Results 1 to 18 of 18