I would like to keep a current total on a spreadsheet that needs to be updated on a daily basis. Right now I use some vba which saves the file as the date, adds the cells that need to be added for the "running total", clears out the contents then resaves as the original file. This doesnt work for what i want to do because when i go back and edit a previous day it does not update my current total. So re-thinking the problem I figure the best way to go about this is copy the range of inputed numbers to a new hidden sheet. the top cells meaning a1 b1 c1 and so on will be used for storing date then the corrisponding collum will be used for storing the information. What I need to know how to do is how can i use a form to input a date, then it selects the collum that matches the forms inputed and copys that collums information back to the input cells. I dont know if that makes sense.. its pretty early and im pretty tired
an example of how the collums should look
collum 1
1/1/05
1500.00
2000.00
12.45
collum 2
1/2/05
1200.00
13.00
45.20
and so on..
Once I figure this out I will then need to find a way to add all the previous information meaning 1/2/05's stuff plus 1/1/05 stuff. or if its 1/1/05 then it would be all the days previous 12/31/04 + 12/30/04 and so on. Anyway... Any help would be awesome because Ive been banging my head on a wall trying to figure access out.
Thanks
Chris
Ps. The main question here Is not how to copy cells.. its how to refrence a collum by date using an input from a form then adding all collums prior to that date.
Bookmarks