Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Macro Help
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. |
#2
|
|||
|
|||
Hi,
Trying to visulaize your workbook.... In the monthly worksheet in cell C11 you have a total of cells O5 and O24 from Day1. In C12 you want to put the total of O5 and O24 from day day two whne you run the macro. If so, this code should work. Option Explicit Sub InsertTotal() Dim CountRows As Integer Worksheets("Monthly").Activate CountRows = Range("C65536").End(xlUp).Row Cells(CountRows + 1, 3) = Sheets("Daily Sheet").Range("O5") + Sheets("Daily Sheet").Range("O24") Worksheets("Daily Sheet").Activate End Sub "DME" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Playing a macro from another workbook | Excel Discussion (Misc queries) | |||
Date macro | Excel Discussion (Misc queries) | |||
Macro and If Statement | Excel Discussion (Misc queries) | |||
Macro Formula revision? | Excel Worksheet Functions | |||
Macro for multiple charts | Excel Worksheet Functions |