DME,

The R[-6] means that the affected cell is 6 rows above the
active cell. So when you run it from row 11 you get row 5.
When you run it from row 12 you get row 6.
Change -6 to -7 and try it.

Jim Cone
San Francisco, USA



"DME" <craigjoseathotmaildotcom wrote in message
...
I have a sheet that is updated on a daily basis, a template of sorts. Each
day the user inputs the prior days information into the "Daily Sheet". I
then have to manually go into my "Monthly" total spreadsheet and input the
numbers from the daily sheet. Thus producing a Month To Date total.

Now I am sure there is a better way to update my "Monthly" spreadsheet
without manually inputting them each day. I have tried setting up a Command
Button that activates a macro that would go to the Daily spreadsheet and
grab the numbers I need to have. The numbers in the "Daily" sheet are the
same cells everytime. For instance Cells O5 AND O24 in thh Daily Supply
spreadsheet. Here is my problem. I have the following code:

ActiveCell.FormulaR1C1 = "='Daily Supply'!R[-6]C[12]+'Daily
Supply'!R[13]C[12]"
ActiveCell.Offset(1, 0).Range("A1").Select

I created this Macro from cell C11 in the "Monthly" spreadsheet. It works
fine in that cell, but when I run it from cell C12, it pulls the information
from Cell O6 and O25 in the "Daily" Spreadsheet. I have tried relative
reference when recording the Macro and have tried it without and neither one
seems to work for me.

Can someone please tell me what I am doing wrong?

Or if there is an easier way to perform the task I am trying to accomplish
using another means besides a Macro and command button.