Curious as to the quickest way to accomplish this task from some automation veterans. I have some experience programming but new to VBA and automation.
Project Details:
Excel Workbook Size: 100-10,000 rows, 10-15 columns
Data is dumped and formatted as follows:
(A1, B1, C1) --> (Description, Dimension, Cost)
The only identifiers are the description and dimension, no SN or anything like that. The issue I have is some of the items include the cost, but some do not.
For example. Item 1 may be a (Box, 2x2, $15) and Item 2 may also be a (Box, 2x2, " ") - with no cost showing. Item 3 may be a (circle, R=5, $20), ... etc.
What I would like for this Macro to accomplish is -
1. IF the cost is already included, all matching items with the same dimension AND description will have its cost value automatically populated (so after running the macro, Item 2 would say (Box, 2x2, $15))
2. IF the cost is not included AND there are no matching items in the list with a cost associated, the user would have to input this item's cost. After the user inputs a cost, they could run the macro again and if there are any identical items below --> see point 1.
Notes: the user will likely go from top-to-bottom through the data until all costs are filled out. You can see the benefit of automating this. Currently, the process used is: filter individual items>input cost>drag&drop to populate. This is very taxing when there are dozens of unique items, some with cost and some without. This process will be different for every project. So some projects may be shapes in the description and others may be animals and so on. That being said, the code should be as generic as possible. I think a macro is definitely the tool for the job. So far I have been experimenting with Index matching, but if you guys have any suggestions or have a project that does something similar that you would be okay with sharing feel free to chime in. Thanks!
Cheers,
Luke
Bookmarks