to adjust File 4n

Are the buttons in that worksheet the only ones that you need in Sheet1.

I need an actual list of the columns that you don't need.

¿Son los botones de esa hoja de trabajo los únicos que necesita en Sheet1?

Necesito una lista real de las columnas que no necesita.

just an minute please

Wait.

needed:

1-First Week
2-Next Week
3-Prev Week
4- Last Week
5-Go To Week
6-Summary
7-BYYEARS
8-4NPAIR
9-RNUM

also the ones shows

10-MIDWAY TOP
11-ONE COUNT TOP
12-PAIR TOP
13-TRIPLE TOP
14-PAIR
15-RANGE PAIR3
16-TRI PAIRS
17-MID PAIR
18-MID RANGE PAIR
19-TRIPLE MID
20-MID PAIR TOP
21-MID TRIPLE TOP

I see that on the torebuild worksheet you moved some of the columns. What I mean by that is that for example the MIDWAY TOP button in the real workbook started in column DB but in this workbook you show it in column AO. Based on that I assume that columns Z to AM are the only ones you don't need.

Veo que en la hoja de trabajo torebuild movió algunas de las columnas. Lo que quiero decir con eso es que, por ejemplo, el botón MIDWAY TOP en el libro de trabajo real comenzó en la columna DB, pero en este libro de trabajo lo muestra en la columna AO. En base a eso, supongo que las columnas Z a AM son las únicas que no necesita.

Columns Z to AM will have an data on
that the situation i was interest to talk about

but most likely counts columns

Columns Z to AM will have an data on

Is there any now?
Are they for future growth?

can you change the name of Sheet1 to 4NON

Is there any now?

Are they for future growth? 

well they will look the ORD by rows if they match to some values i have already them should show some number or format color to be true for the match

What does 4NON mean?

4Number On 

ON4N can be too

How about Just 4N or 4 Numbers or 4 Digits?

4N is great to me

I think this layout is better.

Me too !! but

but i need have the Number at original  
sorry it can't be like you shows

i worked the layout to be as more simple as possible

for you and me  

but have the data as needed

Surely the AM/PM should be next to the date.
The ORD is associated with the data
The green column has the counts of the ORDs

That makes perfect sense to me so why do you say "it can't be like you shows".

Seguramente el AM / PM debería estar al lado de la fecha.
El ORD está asociado con los datos
La columna verde tiene los recuentos de los ORD

Eso tiene mucho sentido para mí, así que ¿por qué dices "it can't be like you shows".

ok no problem can you improve it

I just discovered that the formulas in column J of the current workbook are wrong! For example the formula in cell J6 only counts the ORDs in rows 6 to 679. Given that they have been wrong for years it looks like you don't actually need those counts. Let me know if I can delete that column. In any case I've attached the first step in the conversion. Make sure that all the buttons work. Now is the time to make sure that you are happy with the way it looks since I will be making a lot of changes based on the new layout and I want to only have to do it once.

¡Acabo de descubrir que las fórmulas en la columna J del libro de trabajo actual son incorrectas! Por ejemplo, la fórmula en la celda J6 solo cuenta los ORD en las filas 6 a 679. Dado que se han equivocado durante años, parece que en realidad no necesita esos recuentos. Avísame si puedo eliminar esa columna. En cualquier caso he adjuntado el primer paso de la conversión. Asegúrese de que todos los botones funcionen. Ahora es el momento de asegurarse de que está satisfecho con la apariencia, ya que haré muchos cambios basados en el nuevo diseño y solo quiero tener que hacerlo una vez.cambios basados en el nuevo diseño y solo quiero tener que hacerlo una vez.
29223321.xlsb

column D can't be ORD


 Please i need the template as i did in file 4N_torebuild.xlsx 

because it will have all the columns a will use in the final file
 
use 4N_torebuild.xlsx  as you guide template 

column D and Column E have to be count columns

if you want  add each column and let me knows


im agree with the Time column as you you recommend

but all other columns have an purpose in the real estate

In my layout I forgot that you need both the "number" column and the ORD column and I will change that but column E (column J in 29223100a.xlsb and all previous workbooks have a problem. The formulas in years 2012 to 2017 show the counts per year. I don't know if that's what you wanted but after 2017 there aren't any formulas at all. So why do you need them?

En mi diseño, olvidé que necesita tanto la columna "número" como la columna ORD y cambiaré eso, pero la columna E (la columna J en 29223100a.xlsb y todos los libros de trabajo anteriores tienen un problema. Las fórmulas en los años 2012 a 2017 muestran el recuentos por año. No sé si eso es lo que querías, pero después de 2017 no hay fórmulas en absoluto. Entonces, ¿por qué las necesitas?

So why do you need them? 

Yes i need them

we have been working together for several years

Before working together I worked alone on the project for as many years

When we started I focused on doing things that I could not without your help but there are things that I have identified that are useful to me and that now I will have the opportunity to apply from scratch

Those columns were stopped showing but only because we were focused on certain areas that have taken a lot to improve.

but they are important that is why I made a template with specific columns and I need to follow it please

OK, how about this?

This the way needed

the Time column can be as you recommend

but all others i need as i did in file 4N_torebuild.xlsx   Please

Please use Google Translate to explain why.

Utilice el Traductor de Google para explicar el motivo.

???
I am open to suggestions

but

I identify that that is what I need

Okay I'm willing to do it your way.
In the following "Old" refers to workbook 29223100a.xlsb and "New" refers to workbook 4N_torebuild.xlsx.I have some questions and I also need you to tell me for all eight if anything I say is wrong and answer the question that I ask.

1. New D = Old F. The source for F is Old Q (When I say things like "New D" I mean "New column d")
2. New E = Combination of Old C, D and E. I don’t see the data for Old C, D and E in the new layout
3. New G =  Old Q
4. New I = Old S
5. New K =  Old AZ. Old AZ. Old AZ has a formula the references Old Q. Can you explain for example why old cell AZ32 is 11?
6. New M = Old BF
7. Do you care if I shift all the columns in the new layout one column to the left so that for example column ‘A’ will be the date?
8. Do you care if I eliminate some of the small separator columns like F, H J and ‘I’ in the new layout?

Está bien, estoy dispuesto a hacerlo a tu manera.
En el siguiente, "Antiguo" se refiere al libro de trabajo 29223100a.xlsb y "Nuevo" se refiere al libro de trabajo 4N_torebuild.xlsx. Tengo algunas preguntas y también necesito que me digas de los ocho si algo de lo que digo es incorrecto y que respondas a la pregunta que pedir.

1. New D = Old F. La fuente de F es Old Q (cuando digo cosas como "New D" me refiero a "New column d")
2. Nueva E = Combinación de Old C, D y E. No veo los datos de Old C, D y E en el nuevo diseño
3. Nuevo G = Antiguo Q
4. Nuevo I = Antiguo S
5. Nuevo K = Antiguo AZ. Viejo AZ. Old AZ tiene una fórmula con las referencias Old P. ¿Puede explicar, por ejemplo, por qué la celda antigua AZ32 es 11?
6. Nuevo M = Viejo BF
7. ¿Le importa si cambio todas las columnas del nuevo diseño una columna a la izquierda para que, por ejemplo, la columna "A" sea la fecha?
8. ¿Le importa si elimino algunas de las columnas separadoras pequeñas como F, H J e "I" en el nuevo diseño?

1- New D = Old F

2- New E = Old J

3- New G = Old Q

4- New I = Old S

5- New K = Old AZ this formula just shows the 1 or 0 or both when is in the  ORD  (in the old workbook  it pickup this from AZ but i ajust it to the ORD column in the NEW book)

6-New M = old BF

7-  Do you care if I shift all the columns in the new layout one column to the left so that for example column ‘A’ will be the date?


No. Please stay with the columns as i did

i prepare the template as i need it . Please do not use column A


8- Do you care if I eliminate some of the small separator columns like F, H J and ‘I’ in the new layout?

Please do not elimante F,H, J and I

In this workbook I've done the left size of the new layout. Please make sure that the buttons work properly and that columns D, E and K have the correct values and formatting and that everything so far is the way you want it.

En este libro de trabajo, hice el tamaño izquierdo del nuevo diseño. Asegúrese de que los botones funcionen correctamente y de que las columnas D, E y K tengan los valores y el formato correctos y de que todo hasta ahora esté como lo desea.
29223321.xlsb

For each column from 'O' to Y  in the new layout please tell me the Sheet1 source column.
Where does MIDWAY TOP come from?

Para cada columna de 'O' a Y en el nuevo diseño, dígame la columna de origen de la Sheet1.
¿De dónde viene MIDWAY TOP?

ok to explian O i need talk first of columns Q, S,T,U,W

1-Column Q will detect any double digit in any ORD

i means 4431 = an Double because it have 44 two times

so column Q identify it and when is tru i format Blue color as you have seen it

2-columns S T U W  do  an serach for repeat numbres in the same week and others weeks

when is true it formar an PINK red Color as ypou have seen it

Where does MIDWAY TOP come from?

MID way Top count each digit for the half of the week (wednesday)

and shows the count but until WEDNESDAY each digit count 

Thank you for the explanation, but I wasn't asking how they work. Instead I was asking what the old columns were. So just as you told me that New D = Old F and  New E = Old J and New G = Old Q, I need to know what New O, P and Q, etcetera in the Old layout sre.

Gracias por la explicación, pero no preguntaba cómo funcionan. En cambio, preguntaba qué eran las columnas antiguas. Así como me dijiste que New D = Old F y New E = Old J y New G = Old Q, necesito saber qué New O, P y Q, etcétera, en el diseño de Old.

1- New O = OLD BI

2- NEW P = BLANK

3- New Q = OLD BQ

4- New R = BLANK

5- New S = OLD BK

6- New T = OLD  BL

7- New U =   OLD BM

8- New V = BLANK

9- New W = OLD BO

10- New X= BLANK

11- Column Y = OLD CZ

i have one situation
can you please help me with !!
I take advantage that we are talking about MIDWAY TOP

when i talk about MIDWAY TOP

i will need create an BYSET sheet  and an Selector sheet  for

the same apply for or others buttons

like

ONE TOP COUNT

PAIR TOP

TRI TOP  

MID PAIR TOP

MID TRI TOP

I'm sorry Adriana but I have to give up on trying to give you the new layout. I've tried every trick I can think of but because I temporarily need to have two copies of Sheet1 in the workbook: the old one to copy from and the new one to copy to,  the workbook has bcome too large for my Excel to handle and it keeps on crashing.

Lo siento Adriana, pero tengo que dejar de intentar darte el nuevo diseño. Probé todos los trucos que se me ocurrieron, pero debido a que temporalmente necesito tener dos copias de Sheet1 en el libro de trabajo: la antigua para copiar y la nueva para copiar, el libro de trabajo se ha vuelto demasiado grande para que mi Excel lo pueda manejar. y sigue chocando.

no problem we did our best

great opportunities require great sacrifices
sometimes we have good luck and we can go for that dream at other times we can only know that it is there but it is not in our reach

I am forever determined by all attempts to achieve a goal

Waoooooooo!!!!!!!

You always surprise me !!

You are the Greatest of the Greats
may God bless you with long life and good health forever

Love Peace and Good !!

Thanks. As you can tell I hate to give up.

The qualities of a Special Being with God in his Heart and Mind
  cause there to only be conquests
Only the Great Think Big
  They are channel of the Divine
like you ....