Posts by Sarah2Ryan

    hi,


    Need some VBA code to do the following please.
    This is the layout of my master form. Top row are the headings. I have created a macro which populates this information from another spreadsheet which changes weekly.
    Next I need a macro to send information from Column A to column E to the email address in Column J.
    Some will have multiple entries and I need these to populate only 1 email (one email for each Customer - email address with potentially multiple entries).
    It should pick up the Customer name in column F1 (To .....), add a line of text asking for updates on these entries (final text to be confirmed) and finishing off with Kind Regards and the "User's" signature if present in Lotus Notes.


    I am asking for a lot here so any help greatly appreciated.


    A1 B1 C1 D1 E1 F1 J1 [TABLE="width: 769"]

    [tr]


    [td]

    Policy Number

    [/td]


    [td]

    Reg

    [/td]


    [td]

    Date

    [/td]


    [td]

    W

    [/td]


    [td]

    Description of Error

    [/td]


    [td]

    Customer Email addres
    Name

    [/td]


    [/tr]


    [/TABLE]

    hi,


    I need some help please with my VBA code. Totally new to VBA and Macro's!
    I have a Worksheet which is recording a list of tasks a team member plans and actually completes each day.
    The sheet has formulas to calculate the task time and insert dates etc.
    I have created a macro which copies the data in certain cells and pastes just the values to another worksheet.
    I then have a macro which clears these cells and they can be used again the next day to input their planned and actual tasks.
    Problem is, when I extract the next days information, it is leaving a hugh gap between todays and tomorrows listed tasks. It is not looking for the next available line but inputting at the end of the last copy. So for example, a user has the option to input 50 tasks (certain cells prefilled with formulas which populate if other cells are filled). If the user only inputs 5 tasks, it still copies the 50 lines over to my new workbook but as there are only formulas and no data in 45 of the lines, it pastes blanks. But on the next copy, it starts at line 51 instead of line 6. Hope this makes sense!
    Here is the code I've input so far:


    Any help greatly appreciated.
    Kind regards,
    Sarah