VBA for Excel 2010

— incorrectly specified categories?

4 USD

Client's review of cooperation with Andrey Karn

VBA for Excel 2010

4 USD

Andrei did everything quickly and efficiently. He responded properly to the comments, he corrected everything very quickly. I recommend it.

5.0

I really liked working with Stanislav. A person can formulate a task very clearly, always ready for a constructive dialogue, always available to clarify and harmonize the details of the project. 10 out of 10.

5.0

Andrey Karn

Reciprocal Feedback

9 December 2014

Project translated automatically. Log in or register, to view the original You need to write a small macro that will gather data from different tables/books on one sheet, as shown in the example.The file structure may be arbitrary, but each file has tables with predefined names starting with the characters "tr_".The data is collected only from tables with predefined names.In turn, the structure of the tables may be arbitrary, but in each table there are fields with predefined names, which also starts with the characters "tr_".The data is collected from these fields.Data consolidation is made on the Sum list.When performing the macro, the data on the list should be cleaned and re-registered.The list should not be re-created because.It is the source of data for existing summary tables.List of consolidation one, in the main workbook.If you need to collect data from several books, the names of the consolidation files will be set in a clear form in the form of a list on the main workbook list (not shown in the example).Compatibility of the fields of the output tables and the fields of the consolidation sheet:The field of the output tablesThe field of the consolidation sheet Notestr_Datetr_Datetr_Scentr_Item1, tr_Item2, ..., tr_ItemNtr_ItemThe example shows 2 fields tr_Item, but may be more.The number of fields with the names tr_Item, tr_PL, tr_SumA, tr_SumB is always the same.tr_PL1, tr_PL2, ..., tr_PLNtr_PLtr_SumA1, tr_SumA2, ..., tr_SumANtr_SumAtr_SumB1, tr_SumB2, ..., tr_SumBNtr_SumB

Proposals 2

Andrey Karn

Winning proposal

5 0

Projects -
Rating -
Rating 67

Budget: 200 UAH Deadline: 5 days

It would be interesting to try. They are interested in time and cost. The essence of the task is generally clear, but there are some questions about TZ. Soap [email protected]

Stanislav But
Zaporizhzhia, Ukraine

Projects 1
Rating -
Rating 213

VBA for Excel 2010

Client's review of cooperation with Andrey Karn

VBA for Excel 2010

5.0

Stanislav But

Freelancer's review of cooperation with Stanislav But

VBA for Excel 2010

5.0

Andrey Karn

Andrey Karn

Proposals concealed

Proposals are currently absent