Avatar of ADRIANA P
ADRIANA PFlag for United States of America

asked on 

create 13 set for top selection

Add an 13 set selector   button  for any selection in TOP area   in an new sheet

User generated image


User generated image29143584_TOP_set.xlsm
VBAMicrosoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Martin Liss
ASKER CERTIFIED SOLUTION
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

Blurred text
THIS SOLUTION IS 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
Avatar of ADRIANA P
ADRIANA P
Flag of United States of America image

ASKER

Great JoB !

Best Expert !
Avatar of ADRIANA P
ADRIANA P
Flag of United States of America image

ASKER

Martin
 is not working properly

some times don't show the result

or repeat the same data

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

The problem is happening because there are two problems with the data.
  • Between rows 3112 and 4789 there are no week numbers in column 'B'. I fixed that.
  • Between rows 3112 and 4789 there are no ORD values. I don't know how to fix that.

So now the data doesn't repeat, but it's blank because there's no ORD values.

El problema está sucediendo porque hay dos problemas con los datos.
  • Entre las filas 3112 y 4789 no hay números de semana en la columna 'B'. He arreglado eso.
  • Entre las filas 3112 y 4789 no hay valores ORD. No sé cómo arreglar eso.

Así que ahora los datos no se repiten, pero están en blanco porque no hay valores ORD.
29143638a.xlsm
Microsoft Excel
Microsoft Excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo