Forum Discussion

Josecahu's avatar
Josecahu
Copper Contributor
May 07, 2020
Solved

Direccionar una fila

Imaginemos que me facilitan una tabla a diario con los datos de 6 tiendas (6 filas), al día siguiente la misma tabla ampliada en otras 6 filas (ya son 12) y así sucesivamente. Si quiero separar en 6...
excel
  • Josecahu's avatar
    Josecahu
    May 09, 2020

    amit_bhola 

      

    Tabla 25 Maestra. Separar en 6 tablas los resultados de cada una de las 6 tiendas. Si separo los datos en la misma tabla25 sí que funciona, si separo en 6 tablas, en la Tabla1 no reconoce y da 0 =@INDIRECTO(Hoja25!N3) . Indirecto sólo funciona con la presente tabla?

    Hoja25!N3=A2 ------->"Hoja 2 Celda" A2=AN

    Thanks

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
May 10, 2020

Josecahu As a variant, and in case your Excel version supports the FILTER function (see note below). In the attached workbook I tried to visualise the situation you are describing, though, for three stores only. Easy to expand. Stores may be added at any time. Not every stores must be included every day. Stores do not have to be in the same order every day. Obviously, store names must be consistent.

 

Note: This function is currently available to Microsoft 365 subscribers in the Monthly channel. It will be available to Microsoft 365 subscribers in the Semi-Annual channel starting in July 2020.

Resources