Wednesday, September 5, 2012

yogi_Publish Two Sheets Of A Spreadsheet As separate Web Pages


Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #734   Sep 05, 2012     www.energyefficientbuild.com.

user jjspierx said: (http://productforums.google.com/forum/?zx=alk42vs49d24#!category-topic/docs/spreadsheets/KUrDGzDtC_A)
Export 2 sheets in same spreadsheet as web pages - I can only get one to export 
....
I have two worksheets that have linked data.  I would like to be able to publish both sheets to embed on a website, on 2 different pages, but only the most recently published page linked works.  So I can't just hide an sheet, as I need the info from both sheets.  And I can't separate the sheets into two workbooks, because I am linking data between the sheets.  Is my only option here to have the data combined onto one webpage?  This would be highly undesirable, but if need be, I guess that is what I will have to do.  I was hoping somebody else had another idea that would allow me to display the data from both worksheets separately on 2 different web pages.  

Thanks in advance for any suggestions anyone has to offer.
----------------------------------------------------------------------------------------

following is a solution to the problem

This is Sheet1 -----------------------------------------------------------------------
and here is Sheet2 -----------------------------------------------------------------------