ADRIANA P
asked on
need counting specific data on sheet
It's not clear why you can't just use SUM. A bit more explanation please
ASKER
well is a little more easy add by programming because the data need to be up from the horizontal way first
Can you attach an example showing what the results will be
That's a picture, a workbook is what's needed
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Adriana, it would be extremely useful if you are posting follow up question to post links to the previous one.
ASKER
Martin the color show make more clear to see the numbers because they a lot in the view
so make more easy
so make more easy
ASKER
Grea Job !!
ASKER
Roy_Cox thnks for you help good friend !
Martin the color show make more clear to see the numbers because they a lot in the viewOk, if you need them, I'm willing to modify the code to add them, but to do so I'll need to understand why they have the colors they do. In other words tell me something like cell G17 is green because....
so make more easy
Ok, si los necesita, estoy dispuesto a modificar el código para agregarlos, pero para hacerlo necesitaré entender por qué tienen los colores que hacen. En otras palabras, dígame algo como la celda G17 es verde porque ....
ASKER
Martin Great Job !
not special purpose in juts it make more easy the view !
not special purpose in juts it make more easy the view !
I want to make it easy. Tell me why the cell is green and I'll make it green.
Quiero que sea fácil. Dime por qué la celda es verde y lo haré verde.
Quiero que sea fácil. Dime por qué la celda es verde y lo haré verde.
ASKER
Martin it not special purpose in
but i need help with others question i hope you can help me !!
but i need help with others question i hope you can help me !!
Here's an update that adds the teal (trullo azul) color.
29019372a.xlsm
29019372a.xlsm
ASKER
Martin ! Great Job !
ASKER
Is a lot of code i know is not easy !
TO MAKE IT HAPPENS !
that the reason a recomend to used the SELECT TO COUNTING sheet
so you have it summarize for esay work in
TO MAKE IT HAPPENS !
that the reason a recomend to used the SELECT TO COUNTING sheet
so you have it summarize for esay work in
Actually, the SELECT TO COUNTING sheet doesn't help at all. It is just a copy of the ORD columns from the "PREWVIEW" sheet, and so the only difference in the code would be the name of the sheet where the columns are (and different column letters).
En realidad, la hoja SELECT TO COUNTING no ayuda en absoluto. Es sólo una copia de las columnas ORD de la hoja "PREWVIEW", por lo que la única diferencia en el código sería el nombre de la hoja donde se encuentran las columnas (y las diferentes letras de columna).
En realidad, la hoja SELECT TO COUNTING no ayuda en absoluto. Es sólo una copia de las columnas ORD de la hoja "PREWVIEW", por lo que la única diferencia en el código sería el nombre de la hoja donde se encuentran las columnas (y las diferentes letras de columna).
New version with full color formatting!
Changes include:
One last question. Why is cell B26 in your RESULTS COUNTING sheet purple. It's not conditional formatting.
29019372b.xlsm
Changes include:
- Corrected a problem with the MID column
- Formatted all cells in the 1W, 2W and ALL columns to be 2 digits. In other words "1" will be "01"
- Changed the way the teal color is produced. It now uses conditional formatting where perviously it didn't
- Added conditional formatting for the blue cells
- Added a sheet named "CF" which lets me to the conditional formatting
One last question. Why is cell B26 in your RESULTS COUNTING sheet purple. It's not conditional formatting.
29019372b.xlsm
ASKER
Great work very admirable
You are one of the great experts of all time
You are one of the great experts of all time
ASKER
Very responsible and reliable
Fixed.
29019372e.xlsm
29019372e.xlsm
ASKER
MEGA GREAT ! JOB !
ASKER
I LIKE IT !!
ASKER
books5.xlsx