+ Reply to Thread
Results 1 to 2 of 2

pasting together chunks of data sequentially

Hybrid View

m121212 pasting together chunks of... 10-13-2010, 01:59 PM
foxguy Re: pasting together chunks... 10-14-2010, 03:11 PM
  1. #1
    Registered User
    Join Date
    10-13-2010
    Location
    Washington
    MS-Off Ver
    Excel 2007
    Posts
    2

    Question pasting together chunks of data sequentially

    Hi Forum,

    I have a large amount of data that I would like to cut chunks out of and paste together in another worksheet.

    The header for the data looks like this:

    year month day minute temperature

    and the data ranges from 4/2008 to 10/2010.

    In another table, I have a list of months that I'd like to piece together in order:
    month year
    1 2010
    2 2009
    3 2010
    4 2010
    5 2008
    ...
    12 2009

    My goal is to make a full year of data, where the January comes from the 2010 January data of the main dataset, the February from the 2009 February, and so on, according to my list.

    I could do it by hand, but I would like to automate it because I have to do it many times over with different lists.

    My first question is whether I should use a VBA sub or not. If I should, I'm not sure where to start. I would be grateful for any recommendations.

    Thanks!
    Mary

  2. #2
    Forum Expert
    Join Date
    03-31-2009
    Location
    Barstow, Ca
    MS-Off Ver
    Excel 2002 & 2007
    Posts
    2,164

    Re: pasting together chunks of data sequentially

    Hi Mary;

    Yes you would probably want to do it in a macro. It may be possible to do it with functions, but they would be very complicated functions.

    You should provide a sample workbook with before & after sheets so someone doesn't spend a lot of time trying to figure out what it should look like.
    Foxguy

    Remember to mark your questions [Solved] and rate the answer(s)
    Forum Rules are Here

+ Reply to Thread

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