Closed Thread
Results 1 to 2 of 2

Moving/Copying same cells to a master sheet.

  1. #1
    Registered User
    Join Date
    09-01-2010
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2007
    Posts
    2

    Moving/Copying same cells to a master sheet.

    Hello everyone,

    I am using Excel for data-mining a simulation I recently created that documents 6 points of information for every hour of a day. The problem is that the 6 data points for each hour are placed on a separate sheet. This wouldn't be a problem if I only had to copy one day's worth of data (6 cells from 24 sheets), but when I have a year (8760 sheets) it becomes not even close to worth the time. I am wondering if there is a command that will let me move a certain set of says (for example: A7 - F7) to a master sheet (obviously each sheet's data will be on a separate row on the master sheet). Is there an easy way to do this at once?
    Is it possible that this would require some VBA coding?

    Any help is appreciated,

    Matt

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Moving/Copying same cells to a master sheet.

    Duplicate post, thread closed.

    Please take a few minutes to read the forum rules before posting again.

    Thanks.
    Entia non sunt multiplicanda sine necessitate

Closed Thread

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