I would like to learn a way to utilize VBA in leu of Multiple Excel Spreadsheet SUMPRODUCT Formulas crammed into one cell. On Worksheet("DataTable") I have a multiple columns with the Hull Number of the Boat at the top of each column in Row[3]. Each column records the Boats Condition Status for that day ( FMC / PMC / NMC / NMR / MAV ). These columns have approx 4 years worth of Condition Status' recorded. I want my variant { Boat Hull No. located in Worksheet(DataList).Row[3] } to be selected by a drop-down, located on Worksheet(DataResults), then later selected by hopefully a User Form. but I just can't seem to figure out how to write a code to do this.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Locate Varr Selected in Drop-Down In Row [3] and Select That Column as CountIf Range
- Thread starter MKCSRet
- Start date
Similar threads
- Question
- Solved
