Hi everyone, and Happy New Year! I was hoping to for some assistance with a problem.
Basically, all I would like to do is run a macro that grabs data from another worksheet.
Please see attached.
In WORKSHEET, there is a blue highlighted area. Those cells should be populated with data in the Parts Usage tab. Basically, column D should list a Part, column E the Quantity, and column F the Price or rate.
The desired result is in the Result tab. I basically just entered a formula then autofilled down and across. Is there a way to do this in VBA? Any suggestions would be much appreciated.
Bookmarks