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

4N move code to new sheet

4N wDSY to move DD to DDX sheet
29217806.xlsb

1-Move from sheet1 columns GH to KZ
to sheet "DDX"

ALL the BUTTONS FORMULAS CODE

so the sheet1  get clean as posible





VBAMicrosoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
ADRIANA P

8/22/2022 - Mon
Martin Liss

That would be a long, error-prone process. How does it help you?

Ese sería un proceso largo y propenso a errores. ¿Cómo te ayuda?
ADRIANA P

ASKER
management and visualization (real state of the sheet) and expansion (add or remove) and improvements that I want to make

Anyway, it has errors that need to be corrected

1-I wonder, do you recommend moving it?

2- (GU GV) button NUM DD shows an error after HIT
Martin Liss

The error can be fixed.

I don't recommend moving it because, as I said, it is error-prone.

Do you ever use the Outline bars like this one? One could be added that would hide and unhide columns C to GF if you want to.
2021-06-10_08-32-38.png
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
ADRIANA P

ASKER
Do you ever use the Outline bars like this one?

yes we work on that. don't use them for now

The error can be fixed. 

then need fix the buttons in this section are not working as should be

can we fix them ?

need an button in GH so it takes the ORD in column BF and shows in column GH
ASKER CERTIFIED SOLUTION
Martin Liss

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
ADRIANA P

ASKER
Great Job
Best Expert !

ADRIANA P

ASKER
need an button in GH so it takes the ORD in column BF and shows in column GH
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Martin Liss

The ORD values are already in GH.
ADRIANA P

ASKER
I know better expert
but it would help me believe me!
SOLUTION
Martin Liss

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
ADRIANA P

ASKER
ok the formula take the ORD out of AM PM

can be synchronized?
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
ADRIANA P

ASKER
the formula dont pick up the color as ORD

so it won't work
Martin Liss

The formula was off by one row.
29217947b.xlsb
Martin Liss

If there are columns that you don't use I can hide them. If you'd like me to do that then please list the unused columns.

Si hay columnas que no usa, puedo ocultarlas. Si desea que haga eso, enumere las columnas no utilizadas.
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
ADRIANA P

ASKER
If there are columns that you don't use I can hide them. If you'd like me to do that then please list the unused columns.

is ok by now

but need an GO To WEEK buttom in GF1
Martin Liss

You already have one in column B. Do you want 2 of them or do you want me to move the existing one?
Ya tienes uno en la columna B. ¿Quieres 2 de ellos o quieres que mueva el existente?

You don't use column GG so can I remove the color?
No usas la columna GG, ¿puedo eliminar el color?
ADRIANA P

ASKER
Best Expert !

need 2 of them please

need GG as is 
Your help has saved me hundreds of hours of internet surfing.
fblack61
Martin Liss

I added the second button, but just out of curiosity why do you need the color in column GG?
Agregué el segundo botón, pero solo por curiosidad, ¿por qué necesita el color en la columna GG?

Please don't give me any more points for this.
Por favor, no me des más puntos por esto.
ADRIANA P

ASKER
Where is the  file

best expert !!

why do you need the color in column GG? 

in me Case im using the file it has 2 parts it shows me where Im

(the real state may or may not be helpful)
Martin Liss

Hiding:)
29217947c.xlsb
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
ADRIANA P

ASKER
;)