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
How to create a monthly report?
ReplyDeletePlease help
https://docs.google.com/spreadsheet/ccc?key=0Am5GTjwDOT49dC03M24xeDVQUUlZTDhnVUZ0d3FaRWc
Hi Mohamed Hanafy:
ReplyDeletetry
=query(index(A:E),"select month(Col1)+1+year(Col1)/10000,count(Col3) where upper(Col2)='N' group by month(Col1)+1+year(Col1)/10000 pivot Col5 label month(Col1)+1+year(Col1)/10000 'month.year' ")
I will illustrate this in a blog post and provide the link to that here for you.
Cheers!
Yogi
Cloud Computing -- Google Docs Way
yogi--anand-consulting.blogspot.com
Hi Mohamed Hanafy:
ReplyDeleteI have created an illustration for you in my following blog post:
yogi_Compute Number Of Done Hot Open And Total Jobs For Specified Employee By YearAndMonth
http://yogi--anand-consulting.blogspot.com/2012/10/yogicompute-number-of-done-hot-open-and.html
please note I have changed the solution a bit from the formula I gave you in my preceding response to your comment.
Cheers!
Yogi
Cloud Computing -- Google Docs Way
yogi--anand-consulting.blogspot.com
Excellent post, I will be checking back regularly to look for updates.
ReplyDeleteHosted IP
Great Irene_J ... Now Let Us Keep Googling.
ReplyDeleteCheers!
Yogi
Cloud Computing -- Google Docs Way
yogi--anand-consulting.blogspot.com