Results 1 to 5 of 5

Macro Copy & Paste data from 6 sheets to 1 new one

Threaded View

eMeLI Macro Copy & Paste data from... 10-19-2011, 07:08 AM
JBeaucaire Re: Macro Copy & Paste data... 10-19-2011, 07:14 AM
eMeLI Re: Macro Copy & Paste data... 10-19-2011, 07:19 AM
JBeaucaire Re: Macro Copy & Paste data... 10-19-2011, 07:32 AM
eMeLI Re: Macro Copy & Paste data... 10-19-2011, 07:52 AM
  1. #1
    Registered User
    Join Date
    10-19-2011
    Location
    Amsterdam, Holland
    MS-Off Ver
    Excel 2007
    Posts
    6

    Cool Macro Copy & Paste data from 6 sheets to 1 new one

    Every month 6 sheets get updated (new information is put in and old is automaticallty deleted) and I need to get the information out of the sheets to one new sheet.

    The sheets are called Start(2), Start(3).....Start(7). In every sheet there is a header row which I don't need copied to the new sheet called "Results". The new sheet already has a header row in it.

    So I need the data from Start(2) in Results and then I need the macro to find the next empty row and paste the information from Start(3) there, and so on....

    I'm quite a noob at macro's so i've been doing everything with record macro, but i can't get this to work. In contrary to what it says in my details i use excel 2007 :D

    Hope someone can help me here!!!

    Thanks in advance.
    Last edited by eMeLI; 10-19-2011 at 07:52 AM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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