Yogi Anand, D.Eng, P.E. Google Spreadsheet Post #818 Oct 21, 2012 www.energyefficientbuild.com.
user Eli noob said: (http://productforums.google.com/forum/?zx=9jrp4o21m1am#!search/Eli$20noob/docs/eohWDpuxeJ8/5m9U9NKgT20J
Make all the cells in Sheet B all shift there reference to Sheet A at the same time.
user Eli noob said: (http://productforums.google.com/forum/?zx=9jrp4o21m1am#!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?
Eli
---
https://docs.google.com/
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
