Hey guys,
I am trying to build a conversion table with lets say 3 columns; lbs, ozs, grams. I would like to be able to plug in data to any of the three columns, depending on the unit I am receiving, and have the other two auto generate. The ways that I have tried create circular loops (logically).
I assume this is possible, but not sure, and don't even know what to call it to find the how-to online.
Thanks for the help.
I think you will need to use VBA. Specifically, a Worksheet Change Event Handler monitoring the columns of interest. When something is put in the grams column, it will calculate lbs and ozs. And vice versa.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Perhaps have a 4th column for the answer, so that when you enter in any of the other 2 columns, the 4th gets calc'd? You could even have it include the unit of measure, if you want (or have that ina 5th column?)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks