asked on
Hello To All VBA Gurus,
I am looking for the best VBA way to do this…..
There are two tables: tbl1 and tbl2_divisors
Requirements
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
Thanks
R
divisorLookUp.xlsx
I am looking for the best VBA way to do this…..
There are two tables: tbl1 and tbl2_divisors
Requirements
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
Thanks
R
divisorLookUp.xlsx
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 2 Answers and 13 Comments.
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 13 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.