+ Reply to Thread
Results 1 to 6 of 6

move data from multiple worksheets to single sheet whithout manually entering each cell id

  1. #1
    Registered User
    Join Date
    02-05-2014
    Location
    NY
    MS-Off Ver
    Excel 2010
    Posts
    3

    move data from multiple worksheets to single sheet whithout manually entering each cell id

    I have a number of worksheets and need to move data from the same cells of each work sheet to a summary worksheet. I manually entered the cell id's for the first sheet.
    example =Jan!M6, =Jan!N7, =Jan!O9 etc. I know I should be able to automatically enter these same cells for the remainder of my worksheets with out mannualy going in and typing each one (there are a lot of entries.) But for the life of me I just can not remember how to do it. The next sheet is named "Feb" and "Mar" etc.

    Can anyone point me in the right direction before I start typing????

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: move data from multiple worksheets to single sheet whithout manually entering each cel

    Indirect function can work.
    http://office.microsoft.com/en-us/ex...005209139.aspx
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

  3. #3
    Registered User
    Join Date
    02-05-2014
    Location
    NY
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: move data from multiple worksheets to single sheet whithout manually entering each cel

    Hi
    ,I do not think I explained my self. I am attaching the test workbook (I hope- first try). I need the Jan references in the totals sheet to be duplicated for all the other months. I know I can type and go thru and replace etc but I also know there has to be a better and more professional way to do it! thank you in advance.
    Attached Files Attached Files

  4. #4
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: move data from multiple worksheets to single sheet whithout manually entering each cel

    So I used the indirect formula and 3D referencing so that should be pretty easy to understand but if you have any questions let me know.

    Also note, that I had to change the name of APRIL tab to APR to maintain the same formula across everything.

    Updated Indirect and 3D References.xlsm

  5. #5
    Registered User
    Join Date
    02-05-2014
    Location
    NY
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: move data from multiple worksheets to single sheet whithout manually entering each cel

    Wow, Thank you. I think I understand it. I have been reading about the indirect function but I need to do some more reading on it. I really appreciate your help.
    Joan

  6. #6
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: move data from multiple worksheets to single sheet whithout manually entering each cel

    Feel free to mark this thread as solved and let me know if you have any other questions.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Pull data if there is any from a single column in multiple worksheets into a single sheet
    By bcas77 in forum Excel Programming / VBA / Macros
    Replies: 29
    Last Post: 07-11-2013, 01:22 PM
  2. [SOLVED] Move data from row to cell, but single cel to multiple cell.
    By puckaveli in forum Excel General
    Replies: 2
    Last Post: 11-20-2012, 08:51 AM
  3. How to copy data from multiple worksheets in excel into a single sheet
    By abhijit saha in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-03-2012, 02:09 PM
  4. Replies: 3
    Last Post: 03-24-2012, 08:18 PM
  5. Entering Multiple Formulas for a single cell
    By modest_16081982 in forum Excel General
    Replies: 2
    Last Post: 07-30-2007, 09:58 PM

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