Forum Discussion
VBA to update the formula in a cell based on last data in a drop down list
1. In column R of my worksheet is a drop down list of items. I can determine its last row of data by: Dim LastRow As Long With ActiveSheet LastRow = .Cells(.Rows.Count, "R").En...
for a much better understanding of the scenario,
Whenever column D (item) is entered - its classification will be indicated at column F.
kindly see below images...