Results 1 to 3 of 3

Thread: formula question?

  1. #1

    formula question?



    Register for a FREE account, and/
    or Log in to avoid these ads!

    On a summary page I have cell range pulling data from cells a1:g20 in a sheet named SHEET1 and on that same summary page i need a another section to pull the data from the exact sames cells but on a different worksheet (SHEET2) and I need to do this over and over and over again. 150+ times. Can I create a formula that will do this and all I have to change is the sheet name?

    if it is using the indirect function, I do not understand how to use this to specify a worksheet and multiple cells.

    PLEASE PLEASE PLEASE HELP.

  2. #2
    I SHOULD EXPLAIN A LITTLE FURTHER. A portion of the data I need to copy over from each worksheet is text. (Our sales force is required to type in their daily activity)

  3. #3
    Wizard Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,615
    Articles
    0
    Excel Version
    2010 on Xubuntu

Posting Permissions

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