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

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