Wednesday, April 10, 2013

yogi_Summarize In yogi_Sheet1 Data For Different Attributes In Specified Rows Of Column A Of various Sheets Named Sequentially As Sheet2 Sheet3 Sheet4 and so on


                                          Google Spreadsheet   Post  #1107
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Apr 10, 2013
user Nathan S. :(http://productforums.google.com/forum/?zx=ik561dw2e7n8#!mydiscussions/docs/bbfPIo666Lo)
Increment Sheet with Autofill
I want to have my first sheet be a summary of the rest of my sheets. All the sheets except the first one would follow the exact same format and be for different groups. So for example I would want a column on sheet 1 that goes =Sheet2!A1,=Sheet3!A1,=Sheet4!A1 and so on. This way I can get a basic summary of all the sheets on one sheet and if I want more detailed I can go to the individual sheet. I was hoping there is some way I can auto fill this because none of the ways I've tried so far have worked.
---
It would looks something like this except it would have a lot more data. Notice that as you go down a column only the Sheet increments.
---------------------------------------------------------------------------------------------------------
following is a solution to the problem based on your supplied data

1 comment:

  1. HTML Attributes are property of the elements which may have values and these attribute values are always enclosed in quotes. It’s providing to the browser with some additional information about an elements how the elements should appear or behave. HTML elements can contain one or more attributes, attribute names and attribute values are case-insensitive and separated by an equals (=) sign.

    [HTML Attributes](http://www.willvick.com/HTML/HTMLAttribute.aspx)

    [HTML Attributes Examples](http://www.willvick.com/HTML/HTMLExampleAttribute.aspx)

    [Youtube - HTML Tutorial - Attributes](http://www.youtube.com/watch?v=ucOXvaCEZgg)

    ReplyDelete