Counting number of cells and placing the value beside it

[Jack-P-Winner]

when I hot count 1, it ran but gave me a run time error. When I hit count 2 nothing happened? Am I doing something wrong?

 

[kchiba]

Please hold on, I am cleaning up the macro so that we can see it work,

 

[kchiba]

Hi Jack,

Here is the file, Note:

Calculation must be set to Automatic
Cells with Formulas must be copied, to match number of rows of data
Keep an eye on the bottom left corner of the screen, you will see the progress
Count 1, must be done before Count 2, it is a good idea to press F9 after doing Count 1
You will get a message when the run is completed

Here is the link, beware 10MB+
https://dl.dropboxusercontent.com/u/48309468/Side Numbers_Solution GOOD_Rev1.xlsm

Just want to say when everything is working OK, we can automate the process of copying the Formulas down.

enjoy

 

[kchiba]

Hey Jack,

Have managed to reduce by 8 columns, will revert tomorrow

kanti

 

[Jack-P-Winner]

Thanks bro. been a busy weekend/week, We own a cafe and ths time of year s crazy LOL, I will check this out this afternoon and report back

 

[kchiba]

Hi Jack,

Here is a link to the latest file, I have tested it and it looks OK.

https://dl.dropboxusercontent.com/u/48309468/Side Numbers_Solution GOOD_Macros.xlsm

cheers

kanti

 

[Jack-P-Winner]

Hey there Kanti, bare with me this week. We own a small cafe ad extremely busy catering parties for the holiday and my time has been very limited on the computer. I will check this out today and report back. THANK YOU SO MUCH!!!!!

 

[Jack-P-Winner]

This is wonderful. There are a couple things that need attention. Te 9's and 1's are done a little different and I have tried to explain this pic

The cosmetic stuff is the odd numbers are red font/yellow highlight, even is green font/gray highlight, the number that goes on the top of the 9's and 1's are Red. Having all this consistent helps tremendously in troubleshooting

 

[kchiba]

Hi Jack,

The cosmetics are easy, I think, however, the 9 and 1 issue is a bit more complicated, based on what you sent, the problem is when the 9 and 1 occur across different column sets and at the moment I have only provided to count one set, so I will re-think how we can achieve this.

I will load the file with the cosmetic changes later, unless you require it

cheers

kanti

 

[kchiba]

Hi Jack,

check this file it has the formatting and a new calculation for the 1's and 9's. Helper columns are back

https://dl.dropboxusercontent.com/u/48309468/Side Numbers_Solution GOOD_Macros_V2.xlsm

 

[Jack-P-Winner]

Hey there friend, I downloaded this file and loaded the rest of the files. I dragged the formula down but it is not working. What do I need to do to add all the rest of the counters? Here it is if you want to just use this and then it will already be loaded. This is what I use for now to look for the counters

https://www.dropbox.com/s/norcbtbze...ters (use oth to find filtered counters).xlsx

 

[kchiba]

Ok Jack, will look at it

 

[Jack-P-Winner]

Ok Jack, will look at it

Thanks, will have to figure out a way to get you a black bean burger

 

[kchiba]

Do not need the burger just the recipe, I make my own bread, pita bread, chick pea burgers and other stuff got into cooking this year, so the recipe for the burger would be great, but I am sure you will have secrecy issues

 

[Jack-P-Winner]

Hi Jack,

check this file it has the formatting and a new calculation for the 1's and 9's. Helper columns are back

https://dl.dropboxusercontent.com/u/48309468/Side Numbers_Solution GOOD_Macros_V2.xlsm

I should be able to just drag the Formica down and add more counters right?

 

[kchiba]

Hi Jack,

The attached file will do all the legwork, you have to copy your data onto the Calcs sheet starting in cell B5, then run the 3 macros on the Main page in sequence. Will upload file

 

[kchiba]

Hi Jack,
here is the file

 

[Jack-P-Winner]

Can't wait to check it out when I get home this evening. Thaanks Mate. Hey, where is home? Where do you live?