Results 1 to 9 of 9

Macro to Append Data

Threaded View

  1. #1
    Registered User
    Join Date
    11-24-2010
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    3

    Macro to Append Data

    In need of macro that will do the following:

    (1) Copy data from Book1.Worksheet1 in range a1:j2
    (2) Paste values into Book2.Worksheet1 in range a1:j2

    The values in (1) refresh periodically. When they do, I'd like to be able to hit the macro button proceed to (2) again, but this time the data will append to the bottom.

    Thanks in advance for the help.
    Last edited by ExcelQ1; 12-01-2010 at 05:36 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1