• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

My Boss with no brain and future needs MS Excel to...

A

Atomicus

Banned
act as a tally sheet? Lets say I have Client X and when he comes in, we put the number 1 on him for using our services. The second time he comes in, the natural thing to do is replace the 1 with a 2. However, my boss wants it to be like a tally sheet so you have the option of rewriting the data or just pressing a button to add a number... IS HE CRAZY??? :|
 
So you just want a button for each person and when you click it, it looks at the cell and adds one to the number? Shouldn't be too hard for a simple macro..
 
you could just use a SUM function. each time client X comes in he puts a 1 in a new row. just have the function add up all the numbers.

or he could put in the date or time and have excel just count the number of non-blank fields.
 
Originally posted by: loki8481
you could just use a SUM function. each time client X comes in he puts a 1 in a new row. just have the function add up all the numbers.
or he could put in the date or time and have excel just count the number of non-blank fields.
Click to expand...

That is crazy! lol I'll have rows longer than the total length of all dreadlocks in the world!


I think I'll listen to the macros and go with a macro that does +1 to the selected cell 😱
 
I'm not sure if you're just basxhing your boss for being an idiot (which it sounds like he is), but if I were going to do it, the easiest way would be to give everyone a customer number and just enter them all in column A. Then in column C, make a list of all the customer numbers (for my example, I'll assume we start at "x"). The in column D, write:

=COUNTIF($A$1:$A$60000,C1)

Then just copy that formula down through all customer numbers and type their number in coumn A.
 
Hi Atomicus:

Good luck finding another job. Don't let the door hit you in the ass on the way out.

Sincerely,

Your Boss


😛
 
Originally posted by: Encryptic
Hi Atomicus:

Good luck finding another job. Don't let the door hit you in the ass on the way out.

Sincerely,

Your Boss


😛
Click to expand...

So you have no brain or future? How does that feel? 😛
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top