How to automatically create new sheets in excel with data from the first sheet?

Q

qovalenko2018-03-23 09:03:02

Automation

qovalenko, 2018-03-23 09:03:02

There are two excel files, a template and a data table, please tell me an example of automating the creation of new sheets or documents (of a specific template), which include data from the "data table".

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

D

Denis _______________, 2018-03-23
@qovalenko

I solved exactly the same problem in relation to the automation of as-built documentation in construction. A self-written variant in which a template file is taken, a sheet is copied from it into a book with macros, filled with data from tables and saved in a new file under a name according to the template. https://habrahabr.ru/post/344956/