View Single Post
 
Old 12-02-2015, 06:04 AM
TomG9876 TomG9876 is offline Windows 7 32bit Office 2000
Novice
 
Join Date: Dec 2015
Posts: 2
TomG9876 is on a distinguished road
Default Enter Data in either of 2 columns?

I would like to enter data in either of two columns and have it appear in the other. Consider a vacation spreadsheet. If "Column A" were hours and "Column B" were Days I would like to enter "8" in "Column A" and have "1" appear in "Column B"; or I would like to enter "3" in "Column B" and have "24" appear in "Column A". How can I do this without getting a circular error?

Thanks Tom G
Reply With Quote