Post your project for free and start receiving proposals from freelancers within minutes after publication!
VBA for Excel 2010
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
Applications 1
Application viewing is only available registered users.
Client's review of cooperation with Andrey Karn
VBA for Excel 2010Quality
Professionalism
Cost
Contactability
Deadlines
Andrei did everything quickly and efficiently. He responded properly to the comments, he corrected everything very quickly. I recommend it.
Freelancer's review of cooperation with Stanislav But
VBA for Excel 2010Payment
Task setting
Clarity of requirements
Contactability
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.
Client does not wish to make a prepayment? Payment through Safe helps avoid potential fraud.
-
Winning proposal5 days4 USD
67 5 0 Winning proposal5 days4 USDIt 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]
1 proposal concealed