Hello To All VBA Gurus,
I am looking for the best VBA way to do this…..
There are two tables: tbl1 and tbl2_divisors
Tbl1 has a total column that needs to be converted to three other columns via dividing by a specific number. That specific number is specific to a prod. TBL2_Divisors has the three divisors type isted in three columns for a one each prod.
Need to a VBA to do the following:
• If E5 has a value, and
• Look up the divisor for the combination of (prod + convert) in tbl2_divisor
• Then divide E5/looked up and put in F5.
• Likewise do the same for G and H as well.
• Do the above for all the elements in column D