ADRIANA P
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
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)
Please show me what the right side of the CONSE sheet should look like.
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.
ASKER
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
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
ASKER
https://www.experts-exchange.com/questions/29231070/add-userform-to-columns-other-sheet.html
here is the last version of 4N we did
file 29231070a.xlsb is 4N last
here is the last version of 4N we did
file 29231070a.xlsb is 4N last
You are correct. It's very important that you keep track of the latest 4N, 3N and 2N workbook.
ASKER
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?
ASKER
In your example shouldn't M6 be 26? Followed by 61 in N6 and 21 in O6?
yes !!
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.
ASKER
I did !! columns AZ to BF have the update for pairs beyond TRI
I did !!In which workbook?
ASKER
3N DTON
I believe columns AH and AL still need to be updated for 3N since M to O now contain 2-digit numbers.
ASKER
ASKER
DD TRIG is the primary
TRIG PAIRS is the secondary
TRIG PAIRS is the secondary
So now do I use AI and AN instead of AH and AL?
ASKER
yes!!!
Try this.
29231276.xlsb
29231276.xlsb
ASKER
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Great Job !! Best Expert !!