Avatar of ADRIANA P
ADRIANA P
Flag for United States of America asked on

2N in the same column same digit

2N to in the same column same digit

29230009.xlsm


1- identify digits:   IN SAME COLUMN  ( Column J ) and Same (Column K)

A-that are the same
B- or have one up
C-  or have one down 


2- in column J  (only)  identify the same number follow or the 1up or  1down 


3- then shown in column T 


3- Button  in Column  T1 call it  1D  2D


Microsoft ExcelVBAMicrosoft Office

Avatar of undefined
Last Comment
ADRIANA P

8/22/2022 - Mon
Martin Liss

Please answer my question here.
Martin Liss

The navigation buttons are actually not working as needed, Click First Week and then click Next week. I will fix that.

Didn't we do the same or one up or one down somewhere else? Please attach that workbook.
ADRIANA P

ASKER
Best Expert !

The Navigation Buttons are working as i need them to work


Didn't we do the same or one up or one down somewhere else? Please attach that workbook.
we did  the same in 4N file you have already
29229832c.xlsb
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
Martin Liss

Before we get too far into this I'd like to propose this layout.
2021-12-15_16-57-23.png
ADRIANA P

ASKER
Best Expert !!
I am always grateful for your good advice

but please grant me keep my layout I need it the way I am presenting it to you I do not want to sound spoiled that is not my intention
Martin Liss

Which button in 29229832c.xlsb did that and which column is that button in?
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ADRIANA P

ASKER
T1 to V1 it create     AM/PM    AM  AND PM too (the  3 sections are )



Martin Liss

Try this.
ADRIANA P

ASKER
where is  Best Expert !
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
ASKER CERTIFIED SOLUTION
Martin Liss

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Martin Liss

Can you explain here or in a message why you don't want to use the layout I proposed?

¿Puede explicar aquí o en un mensaje por qué no desea utilizar el diseño que propuse?
Martin Liss

You can always add blank columns. The problem is that if you wanted to add a new column between, say, L and M, all the code for the buttons to the right of that would need to be changed because for example the code for the 1D 2D button currently refers specifically to columns Q, R, etc. That's why adding new columns in 4N and 3N was near-impossible given all the buttons involved. Today however I realized I can set up the workbook so that in the future if a new column or columns are added between L and M all code references to N, O, P and every other column to the right of it can be changed very easily. In other words if one column was added between L and M the code for 1D 2D could be changed almost automatically so that it would refer to R and S rather than Q and R.

The reason to do that is that in 99% of workbooks, if changing the value in one column effects other columns, those other columns are expected to be to the right of the source column and in your workbooks that isn't always true. The benefit to you are that the worksheets would be easier to read and also finding things would be is easier. Also if I'm not around you may have more success in getting someone else to help you.

Getting people to help you would be easier if you gave more information in your question requirements. I suggest that you always first write out your requirements in Spanish, spellcheck and grammar-check it and then always use Google Translate to translate it into English. The information you give should assume that the reader has no knowledge of the workbook.

Siempre puede agregar columnas en blanco. El problema es que si quisiera agregar una nueva columna entre, digamos, L y M, todo el código para los botones a la derecha de eso debería cambiarse porque, por ejemplo, el código para el botón 1D 2D actualmente se refiere específicamente a columnas Q, R, etc. Es por eso que agregar nuevas columnas en 4N y 3N fue casi imposible debido a todos los botones involucrados. Hoy, sin embargo, me di cuenta de que puedo configurar el libro de trabajo para que en el futuro, si se agregan nuevas columnas entre L y M, todas las referencias de código a N, O, P y cada otra columna a la derecha se puede cambiar muy fácilmente. En otras palabras, si se agrega una columna entre L y M, el código para 1D 2D podría cambiarse casi automáticamente para que se refiera a R y S en lugar de Q y R.

La razón para hacerlo es que en el 99% de los libros de trabajo, si cambiar el valor en una columna afecta a otras columnas, se espera que esas otras columnas estén a la derecha de la columna de origen y en sus libros de trabajo, lo que no siempre es cierto. El beneficio para usted es que las hojas de trabajo serían más fáciles de leer y también sería más fácil encontrar las cosas. Además, si no estoy cerca, es posible que tenga más éxito en conseguir que otra persona le ayude.

Conseguir que las personas le ayuden sería más fácil si proporcionara más información en los requisitos de sus preguntas. Le sugiero que primero escriba sus requisitos en español, revise la ortografía y la gramática y luego siempre use el Traductor de Google para traducirlo al inglés. La información que proporcione debe asumir que el lector no tiene conocimiento del libro de trabajo.
ADRIANA P

ASKER
Great Job !!

Best Expert !!
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ADRIANA P

ASKER
Well as I understood all the books could be improved