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

4n create key for TP

4n w_ordS to add FKeys
29219348.xlsb

1-create the Keys from BYPLAY sheet in this case top week numbers

2-then shows in FKEYS sheet by week

3-from here :

4- To here

VBAMicrosoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
ADRIANA P

8/22/2022 - Mon
Martin Liss

Why create another new worksheet? Couldn't we just add a new column to the SUMMARY sheet?
ADRIANA P

ASKER

ok it's fine but let it be between 6 columns as shown in the photo please
Martin Liss

All the columns you show in the FKEY worksheet are already in the SUMMARY worksheet with the exception of TOP WK KEYS column.

Todas las columnas que muestra en la hoja de trabajo FKEY ya están en la hoja de trabajo SUMMARY con la excepción de la columna TOP WK KEYS.
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
Martin Liss

Please ignore my suggestion.
ADRIANA P

ASKER
:)


Martin Liss

On which worksheet should I put the FKEYS button?
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
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!