Welcome Guest
Log In | Register )
You last visited January 17, 2017, 5:54 am
All times shown are
Eastern Time (GMT-5:00)

Why would my excel formulas

Topic closed. 5 replies. Last post 11 years ago by hypersoniq.

Page 1 of 1
PrintE-mailLink
lottaloot's avatar - AvatarZ56
Redford/MI
United States
Member #3396
January 18, 2004
4867 Posts
Offline
Posted: December 30, 2005, 8:30 pm - IP Logged

keep changing when I insert copied cells from 1 spreadsheet to another??

I have placed made my formulas absolute as well as relative??

Maybe I am confused again & they should be relative. 

I don't know..

L ttaL   T

    hypersoniq's avatar - 8ball
    Pennsylvania
    United States
    Member #1340
    April 6, 2003
    2450 Posts
    Offline
    Posted: December 30, 2005, 8:39 pm - IP Logged

    do you have more detail?

    it sounds as if you are using "insert copied cells"? if so, just use Paste, that will not mess with the addressing

    Playing more than one ticket per game is betting against yourself.

      lottaloot's avatar - AvatarZ56
      Redford/MI
      United States
      Member #3396
      January 18, 2004
      4867 Posts
      Offline
      Posted: December 30, 2005, 8:46 pm - IP Logged

      I was trying to avoid all the row insertions, but I guess I will just have to go back to the way I was doing it previously. 

      Thanks Hyper

      L ttaL   T

        hypersoniq's avatar - 8ball
        Pennsylvania
        United States
        Member #1340
        April 6, 2003
        2450 Posts
        Offline
        Posted: December 30, 2005, 8:48 pm - IP Logged

        Are you trying to add data to a sheet that was done for another state? or merge evening and mid-day draws?

        relative and absolute addresses will autofill down nicely

        Playing more than one ticket per game is betting against yourself.

          lottaloot's avatar - AvatarZ56
          Redford/MI
          United States
          Member #3396
          January 18, 2004
          4867 Posts
          Offline
          Posted: December 30, 2005, 9:00 pm - IP Logged

          Neither.  Too difficult to explain. 

          Will just do what I was doing before. 

          Thanks Hyper

          L ttaL   T

            hypersoniq's avatar - 8ball
            Pennsylvania
            United States
            Member #1340
            April 6, 2003
            2450 Posts
            Offline
            Posted: December 30, 2005, 9:17 pm - IP Logged

            ok, good luck :-)

            Playing more than one ticket per game is betting against yourself.