Link to home
Start Free TrialLog in
Avatar of ADRIANA P
ADRIANA PFlag for United States of America

asked on

Create key and create button

29231180.xlsb file 3n


in sheet1  

1-create the key for DD from column AT  in the column AK as shown 


User generated image



then

as we did here for 4N 

https://www.experts-exchange.com/questions/29230532/create-sheet.html


now for 3N

in CONSE sheet create GET DATA button 



2- Create the ALL PAIRS in columns  R  to  T  (from columns AG  to AI sheet1)


3- Create the  CONSE  PAIRS   in columns AA to ACI   ((from columns AG  to AI sheet1)


4- Create the Keys for DD in columns  AJ  (from columns AT   sheet1)



User generated image



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

Please show me what the right side of the CONSE sheet should look like.
Avatar of ADRIANA P

ASKER

User generated image
The 4N workbook that you posted is not the latest one. The latest one is in this question and I'll use that one as a guide unless you say I shouldn't.
please use always the last version

sorry if i lost the last version (a have a lot of sitations around me and sometimes lose the vision)

we are making 3N of the last file 4N

You are correct. It's very important that you keep track of the latest 4N, 3N and 2N workbook.
then
as we did here for 4N 
https://www.experts-exchange.com/questions/29230532/create-sheet.html

what I wanted to show on this page is the functionality of what we did so that it is stored in the 3n file now


but I did not mean the last file of 4n

I am clear where the last thing is done so far
In your example shouldn't M6 be 26? Followed by 61 in N6 and 21 in O6?
In your example shouldn't M6 be 26? Followed by 61 in N6 and 21 in O6?

yes !!

The Get Data button uses the DTON sheet to color columns M to O and since we are now working with a 3N workbook I believe the DTON sheet needs to be updated.
I did !! columns AZ to BF have the update for pairs beyond TRI
I did !!
In which workbook?
3N DTON
I believe columns AH and AL still need to be updated for 3N since M to O now contain 2-digit numbers.
29231180.xlsb  update done in DTON 

TRIG PAIRS in columns AI

DD TRIG  column AN   
DD TRIG is the  primary

TRIG PAIRS is the secondary


So now do I use AI and AN instead of AH and AL?
yes!!!
is an great Job !! as needed 

Best Expert !

But the color is too similar don't let me see the the difference clear

can we adjust please the color to be more lighter  

as shown Please !!

User generated image
this way  can help more

User generated image

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 !!