asked on 5/17/2021

By Date 3N PAir Column

3n_w_pairs
29215977.xlsm

By date create one column of the pairs
in sheet ONE3N

1-select date by month and years (not just years)

2- from the selected DATE but the 3 columns of pairs in one column

VBA Microsoft Excel Microsoft Office

Last Comment

ADRIANA P

5/17/2021

Martin Liss

5/17/2021

The numbers that you show on the ONE3N sheet from rows 5 to 6775 seem to be the numbers from column 'E' rows 7 to 6777 of the 3NPair sheet. Where do the rest of the numbers on the ONE3N come from?

ADRIANA P

5/17/2021

ASKER

i did one column from E7 + F7 + G7

need do the same but with date selector

Martin Liss

5/17/2021

That does not seem to be the case. The last value in 52W2021 in column 'C' of the 3NPAIR sheet is 26 and you show that in C6775 of the ONE3N sheet, but in C6777 you show 85. Where does the 85 come from?

ADRIANA P

5/17/2021

ASKER

I see sorry

ASKER CERTIFIED SOLUTION

Martin Liss

5/17/2021

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

ADRIANA P

5/17/2021

ASKER

Lead The Way !!

Best Expert !

ADRIANA P

5/17/2021

ASKER

have an situation when i add a new year it do not tshow up

need an solution for add news years to comes as always i add new data always

29216013.xlsm

Martin Liss

5/17/2021

I don't understand what problem you are having. The 'Select Date Range' button works for me with the new data.

ADRIANA P

5/17/2021

ASKER

You Rigth Best Expert !!

i did not closed and open the file
after i did it shows the 2022 year !!

Great Job !