another apple challenged male

Q: Copy part column from 2 sheets to find different averages

In numbers I am trying to copy a part column of figures to join with other part columns in a new sheet or table for averages required. No matter how I copy the result is just a a column of zero's. I followed directions on help for copying with the same result.

Mac mini, OS X El Capitan (10.11.6)

Posted on Aug 18, 2016 8:26 PM

Close

Q: Copy part column from 2 sheets to find different averages

  • All replies
  • Helpful answers

  • by Yellowbox,Helpful

    Yellowbox Yellowbox Aug 23, 2016 3:58 PM in response to another apple challenged male
    Level 6 (10,435 points)
    Mac OS X
    Aug 23, 2016 3:58 PM in response to another apple challenged male

    Hi apple challenged male,

    No matter how I copy the result is just a a column of zero's.

    More information will lead to a solution .

    What is your overall aim?

    What copy methods have you tried?

    What formulas produced the results?

    Any error messages?

    A screen shot will paint a thousand words .

     

    Regards,

    Ian.

  • by another apple challenged male,

    another apple challenged male another apple challenged male Aug 23, 2016 4:57 PM in response to Yellowbox
    Level 1 (8 points)
    iWork
    Aug 23, 2016 4:57 PM in response to Yellowbox

    Thanks Ian,

    I keep all  my financials in a file which is broken up in to months (a month on a sheet each) and automatically carry the figures forward and use functions to calculate the balances. I have recently been advised by my bank that charges are calculated on the 7th of each month and require a minimum average balance for the month on that date. I had always assumed it was based on the actual month. As I have various accounts I decided to keep track by setting up a sheet or file that kept track to ensure I stayed within their limits. With the intention of working out what was needed, I went to first copy the first months figures from the 8th to add to the following month up to the 7th and average the daily balance.  I do have functions in the column I wish to work with and wondered if that was my problem.

     

    I tried first through the edit tool, I recall I then tried all the ctrl, option and command keys with "C" Each time the result was a column of $0.00's. in new files. If it was within the same file it copied but also carried the functions with it. I have now found how to get the values copied within the file.

     

    I now want to find out how to have those values automatically imported each month in a column to enable averaging. I will be trying to find the answer myself also, but if you know a simple method I will be happy to hear it.

     

    I am sorry about no screen shot, I have not found out how to do that yet.

    I hope I  have made sense you, most of what I read on help and other instructions is like double dutch to me, so possibly the converse also applies.

    Many thanks for your time and help,

    Roger

  • by t quinn,Helpful

    t quinn t quinn Aug 23, 2016 9:47 PM in response to another apple challenged male
    Level 5 (4,995 points)
    Mac OS X
    Aug 23, 2016 9:47 PM in response to another apple challenged male

    Hi a c m,

     

    Try going to  Menu>Edit>Paste Formula Results.

    This should get your values moved. You will have to copy formulas separately.

     

    As far as importing bank data into your tables you should ask a new question with the particulars as to what format the bank data is in and how you want to move it.

     

    quinn

  • by Yellowbox,

    Yellowbox Yellowbox Aug 24, 2016 1:31 AM in response to another apple challenged male
    Level 6 (10,435 points)
    Mac OS X
    Aug 24, 2016 1:31 AM in response to another apple challenged male

    Hi Roger,

    I think you are pasting formulas to a new sheet that has blank cells where the formulas are looking. A blank cell is interpreted as zero. Quinn's solution to Paste Formula Results will work.

    See this User Tip by Wayne on how to post a screen shot.

     

    How to Post a screenshot to the Apple Discussion Forums


    Regards,

    Ian.