Adjust file to show the range

ADRIANA P
ADRIANA P used Ask the Experts™
on
please adjust this file   29168464   to show the range as the 29168524a.xlsm file please

a1122.PNG29168464.xlsm
29168524a.xlsm
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Martin Liss"There is still no cure for the common birthday." ~John Glenn
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
Which column letters from 29168524a.xlsm do you want to see i 29168464.xlsm?

¿Qué letras de columna de 29168524a.xlsm quieres ver i 29168464.xlsm?
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
a11.PNG
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
the range   in file 29168464  is not showing all the pairs as the source

that why i ask  for an adjustment

b1.png

like you did in file 29168524a.xlsm

but the column CG need be shows as is in the source
Martin Liss"There is still no cure for the common birthday." ~John Glenn
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
Okay, two other questions about 29168464.xlsm
  1. Do you like the brown color in the headings or would you like it to look like 29168524a.xlsm?
  2. Are you aware that you are missing a lot of data in 29168464.xlsm starting at row 2579?

  1. ¿Te gusta el color marrón en los encabezados o te gustaría que se parezca a 29168524a.xlsm?
  2. ¿Sabe que le faltan muchos datos en 29168464.xlsm a partir de la fila 2579?
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Do you like the brown color in the headings or would you like it to look like 29168524a.xlsm?

yes i like it



Are you aware that you are missing a lot of data in 29168464.xlsm starting at row 2579?

data will be add as the file is ready for work
Martin Liss"There is still no cure for the common birthday." ~John Glenn
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
As far as I can tell the only difference between your second picture and what is already in 29168464.xlsm is column CH. Is that all you want added? If not then please give me, in words, more detail about what you want.
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
the count in the range are not good in file 29168464

c1.PNG
as is in the source
a11.PNG
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
also i will need the change button  working please Martin
Martin Liss"There is still no cure for the common birthday." ~John Glenn
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
also i will need the change button  working please Martin
Sure but what is the point of having "Change" columns 'D', 'F' and 'H' since 'D' is the same as 'L' and data doesn't exist for 'F' and 'H" and there is mo code to create what's already in those columns.

Claro, pero cuál es el punto de tener "Change" las columnas 'D', 'F' y 'H' ya que 'D' es lo mismo que 'L' y los datos no existen para 'F' y 'H' y allí es el código mo para crear lo que ya está en esas columnas.
Martin Liss"There is still no cure for the common birthday." ~John Glenn
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
Also would "Modificar" be better than "Change"?
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Martin

data in the range have to be change as needed

on the fly

thats why need the change button
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Also would "Modificar" be better than "Change"?

yes
Martin Liss"There is still no cure for the common birthday." ~John Glenn
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
data in the range have to be change as needed
In which column(s) do you want the "Change" to work?

¿En qué columna (s) desea que funcione el "Cambio"?
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
In which column(s) do you want the "Change" to work?

Column L  Please !
"There is still no cure for the common birthday." ~John Glenn
Most Valuable Expert 2017
Distinguished Expert 2018
Commented:
Try this.
29169092.xlsm
Martin Liss"There is still no cure for the common birthday." ~John Glenn
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
I forgot to mention that I added the dates in column 'A'.
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Great Job
Best Expert !

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial