fbpx

Macro para unir varios libros excel en una sola hoja

-->

Macro para unir varios libros en una hoja excelMacro 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

Agrega tu comentario

Comentarios
  1. Posted by Nestor
    • Posted by Gustavo A. Sebastiani Cépeda
  2. Posted by Leo
    • Posted by Gustavo A. Sebastiani Cépeda
  3. Posted by Carla Paola
    • Posted by Gustavo A. Sebastiani Cépeda
  4. Posted by Wilmer Cardona
    • Posted by Gustavo A. Sebastiani Cépeda
  5. Posted by German
    • Posted by Gustavo A. Sebastiani Cépeda
  6. Posted by Nancy Rosales
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by Nancy Rosales
        • Posted by Gustavo A. Sebastiani Cépeda
    • Posted by Manuel
  7. Posted by SILVINA
    • Posted by Gustavo A. Sebastiani Cépeda
  8. Posted by Ivonne
    • Posted by Gustavo A. Sebastiani Cépeda
  9. Posted by Ana
    • Posted by Gustavo A. Sebastiani Cépeda
  10. Posted by Israel
    • Posted by Gustavo A. Sebastiani Cépeda
  11. Posted by Nery Ramirez
    • Posted by Gustavo A. Sebastiani Cépeda
  12. Posted by Gustavo A. Sebastiani Cépeda
  13. Posted by Fernando
    • Posted by Gustavo A. Sebastiani Cépeda
  14. Posted by Yohana
    • Posted by Gustavo A. Sebastiani Cépeda
  15. Posted by Jose
    • Posted by Gustavo A. Sebastiani Cépeda
  16. Posted by Fabián
    • Posted by Gustavo A. Sebastiani Cépeda
  17. Posted by luz
    • Posted by Gustavo A. Sebastiani Cépeda
  18. Posted by LUZ
    • Posted by Gustavo A. Sebastiani Cépeda
  19. Posted by Erick C
    • Posted by Gustavo A. Sebastiani Cépeda
  20. Posted by HAROLD HERRERA BARRIOS
    • Posted by Gustavo A. Sebastiani Cépeda
  21. Posted by CAROLINA SALAZAR CASTAÑO
    • Posted by Gustavo A. Sebastiani Cépeda
  22. Posted by Noe
    • Posted by Gustavo A. Sebastiani Cépeda
  23. Posted by Jorge
    • Posted by Gustavo A. Sebastiani Cépeda
  24. Posted by Oscar Hdez
  25. Posted by ELVER DIAZ
  26. Posted by CESAR TG
  27. Posted by GErman
  28. Posted by Federico
  29. Posted by ARKA
    • Posted by Gustavo A. Sebastiani Cépeda
    • Posted by gary
  30. Posted by Juan Leon
  31. Posted by alex cajan
  32. Posted by jose
    • Posted by Gustavo A. Sebastiani Cépeda
  33. Posted by Matias
  34. Posted by Alvaro Masias
    • Posted by Gustavo A. Sebastiani Cépeda
  35. Posted by Pedro
  36. Posted by ELIZABETH VILLEGAS
  37. Posted by Christian
    • Posted by Gustavo A. Sebastiani Cépeda
  38. Posted by luz
  39. Posted by William Chanhualla
  40. Posted by Liliana
    • Posted by Gustavo A. Sebastiani Cépeda
  41. Posted by El Tano informático
  42. Posted by Franklin
  43. Posted by CARLOS CRUZ RIVERA
  44. Posted by MARILYS RODRIGUEZ VIQUEZ
  45. Posted by Jess
    • Posted by Robin Solano
  46. Posted by Luis Almeida
    • Posted by Robin Solano
  47. Posted by Jose Vargas Hiyo
  48. Posted by Ivan
  49. Posted by martin amado
  50. Posted by OSCAR ROSERO
    • Posted by OSCAR ROSERO
      • Posted by Santino
        • Posted by Gustavo A. Sebastiani Cépeda
        • Posted by javier delgado
          • Posted by Gustavo A. Sebastiani Cépeda
    • Posted by Gustavo A. Sebastiani Cépeda
  51. Posted by jesus
  52. Posted by camilo serna
    • Posted by Gustavo A. Sebastiani Cépeda
  53. Posted by JOSE
    • Posted by Gustavo A. Sebastiani Cépeda
  54. Posted by Alsk
    • Posted by Gustavo A. Sebastiani Cépeda
  55. Posted by Sofii Fajardo
    • Posted by Robin Solano
  56. Posted by Harold Hurtado
    • Posted by Robin Solano
  57. Posted by Alejandro
  58. Posted by DIEGO SIERRA
    • Posted by Robin Solano
  59. Posted by Marcelo Fabian
    • Posted by Gustavo A. Sebastiani Cépeda
  60. Posted by Manuel
  61. Posted by Manuel
  62. Posted by Hugo Meza Gheo
    • Posted by Gustavo A. Sebastiani Cépeda
  63. Posted by José González
  64. Posted by juan carlos
    • Posted by Robin Solano
  65. Posted by Walter
    • Posted by Gustavo A. Sebastiani Cépeda
  66. Posted by Dieogo Rueda
    • Posted by Gustavo A. Sebastiani Cépeda
  67. Posted by Alexandra R
    • Posted by Gustavo A. Sebastiani Cépeda
  68. Posted by Carlos Daza
    • Posted by Gustavo A. Sebastiani Cépeda
  69. Posted by Héctor Mario
  70. Posted by Javier
    • Posted by Gustavo A. Sebastiani Cépeda
  71. Posted by Rene Bojorquez
    • Posted by Robin Solano
  72. Posted by Jaime
    • Posted by Gustavo A. Sebastiani Cépeda
  73. Posted by Javier
    • Posted by Gustavo A. Sebastiani Cépeda
  74. Posted by Phil Bass
  75. Posted by José Vicente
    • Posted by Gustavo A. Sebastiani Cépeda
  76. Posted by ROLANDO
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by victor
        • Posted by Gustavo A. Sebastiani Cépeda
  77. Posted by Luciana DF
    • Posted by Gustavo A. Sebastiani Cépeda
  78. Posted by Luciana DF
    • Posted by Luciana DF
    • Posted by Gustavo A. Sebastiani Cépeda
  79. Posted by Marco
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by Edwin Buitrago
        • Posted by Gustavo A. Sebastiani Cépeda
  80. Posted by ROBERTO ANAYA
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by Jorge González
        • Posted by Gustavo A. Sebastiani Cépeda
  81. Posted by Lugo
  82. Posted by Mauricio Castro
    • Posted by Gustavo A. Sebastiani Cépeda
  83. Posted by Angélica
    • Posted by Gustavo A. Sebastiani Cépeda
  84. Posted by Angélica
    • Posted by Gustavo A. Sebastiani Cépeda
  85. Posted by JONAS
    • Posted by Gustavo A. Sebastiani Cépeda
  86. Posted by Nelly
    • Posted by Gustavo A. Sebastiani Cépeda
  87. Posted by Alejandro Valencia
  88. Posted by Juan
    • Posted by Gustavo A. Sebastiani Cépeda
  89. Posted by Carol
    • Posted by Gustavo A. Sebastiani Cépeda
  90. Posted by Andrea
  91. Posted by Juan Isaza
  92. Posted by Jorge
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by Edwin
        • Posted by Gustavo A. Sebastiani Cépeda
  93. Posted by Yoly
    • Posted by Gustavo A. Sebastiani Cépeda
  94. Posted by Harold Lopez
    • Posted by Gustavo A. Sebastiani Cépeda
  95. Posted by Hugo Fredes
    • Posted by Hugo Fredes
    • Posted by Gustavo A. Sebastiani Cépeda
  96. Posted by Diego Arias
    • Posted by Gustavo A. Sebastiani Cépeda
  97. Posted by Luchador featuring
  98. Posted by ROSA FLORES
    • Posted by Gustavo A. Sebastiani Cépeda
  99. Posted by Juan
    • Posted by Gustavo A. Sebastiani Cépeda
  100. Posted by Cesar
    • Posted by Gustavo A. Sebastiani Cépeda
  101. Posted by moi
  102. Posted by Lucas
    • Posted by Gustavo A. Sebastiani Cépeda
  103. Posted by Cintia
    • Posted by Gustavo A. Sebastiani Cépeda
  104. Posted by Pedro CAro
  105. Posted by Luura
    • Posted by Gustavo A. Sebastiani Cépeda
  106. Posted by JULIAN
    • Posted by Gustavo A. Sebastiani Cépeda
  107. Posted by Cristianpm
  108. Posted by RAFAEL sUAREZ
    • Posted by Gustavo A. Sebastiani Cépeda
  109. Posted by Miguel
  110. Posted by Juan Tirado
  111. 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 Katherinne
          • Posted by Gustavo A. Sebastiani Cépeda
    • Posted by Homero
  112. Posted by Jonathan Luna
    • Posted by Gustavo A. Sebastiani Cépeda
  113. 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
  114. Posted by Rafael Martinez
    • Posted by Gustavo A. Sebastiani Cépeda
  115. 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
  116. Posted by Alejandro
  117. Posted by Qualith
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by Jonathan
        • Posted by Gustavo A. Sebastiani Cépeda
  118. Posted by Oswaldo Cruz
  119. Posted by deyanira
  120. Posted by Lau
  121. Posted by Maxi
  122. Posted by Marco
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by Sofii Fajardo
  123. Posted by luis
  124. Posted by Cesar Bringas
  125. Posted by Luis
  126. Posted by Jordi
  127. Posted by Ado Ello
  128. Posted by Pepe
  129. Posted by Cesar Botina
  130. Posted by Zoe
  131. Posted by junior
  132. Posted by ROBERTO
    • Posted by Gustavo A. Sebastiani Cépeda
  133. Posted by Gilder Barrios
  134. Posted by Carlos
  135. Posted by Rafael
    • Posted by Rafael
    • Posted by Gustavo A. Sebastiani Cépeda
  136. Posted by Cristian
    • Posted by jose
    • Posted by JAVIER
  137. Posted by Nori
    • Posted by Gustavo A. Sebastiani Cépeda
  138. Posted by Jovalcon
  139. Posted by Gustavo Adolfo Sanchez
  140. Posted by Marco Beltran
  141. Posted by DANIEL CARRANZA
  142. Posted by Julian
  143. Posted by FABIAN
  144. Posted by Lilia
    • Posted by Gustavo A. Sebastiani Cépeda
  145. Posted by mateo
  146. Posted by Jose Araujo
  147. Posted by walter
  148. Posted by Enrique
    • Posted by Gustavo A. Sebastiani Cépeda
  149. Posted by WILSON
  150. Posted by Miguel Rivera
    • Posted by ORLANDO
  151. Posted by Mario
  152. Posted by WILSON
  153. Posted by Eric
  154. Posted by EDDY
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by Javier
        • Posted by Gustavo A. Sebastiani Cépeda
  155. Posted by Gladys
  156. Posted by xavier rosales
  157. Posted by Frank
  158. Posted by daniel
  159. Posted by Diana Alon
  160. Posted by Leonardo
  161. Posted by Marco
  162. Posted by aidarm
  163. Posted by Ricardo
  164. Posted by Ricardo
  165. Posted by Mauricio
  166. Posted by Arakion
  167. Posted by Serbio
  168. Posted by Miguel
  169. Posted by irvox
  170. Posted by carlos
  171. Posted by jonathan josue aragon saz
  172. Posted by angel rico
  173. Posted by unir libros de excel un una sola hoja
  174. Posted by Cmatuss
    • Posted by Alfreed
  175. Posted by Veronica
  176. Posted by jair nilton
    • Posted by Freddy
  177. Posted by Fredy Rodriguez
  178. Posted by Manuel
  179. Posted by Carlos Castillo
  180. Posted by Franklin
  181. Posted by Ximena C
  182. Posted by JCarlos Vazquez
  183. Posted by Jeferson D.
  184. Posted by JC Bardales
  185. Posted by roulssel bermudez
  186. Posted by Diego Pérez
  187. Posted by Carlos Ticona C
    • Posted by Marco