BUSCA AQUI UN ARCHIVO EXCEL ►

Macro para unir varios libros excel en una sola hoja

Macro para unir varios libros en una hoja excel

Macro para unir varios libros excel en una sola hoja: Si eres el encargado de consolidar información desde distintos libros (archivos) a una hoja de excel presta mucha atención a esta macro que puede resultar siendo tu salvación. Esta macro es muy sencilla pero cumple en su totalidad la tarea de consolidar información, cabe aclarar que solo trabaja con archivos de extensión xlsx; es decir archivos grabados en la versión de Excel 2007, 2010 y 2013; lo he probado y te lo recomiendo. 

La macro consolida todas las hojas de un libro o de varios libros en una sola hoja de Excel por ejemplo si tenemos al libro A con 3 hojas y al libro B con 5, entonces se crea rá una hoja con la información de las 8 hojas en forma vertical, los libros tienen que ser de extensión .xlsx

COMO FUNCIONA

  • Lo primero es descargar el archivo (al final de esta entrada pueden encontrar el enlace) y habilitar macros.
  • presionamos ALT + F8 para llamar a la macro, seleccionamos “Open Files” y presionamos ejecutar.macro para consolidar informacion en una hoja excel
  • Elegimos los archivos a consolidar (Extensión .xlsx) y presionamos aceptar.Macro para unir varios libros en una hoja excel
  • Y listo, tienes todas tus hojas consolidadas en una sola.

Descargar macro para consolidar información en una sola hoja.xlsx

Fuente: Unir varios libros de excel en un solo


Ingresa tu correo electrónico y te convertiré en un experto en Excel. ↓


Agrega tu comentario

Comentarios
  1. Posted by Marco
    • Posted by Gustavo A. Sebastiani Cépeda
  2. Posted by ROBERTO ANAYA
    • Posted by Gustavo A. Sebastiani Cépeda
  3. Posted by Lugo
  4. Posted by Mauricio Castro
    • Posted by Gustavo A. Sebastiani Cépeda
  5. Posted by Angélica
    • Posted by Gustavo A. Sebastiani Cépeda
  6. Posted by Angélica
    • Posted by Gustavo A. Sebastiani Cépeda
  7. Posted by JONAS
    • Posted by Gustavo A. Sebastiani Cépeda
  8. Posted by Nelly
    • Posted by Gustavo A. Sebastiani Cépeda
  9. Posted by Alejandro Valencia
  10. Posted by Juan
    • Posted by Gustavo A. Sebastiani Cépeda
  11. Posted by Carol
    • Posted by Gustavo A. Sebastiani Cépeda
  12. Posted by Andrea
  13. Posted by Juan Isaza
  14. Posted by Jorge
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by Edwin
        • Posted by Gustavo A. Sebastiani Cépeda
  15. Posted by Yoly
    • Posted by Gustavo A. Sebastiani Cépeda
  16. Posted by Harold Lopez
    • Posted by Gustavo A. Sebastiani Cépeda
  17. Posted by Hugo Fredes
    • Posted by Hugo Fredes
    • Posted by Gustavo A. Sebastiani Cépeda
  18. Posted by Diego Arias
    • Posted by Gustavo A. Sebastiani Cépeda
  19. Posted by Luchador featuring
  20. Posted by ROSA FLORES
    • Posted by Gustavo A. Sebastiani Cépeda
  21. Posted by Juan
    • Posted by Gustavo A. Sebastiani Cépeda
  22. Posted by Cesar
    • Posted by Gustavo A. Sebastiani Cépeda
  23. Posted by moi
  24. Posted by Lucas
    • Posted by Gustavo A. Sebastiani Cépeda
  25. Posted by Cintia
    • Posted by Gustavo A. Sebastiani Cépeda
  26. Posted by Pedro CAro
  27. Posted by Luura
    • Posted by Gustavo A. Sebastiani Cépeda
  28. Posted by JULIAN
    • Posted by Gustavo A. Sebastiani Cépeda
  29. Posted by Cristianpm
  30. Posted by RAFAEL sUAREZ
    • Posted by Gustavo A. Sebastiani Cépeda
  31. Posted by Miguel
  32. Posted by Juan Tirado
  33. Posted by Marco Silva
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by Cristhian
        • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by sabrina
        • Posted by Gustavo A. Sebastiani Cépeda
    • Posted by Homero
  34. Posted by Jonathan Luna
    • Posted by Gustavo A. Sebastiani Cépeda
  35. Posted by JHONNY
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by JHONNY
      • Posted by Angie
        • Posted by Gustavo A. Sebastiani Cépeda
          • Posted by Angie
          • Posted by Gustavo A. Sebastiani Cépeda
  36. Posted by Rafael Martinez
    • Posted by Gustavo A. Sebastiani Cépeda
  37. Posted by DAVID MEDINA
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by Ainhoa Arnedo
        • Posted by Gustavo A. Sebastiani Cépeda
    • Posted by FABIO ARIAS
      • Posted by Gustavo A. Sebastiani Cépeda
  38. Posted by Alejandro
  39. Posted by Qualith
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by Jonathan
        • Posted by Gustavo A. Sebastiani Cépeda
  40. Posted by Oswaldo Cruz
  41. Posted by deyanira
  42. Posted by Lau
  43. Posted by Maxi
  44. Posted by Marco
    • Posted by Gustavo A. Sebastiani Cépeda
  45. Posted by luis
  46. Posted by Cesar Bringas
  47. Posted by Luis
  48. Posted by Jordi
  49. Posted by Ado Ello
  50. Posted by Pepe
  51. Posted by Cesar Botina
  52. Posted by Zoe
  53. Posted by junior
  54. Posted by ROBERTO
    • Posted by Gustavo A. Sebastiani Cépeda
  55. Posted by Gilder Barrios
  56. Posted by Carlos
  57. Posted by Rafael
    • Posted by Rafael
    • Posted by Gustavo A. Sebastiani Cépeda
  58. Posted by Cristian
    • Posted by jose
    • Posted by JAVIER
  59. Posted by Nori
    • Posted by Gustavo A. Sebastiani Cépeda
  60. Posted by Jovalcon
  61. Posted by Gustavo Adolfo Sanchez
  62. Posted by Marco Beltran
  63. Posted by DANIEL CARRANZA
  64. Posted by Julian
  65. Posted by FABIAN
  66. Posted by Lilia
    • Posted by Gustavo A. Sebastiani Cépeda
  67. Posted by mateo
  68. Posted by Jose Araujo
  69. Posted by walter
  70. Posted by Enrique
    • Posted by Gustavo A. Sebastiani Cépeda
  71. Posted by WILSON
  72. Posted by Miguel Rivera
    • Posted by ORLANDO
  73. Posted by Mario
  74. Posted by WILSON
  75. Posted by Eric
  76. Posted by EDDY
    • Posted by Gustavo A. Sebastiani Cépeda
  77. Posted by Gladys
  78. Posted by xavier rosales
  79. Posted by Frank
  80. Posted by daniel
  81. Posted by Diana Alon
  82. Posted by Leonardo
  83. Posted by Marco
  84. Posted by aidarm
  85. Posted by Ricardo
  86. Posted by Ricardo
  87. Posted by Mauricio
  88. Posted by Arakion
  89. Posted by Serbio
  90. Posted by Miguel
  91. Posted by irvox
  92. Posted by carlos
  93. Posted by jonathan josue aragon saz
  94. Posted by angel rico
  95. Posted by unir libros de excel un una sola hoja
  96. Posted by Cmatuss
    • Posted by Alfreed
  97. Posted by Veronica
  98. Posted by jair nilton
    • Posted by Freddy
  99. Posted by Fredy Rodriguez
  100. Posted by Manuel
  101. Posted by Carlos Castillo
  102. Posted by Franklin
  103. Posted by Ximena C
  104. Posted by JCarlos Vazquez
  105. Posted by Jeferson D.
  106. Posted by JC Bardales
  107. Posted by roulssel bermudez
  108. Posted by Diego Pérez
  109. Posted by Carlos Ticona C
    • Posted by Marco