Sunday, October 21, 2012

yogi_Extract Info For A Specified File Number From Database Into Client Viewer

Yogi Anand, D.Eng, P.E.      Google Spreadsheet   Post  #818  Oct 21, 2012

user Eli noob said: (!search/Eli$20noob/docs/eohWDpuxeJ8/5m9U9NKgT20J
Make all the cells in Sheet B all shift there reference to Sheet A at the same time. 

I just want Sheet B to show me the data from one row at a time of Sheet A (Sheet B will be formatted to make the data more accessible visually).  Is there a way to make all the cells in Sheet B retainer the column values but simultaneously change to the same row value?  Sort of liek a customized "List View" I guess.  Is this possible for a noob?

So if the database page is just the dumping ground for data, the client viewer page is where I can view one client at a time.  I would like to be able to change the File Number cell on the viewer sheet and have all of the info in the other cells shift with it.  SO if the file number is 1234, the other cells should be populated with Joe Blow's data.  But if the file number cell shows 1235, then the data in all the other cells should reflect information about Jane Crane.

Does this explain it?
following is a solution to the problem