Results 1 to 20 of 21

Thread: Copy data from Multiple to SINGLE worksheet.

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #19
    VBAX Tutor david000's Avatar
    Joined
    Mar 2007
    Location
    Chicago
    Posts
    276
    Location
    The last row saved on running the macro is same as HEADER row in MASTER. Can we fix that? See attached file. We do not want to repeat the HEADER row at the bottom again.
    You have a sheet named "Unknown" on that sheet you have no data in column "A" - as a result, it's causing the first row to be copied over do to the nature of the code. Put some data in that column and it will work.

    In your situation column A is mandatory!
    Last edited by david000; 06-17-2008 at 07:07 AM.

Posting Permissions

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