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

4N shows Data by Columns

4N wBPwYs add to smry PTRMPMT
29217708a.xlsb

1- from sheet1              source            to          DESTINATION =   SUMMARY sheet
                                         sheet1                       SUMMARY
                                        source                       Destination
 PAIRS TOP            columns BX BY    to             AC AD
 TRI TOP                        CJ CK                           AF AG
REPEAT                             CZ                                AI
MID PAIRS                      EO EP                          AK AL
MID TRI                           EY EZ                           AN AO

2-the existing years and those to be added in the future
VBAMicrosoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
ADRIANA P

8/22/2022 - Mon
ADRIANA P

ASKER
i update the file to the last
29217708a.xlsb 
Martin Liss

I don't understand the question so please try again. When you do, please use Google Translate to translate your Spanish into English. It would also be nice if you added a sheet that shows what you want since what you show in your question is hard to understand.

No entiendo la pregunta, inténtelo de nuevo. Cuando lo haga, utilice Google Translate para traducir su español al inglés. También sería bueno si agregara una hoja que muestre lo que desea, ya que lo que muestra en su pregunta es difícil de entender.
ADRIANA P

ASKER
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
Martin Liss

If you don't like the headings I can change them.
29217717.xlsb
ADRIANA P

ASKER
If you don't like the headings I can change them. 
 they can be from the other side
it is my habit to read
Martin Liss

Right now column like 'Y' read top to bottom. Do you want top to bottom or bottom to top? Columns like AC:AD read right to left. Do you want right to left or left to right?

En este momento, la columna como 'Y' se lee de arriba a abajo. ¿Quieres de arriba hacia abajo o de abajo hacia arriba? Columnas como AC: AD se leen de derecha a izquierda. ¿Quieres de derecha a izquierda o de izquierda a derecha?
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
ADRIANA P

ASKER
bottom to top

 left to right


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 !