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

create key for 2N

29232770.xlsm



1. (5-) Add  KEY PAIRS sets by week in column DB


2. (6-) Add Button  2W PAIRS Button by 2Weeks in  column DD1 to DG1


3. (7-) ADD Button for Key by 2Weeks  in column DH

Microsoft ExcelVBAMicrosoft Office

Avatar of undefined
Last Comment
ADRIANA P

8/22/2022 - Mon
Martin Liss

Please test and close the previous question.
Martin Liss

Add  KEY PAIRS sets by week in column DB
Which button in source-2N.xlsm is that?
ADRIANA P

ASKER
Which button in source-2N.xlsm is that?

No Button in source-2N.xlsm  for this because never have been done for 2N 
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

Well then I need you to tell me what the code should do.
ADRIANA P

ASKER
Here as  i identify also the column DC as wells

by week for column CX = column DB KEY

for column CZ = column DC KEY

Best Expert!!



ADRIANA P

ASKER
for the key be suceful it have to have always the same order  
⚡ 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

Add Button  2W PAIRS Button by 2Weeks in  column DD1 to DG1
Which button in source-2N.xlsm is that?
Martin Liss

for the key be suceful it have to have always the same order
???? Google Translate please.
ADRIANA P

ASKER
Which button in source-2N.xlsm is that? 

BE1 to BH1
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
ADRIANA P

ASKER
For the key to be successful it must always have the same order

I mean that the order must always be in CX and CZ an ascending order that is ( It makes a difference )

and that would always identify an order that is repeated

then keys are created on columns DB and DC
Martin Liss

When you said "Add Button  2W PAIRS Button by 2Weeks in  column DD1 to DG1" I now understand that you meant "Add Button  2 WK Pair Key in  column DD1 to DG1". Please, as I asked you to do previously, always use the actual names of buttons since we have so many of them and some names are similar.

Cuando dijiste "Add Button  2W PAIRS Button by 2Weeks in  column DD1 to DG1" ahora entiendo que querías decir "Add Button  2 WK Pair Key in  column DD1 to DG1". Por favor, como te pedí que hicieras anteriormente, siempre usa el nombres de botones ya que tenemos muchos de ellos y algunos nombres son similares.
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 !!
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.