Welcome Guest
Log In | Register )
You last visited December 8, 2016, 6:54 pm
All times shown are
Eastern Time (GMT-5:00)

Excel Help Please...

Topic closed. 4 replies. Last post 11 years ago by Bryan.

Page 1 of 1
PrintE-mailLink
Bryan's avatar - Lottery-002.jpg
Mid-Missouri
United States
Member #644
August 31, 2002
4271 Posts
Offline
Posted: May 25, 2006, 8:06 pm - IP Logged

Howdy All,

First, let me say, I am totally lost when it comes to working with Excel but I am trying. Anyway, the question is, I have some info on page one of a workout I am trying to come up with and I want the same info to be sent to page two of the worksheet but in a different area. How do I get the same info to automatically go where I want it on page two once I have entered it on page one?

Any and all help is appreciated,

Thank You,

Bryan  :)

    TheGameGrl's avatar - character catafly.jpg
    A long and winding road
    United States
    Member #17084
    June 10, 2005
    4528 Posts
    Online
    Posted: May 25, 2006, 9:06 pm - IP Logged

    Use Google and Type in :Excel formulas- what you are seeking to do based upon your post is to link the two pages with the information from the original sheet. You'll need to create a formula from the first sheet . One site that may be of interest is: http://www.ozgrid.com/Excel/

    Keep in mind that the version of excel will also play apart in how to configure your sheets.

    ~~Is it true, Is it kind,Is it necessary. ~~~

     Thanks be to the giving numbers: 1621,912,119 02014

      SirMetro's avatar - center
      East of Atlanta
      United States
      Member #6191
      August 11, 2004
      1389 Posts
      Offline
      Posted: May 25, 2006, 9:37 pm - IP Logged

      The simple answer is this,

      on the Second page where you want the data to appear, Select the desired CELL

      Then press the = (equal sign)

      Next, select the Tab of the first sheet that has the data. Then simply select the data.

      Finally, either press the ENTER key or click the Check mark to indicate you are complete.

      One really cool note, the Display page can format and size the text differently then the original sheet, allowing you to add emphasis as you need it.

      Hope this helps.

      Open minds leads to some really incredible ideas.

      Sir Metro

        Bryan's avatar - Lottery-002.jpg
        Mid-Missouri
        United States
        Member #644
        August 31, 2002
        4271 Posts
        Offline
        Posted: May 25, 2006, 10:53 pm - IP Logged

        Thank you both for the info I will look it up.

        SirMetro, I tried your suggestion and when I do that the cell on the second page says "=sheet1!A31" which is the cell I want to connect to on the first page but does not fill in the info from the first sheet. it just displays the link that I made. "=sheet1!A31".

        Does it matter that the cell I am connecting to has a formula in it? It's not just text.

        Thanks,

        Bryan  :)

          Bryan's avatar - Lottery-002.jpg
          Mid-Missouri
          United States
          Member #644
          August 31, 2002
          4271 Posts
          Offline
          Posted: May 26, 2006, 5:27 am - IP Logged

          Thank you all,

          I think I have it working now. I played with the formatting of cells and it seems to be giving me what I want.

          Thanks again,

          Bryan  :)