 ExcelExperts.comExcel Consultancy, VBA Consultancy, Training and Tips Call:+442081234832 |
|
Excel / VBA ConsultancyFree Training VideosFree SpreadsheetsExcel / VBA JobsNavigationWho's onlineThere are currently 0 users and 272 guests online.
New Excel Experts
Current Excel / VBA Jobs |
Running TotalThis may seem a silly question but how do you get a running total to work form one Work Sheet to another from a daily list to a monthly list, this =DailyBirdList!$B$3 updates the monthly list but will not keep a running total, I have tried lots of way but it will not work.
|
Highest Ranked Users
Recent Blogs
ForumsRecent comments
User login |
Running Total
Hello MJS,
To me it sounds a bit criptical. Can you upload a spreadsheet with the structure you want.
How does you're update work. Is it in VBA or manually.
JPH
update
I have change it so it works from one workbook now. I am trying to get sheet1 to reset it self each day that is all enters return to zero and then I would like it to update sheet2 but at the moment it just displays the number you put in. Or is to much for Excel, I am new to excel so just filling my way round.
Use VBa
You could try to use the macro editor for excel ( Visual basic ). This is where you can ad functions like the one you would like to use. don't be scared just try it.
Help with VBa
I have got this code to work OK but how do you get it to work on more than one cell
EG: from cell B3 to B20 and then display the results in D3 to D20 if you put a 1 into B3 returns a 1 into D3 and so on.
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address <> "$B$3" Then Exit Sub
[d3] = [d3] + [b3]
End Sub
Button and VBa code
I've made some changes to your sheet.
Added some names, a button and some code.
The only thing is i don't now how to add this sheet to this topic.
I've opened another topic and added the changed sheet to that one.
Download
Download DailyBirdList-JPH.xls
I forgot to tell that the numbers entered are automatically placed in the current month.
In code it says to take "month(now())" if you want to change this, you can do it there.
thanks
Thank you JBH that what I have been trying to do for some time I am so new to this I am starting to see how this works with THANKS again....
How do you add extra cells to
How do you add extra cells to this code, b21 I have tried and can't get it to work.
adding cells to a named range
There are two things to consider.
1. If you add one or more cells in the DailyList you must enter the same amount to the months list (second sheet).
2. The code works with the named ranges. If you add a cell below the bottom cell of the range it wil not expand the named range.
To expand the named range you have to insert between two existing cells in the range.
Thanks
Thanks JPH that is one thing i did not try.