Skip to content
This repository has been archived by the owner on Jan 13, 2023. It is now read-only.

Super fast and intelligent macro to concat Excel sheets data into one sheet

License

Notifications You must be signed in to change notification settings

xsoulspace/sheets_concat_excel_vba_macro

Repository files navigation

Excel Vba Sheet Concat

Contributor Covenant

Purpose

The macro collects data from all sheets in an active book, creates a new sheet and writes all data to the new sheet.

If the book is saved in .xls format, then the data will be written to new book.

Getting Started

These instructions will get you a copy of the project up and running on your local machine for development and testing purposes.

Prerequisites

To install you need to download lastest release

MSVBA-SheetConcat

Installing

Look at the top of your Excel Window and check Ribbon menu for button “Developer”. If you see it in the menu options, then you are ready to go and you can skip straight ahead to the next step. However, if the Developer menu is not there, just follow these instructions.

File -> Options -> Customize Ribbon

A new window will open, ensure the Developer option is ticked in the box in right side of view. Click OK.

Find the Visual Basic Editor within the Developer Ribbon Menu

Open System Folder with downloaded files, extract archive to some folder in your PC. Then select extracted files and drag and drop into VBA file tree. You can see example below.

example

That's all, now you can use the macro.

How to use

To run added Macro go:

Ribbon Menu -> Developer -> Code -> Macros

Select Macro "SheetConcat" and click Run.

Contributing

Very welcome, but please read CONTRIBUTING.md for details on our code of conduct, and the process for submitting pull requests to us.

Versioning

We use SemVer for versioning. For the versions available, see the tags on this repository.

Authors

  • Anton Malofeev - Initial work - Arenukvern
  • Mihail Melnikov - Maintainer - mixev

License

This project is licensed under the MIT License - see the LICENSE.md file for details

Acknowledgments

  • You can be the first to whom we will be grateful😊

About

Super fast and intelligent macro to concat Excel sheets data into one sheet

Topics

Resources

License

Code of conduct

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages