1
Владислав
no recommendations
no complaints
Closed
Project title: Excel Macros to Update the Summary Table
Type of cooperation: One-time project
Section: Other / Miscellaneous
Prepayment: without prepayment
Payment methods: Bank transfer
Acceptance of requests: closed
Type of cooperation: One-time project
Section: Other / Miscellaneous
Prepayment: without prepayment
Payment methods: Bank transfer
Acceptance of requests: closed
Project description:
Simple macro.
The macro must edit the input data for the summary and simultaneously update the summary table.
Type of Place Material Party Add Add Add to Take the Number
016 01 50020630 1010734
Write data on the goods (type, place, material, lot) and if the goods are added, in the field "add" we write the weight of the cargo space (200, 180, etc.) which is then transferred to the column of initial data "total stock", and in "Collect-vo" the number of such places, that is, such lines with such a total stock and data on the goods in the table with the initial data. When we take it, we simply write data on the product (type, place, material, lot), tick the tick “take” and “Collect” – the number of lines that will then be deleted in the original data for this product. And then update the summary table. Click "execute" and how it should work.
And messboxes for mistakes. If you successfully add, for example, "Ready" If we try to pick up a product that is not there, there is also something of the type "This material is not." It is also necessary to take into account that on the sheet "data" type, place, material, party - these are numbers in text format, that is, before them an apostrophe. When adding, you need to take into account that the summary correctly summarizes everything.
Simple macro.
The macro must edit the input data for the summary and simultaneously update the summary table.
Type of Place Material Party Add Add Add to Take the Number
016 01 50020630 1010734
Write data on the goods (type, place, material, lot) and if the goods are added, in the field "add" we write the weight of the cargo space (200, 180, etc.) which is then transferred to the column of initial data "total stock", and in "Collect-vo" the number of such places, that is, such lines with such a total stock and data on the goods in the table with the initial data. When we take it, we simply write data on the product (type, place, material, lot), tick the tick “take” and “Collect” – the number of lines that will then be deleted in the original data for this product. And then update the summary table. Click "execute" and how it should work.
And messboxes for mistakes. If you successfully add, for example, "Ready" If we try to pick up a product that is not there, there is also something of the type "This material is not." It is also necessary to take into account that on the sheet "data" type, place, material, party - these are numbers in text format, that is, before them an apostrophe. When adding, you need to take into account that the summary correctly summarizes everything.
