Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Ephrata, Washington, USA
    Posts
    683
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Macro to append new row of data to existing file (2003)

    One of my coworkers has data that he downloads from PeopleSoft into a temp file on a monthly basis - he said he can make it a csv or txt file.

    He has an existing spreadsheet and he wants this new data appended as a new row in the spreadsheet - and then insert a new blank row below the appended row. We don't need to manipulate the field order. Just insert the new row.

    He'd like this to be something that is run automatically whenever the worksheet is opened so the user doesn't have to do it. The kicker is, he wants the macro to check and see if the data has already been appended for that month and not to add the data again if the it's already there. The date is in mm-yy format and is in column A.

    I have no idea how to do this - but I figured if anyone would know, it would be someone on this board.

    I would appreciate your help with this.
    Thanks!

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Macro to append new row of data to existing file (2003)

    Are the dates in column A stored as dates (formatted mm-yy) or as text?

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Macro to append new row of data to existing file (2003)

    Could you attach a sample copy of the file to append and what your current XL file looks like (I suggest one sheet with the "before" and one sheet with the "after" so we can see what the macro should do).

    Steve

Posting Permissions

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