Link to home
Start Free TrialLog in
Avatar of ADRIANA P
ADRIANA PFlag 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





Avatar of Martin Liss
Martin Liss
Flag of United States of America image

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?
Avatar of 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
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.
User generated image
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
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Great Job
Best Expert !

need an button in GH so it takes the ORD in column BF and shows in column GH
The ORD values are already in GH.
I know better expert
but it would help me believe me!
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ok the formula take the ORD out of AM PM

can be synchronized?
the formula dont pick up the color as ORD

so it won't work
The formula was off by one row.
29217947b.xlsb
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.
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
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?
Best Expert !

need 2 of them please

need GG as is 
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.
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)
;)