Daily Task Workbook - Running Totals

[marteb]

Hi,

I am trying to figure out a way to keep running totals of my daily tasks to replace my current paper records. I am testing a workbook I setup, but the process seems cumbersome (I started in IT as a data entry clerk and dislike using my mouse). Here is a small sample of my data as it currently exists.

Type Add Change Delete Adds Chgs Deletes
Web Access lllll llll lll 5 4 3
ERP Access llll ll lllll 4 2 5
Group Member llll ll 4 0 2
Email Group l 1 0 0
Password Call llll 4 0 0
Password Reset llll 4 0 0

Current process; Select the appropriate cell in the workbook, click at end of formula bar, enter appropriate number of lowercase l, repeat with next item.

Is there anyway in Excel to setup an input form or something that would add the current day's totals to field or cell with the previous data? If not, is this something that could be done in Access?

Thanks in advance, Marteb

 

[marteb]

Cleaned up data, sorry

Excel 2012
	A	B	C	D	E	F	G
1	Type	Add	Change	Remove	Adds	Chgs	Deletes
2	Web Access	11111	1111	111	5	4	3
3	ERP Access	1111	11	11111	4	2	5
4	Group Member	1111		11	4	0	2
5	Email Group	1			1	0	0
6	Password Call	1111			4	0	0
7	Password Reset	1111			4	0	0
Sheet1

 

[Roderick_E]

Hi, at the time I'm responding, over 12 people have looked at your question but it makes little sense. Maybe if you could explain it a bit more. I especially don't understand the lines |||| thanks

 

[Roderick_E]

Ah ok you re-posted. If you're going to use a 1 as a tick, you could put this formula in your total columns:

=LEN(G16)-LEN(SUBSTITUTE(G16,"1",""))

Change G16 to the cells where you are inputting the 1 ticks

 

[marteb]

Hi Roderick_E,

Thanks for getting back to me. I am using =LEN to get the totals and it is working.

Let me explain this better: I click in cell B2 to add my 'ticks' for today, B2 already contains 5 ticks from previous entries. If i simply click in B2 and add two ticks for today, I wipe out the previous 5 and my total is 2. I have to click in the formula bar and add 2 ticks at the end to avoid losing the existing data. I capture and report on this information on a yearly basis.

Question:
Is there anyway in Excel to set this up so I can add the current day's 'ticks' without wiping out the existing data? If not, is this something that could be done in Access?

Thanks, Marteb

 

[Roderick_E]

Ahhh this doesn't require a fancy vba...just press F2 and the cursor will be at the end of current text.

 

[marteb]

Great, thanks! I'm glad this is an easy fix! Appreciate the help. Marteb